How can i get the list of Label suggestions for a particular custom field?

Question

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!

Udo Brand · Accepted Answer

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