Customer export list

unknown

Hi,

Does it exist a way to export the customers of only one project ? 

I don't find it on the GUI. Maybe with request on the database or with the creation of a plugin.

Somebody have an idea ?

Best

Keri

Hey Valerian,

 

You can grab this information from the database, here’s the query I used, although you might need to modify this for your database type:

 

SELECT p.pname, pr.NAME, u.display_name

FROM projectroleactor pra

INNER JOIN projectrole pr ON pr.ID = pra.PROJECTROLEID

INNER JOIN project p ON p.ID = pra.PID

INNER JOIN app_user au ON au.lower_user_name = pra.ROLETYPEPARAMETER

INNER JOIN cwd_user u ON u.user_name = au.user_key

WHERE pr.NAME = 'Service Desk Customers' AND p.pname = 'IT Service Desk';

 

In my example, the project name is IT Service Desk, or you could switch this to use the project key instead of the name, for example p.pkey = 'ISD'

 

I took this from the following KB article: How to get a list of users assigned to project roles for your project It can be modified for any role or project.

 

Hope this helps!

 

Cheers,

Keri