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...
The 5 digit number you've found is the ID of the option in the customfieldoption table. You were almost there
The refence you found is from table customfieldoption. Do a select there filtering by the field id.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.