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

SQL: Amount of users with a certain role for every project

Andreas Lorz

Hi,

I want a list of projects and the amount of users in that project that have a certain role.

Is there a SQL query which i can use or is there an other way to retrieve that information from Jira (e.g. API)

Thanks in advance.

Andreas

Accepted answers

All comments

There are no accepted answers yet

Welcome!

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

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

server

jira-software

jira-software-server