Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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?

Like # people like this

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

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.

0 votes
Leonard Chew Community Leader Jul 05, 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;
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
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you