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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.