Possible to export list of labels?

[Deleted user]

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!

[Udo Brand · Accepted solution]

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

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

[Umer Saeed]

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]

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

[ilker yıldırım]

https://www.xxx.com/rest/api/latest/search?fields=labels

[Andris Grinbergs]

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;