nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

MySQL- How to get user information and also their groups

Bernhard Riegle1

Hey,

I would need a MySql query where I get all my users (name,username,email,groups) from the JIRA Internal Directory.

With this query I get all the user information except the groups. But I would need the groups too.

select * from cwd_user where directory_id = 1

THX

Accepted answers

Nic Brough -Adaptavist-

Join cwd_user on to cwd_membership

All comments

Nic Brough -Adaptavist-

Join cwd_user on to cwd_membership

Bernhard Riegle1

@Nic Brough [Adaptavist]Thx for your fast answer. I tried following query:

SELECT *

FROM cwd_user AS cu1

JOIN cwd_user AS cu2

ON cwd_membership

WHERE directory_id = 1;

Now I get the error "Column 'directory_id' in where clause is ambiguous".

Nic Brough -Adaptavist-

Ah, sorry, I should have said - it needs to be joined on lower_child_name = username

Bernhard Riegle1

I still get the same error if I run this query:

SELECT *

FROM cwd_user AS cu1

JOIN cwd_user AS cu2

ON cwd_membership

AND lower_child_name = username

WHERE directory_id = 1;

Did I forget something in my query?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software