Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Possible to export list of labels?

Deleted user April 3, 2014

Is it possible to programatically export a list of labels, specifically the custom field of "label" type? We want to publish the current lables to an internal wiki page. Thanks!

4 answers

1 accepted

1 vote
Answer accepted
Udo Brand
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.
April 3, 2014

You would need to run a sql query on your JIRA database

select distinct label from label where fieldid = <YourCustomFieldID>;

2 votes
Umer Saeed
Contributor
August 6, 2015

Here is how I did mine, without having access to the JIRA Database.

  1. Do an advanced search for: labels is not EMPTY
  2. Export ALL results
  3. Remove all columns apart from Labels column
  4. From the labels column, remove all duplicates using this guide:
    1. https://support.office.com/en-us/article/Filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2

Hope that helps.

 

Penny Boulet April 25, 2020

This only works if you have a small number of 1ssues. If you have 15000+ issues you have no hope of getting a list of all your labels

1 vote
ilker yıldırım
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 23, 2016
0 votes
Andris Grinbergs
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.
April 3, 2014

Another option - if you don't know fieldid:

select distinct LABEL.LABEL

from CUSTOMFIELD, LABEL

where (customfieldtypekey = 'com.atlassian.jira.plugin.system.customfieldtypes:labels')

and (CUSTOMFIELD.ID=LABEL.FIELDID)

order by LABEL.LABEL;

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, loom, loom for training, loom for teaching, video training, async learning, online education, screen recording, loom tutorials, loom use cases, atlassian learning, team training tools, instructional video, virtual training tools

🛗 Elevate Your Training and Enablement with Loom

Join us June 26, 11am PT for a webinar with Atlassian Champion Robert Hean & Loom’s Brittany Soinski. Hear tips, stories, and get your burning questions answered. Learn how Loom makes training and enablement easier. Don’t miss it!

Register today
AUG Leaders

Atlassian Community Events