Is there a way to get a list of all labels being used in a single JIRA project?

DI2E Licensing
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 18, 2014

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.

Thanks,

Karla

3 answers

14 votes
Henning Tietgens
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 14, 2014

For JIRA versions, where there is no labels tab for projects, you can add a labels gadget to your dashboard and select a project within this gadget to get all labels used in a project.

Andrew Dapkiewicz October 20, 2014

Thank you, this worked like a charm.

Matthew Kerle March 8, 2015

sorry, dumb question, how do you do that? does the labels gadget need to be installed or just configured?

Like # people like this
Ariel Allon June 7, 2021

The above link is now to a list of gadgets.

How to add a (generic) gadget is now here: https://confluence.atlassian.com/jiracoreserver073/adding-and-customizing-gadgets-861257074.html

1 vote
Henning Tietgens
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 19, 2014

If you go to the project page there is a tab for Labes where you can see all labels used in this project.

Ramon Padilla October 14, 2014

This option is not present in JIRA v6.3.6.

Abhimanyu Gadroo November 16, 2017

Yes can't see that option anywhere. Need a quick answer on this. Please Update.

0 votes
Leonard Chew
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 5, 2018

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, 
l.label label,
cf.cfname customfield,
count(*) occurrences
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;
kondratiev February 6, 2019
select ji.issuenum,ji.reporter,ji.creator,ji.summary,ji.created,l.label from jiraissue ji 
left join label l on (ji.id = l.issue) where ji.project = 00000 order by ji.issuenum;

2019

for Jira  ~ 7.7, change 00000 to your project id

Like GI account likes this

Suggest an answer

Log in or Sign up to answer