I find in the official documentation of jira here How to list all users by project role in Jira
a sql query to list all users by role in a project.
But I don't understant why they use UNION of 2 select , i understand the first "SELECT" but the second no and what is "
Is there any one of you have an idea ?
Hi @Marine Tm I think it is described in the how to article :). I will try to describe it better... You can assign user to project's role in these ways:
cwd_membership table contains relationship between Jira Groups and Jira Users. And UNION is here to have every "row" only once because user Tom Hanks can be in role Administrators using user and group (so twice in sum).
Let me know if you need more help :)
Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events