Hi,
I want to get the list of possible labels for a particular field, so i can add it to a blitz select list.
Is there a way in sql to get this?
I can do it for option lists:
Select customvalue from customfieldoption where customfield = '12101'
but can't find any doco on how to get label options.
Thanks
Jeff
p.s. happy to do it via someother blitz/sil approach if there is one!
Hi Jeff,
the information you are looking for is stored in the table label. If it is a customfield (e.g. ID 12345) of type label you would need following query
select distinct(label) from label where fieldid ='12345';
If it is the standard JIRA label field, fieldid would be null.
For the database docs please see here.
Cheers, Udo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.