Is there a way using username to return the projects a user has a role in and also return this role?

Question

I am working to find a way, through PostgreSQL queries or ScriptRunner for Jira, to search using a username or email address and return the projects a user has a role in, along with their specific roles in these projects. I have tried to relate multiple tables from the database (project, projectroleactor, projectrole, and cwd_user) but have not had any success. Has anyone worked on this topic before?

Bobby Bailey · Answer

Hi @Hossam Ahmed Mohamed ,

I wrote this script that allows you to define a user and outputs their roles for each project in an instance:

You can find the code here: https://bitbucket.org/Adaptavist/workspace/snippets/BzXKAx

Does this help?

Kind regards,

Bobby