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; } } }

List all the jira proejcts with its groups and users

Reneesh Kottakkalathil

Looking for a SQL query to list all the Jira projects with its users and roles.

Accepted answers

Thomas B

@Reneesh Kottakkalathil - try this

SELECT project.Id, project.pname, project.pkey, projrole.PROJECTROLEID, projrole.ROLETYPEPARAMETER
FROM [jiradb].[dbo].[project] as project
JOIN [jiradb].[dbo].[projectroleactor] as projrole
ON project.Id = projrole.PID
Order by pname ASC

If you want to pull in project leads just add project.Lead

All comments

Thomas B

@Reneesh Kottakkalathil - try this

If you want to pull in project leads just add project.Lead

Reneesh Kottakkalathil

Excellent! Thanks so much @Thomas B

Thomas B

Awesome @Reneesh Kottakkalathil glad it worked. Please accept the answer if you can.

Reneesh Kottakkalathil

@Thomas B Answer Accepted. Thanks.

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server