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

Jeff Dun July 21, 2013

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!

1 answer

1 accepted

2 votes
Answer accepted
Udo Brand
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 21, 2013

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

Jeff Dun July 21, 2013

Great - it works!

Thanks Udo.

Cheers Jeff

Suggest an answer

Log in or Sign up to answer