Hi guys!
My jira task has a custom field "SLA". It's type is a "com.atlassian.jira.plugin.system.customfieldtypes:select". I have several options corresponding to that "select". So this is how can I get the specific issue's custom field options:
select *
from customfield cf join customfieldoption cfo on cf.id = cfo.customfield
join customfieldvalue cfv on cfv.customfield = cf.id
join jiraissue ji on ji.id = cfv.issue
where cfname = 'SLA' and issuenum = 189;
But I need to get custom field's *selected* option. Where is this property stored?
Chances are that customfieldvalue.stringvalue is what I search for, but in my case it's a 5-digit number, so probably it's a reference to some other field...
