Is there a way to get a list of all labels being used in a single JIRA project?
I need a concise list of all labels in use. Rather than including a label column in the issue list view and go page by page, writing them down.
I'd be happy with a SELECT query.
And this would be the sql select statement to list them directly from the database.
Project is the project key.
The field "customfield" is the customfield of type "label". If customfield is empty, its a "normal" label.
Occurrences is the number of occurences :-).
select p.pkey project,
from jiraissue ji
join project p on (ji.project = p.id)
left join label l on (ji.id = l.issue)
left join customfield cf on (l.fieldid = cf.id)
where l.label is not null
group by p.pkey, l.label, cf.cfname
order by project, label;
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in talking to 20 people planning t...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs