...
| Info |
|---|
More examples: SQL queries for Jira from Atlassian |
Return contents of Instrument custom field (cascading select list)
| Code Block |
|---|
SELECT cf.cfname "Field Name",
cfo1.customvalue "Primary Option",
cfo2.customvalue "Secondary Option"
FROM customfield cf, customfieldoption cfo1, customfieldoption cfo2
WHERE cfname = 'Instrument'
AND cf.id = cfo1.customfield AND cf.id = cfo2.customfield
AND cfo1.parentoptionid is null
AND cfo2.parentoptionid = cfo1.id |
Return changeitems (including before and after values, as well as modification date) for issue TEST-106
...