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!
You would need to run a sql query on your JIRA database
select distinct label from label where fieldid = <YourCustomFieldID>;
Here is how I did mine, without having access to the JIRA Database.
Hope that helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.