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

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
AUG Leaders

Atlassian Community Events