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

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

This widget could not be displayed.
Henning Tietgens Community Champion Oct 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.

Thank you, this worked like a charm.

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

This widget could not be displayed.
Henning Tietgens Community Champion Feb 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.

This option is not present in JIRA v6.3.6.

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

This widget could not be displayed.

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;

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted yesterday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

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...

78 views 1 0
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you