Get jira custom field's *selected* option

[Vadim]

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...

[Nic Brough -Adaptavist- · Accepted solution]

The 5 digit number you've found is the ID of the option in the customfieldoption table.  You were almost there 

[Daniel Faba]

The refence you found is from table customfieldoption.  Do a select there filtering by the field id.