nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Possible to export list of labels?

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!

Accepted answers

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

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

All comments

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

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

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;

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

Do an advanced search for: labels is not EMPTY
Export ALL results
Remove all columns apart from Labels column
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.

ilker yıldırım

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

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration