...
| Code Block |
|---|
SELECT cfo1.customvalue "Parent Option", cfo2.customvalue "Child 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 all instrument tickets with their summary and instrument name field (JiraDWH was designed for this but here is the raw SQL)
| Code Block |
|---|
SELECT p.pkey||'-'||j.issuenum as Key,summary,cfv.stringvalue AS "Instrument Name"
FROM jiraissue j
join issuetype i on j.issuetype = i.id
join customfieldvalue cfv on cfv.issue = j.id
join customfield c on cfv.customfield = c.id
join project p on j.project = p.id
where i.pname = 'Instrument'
and c.cfname = 'Instrument Name' |
Return changeitems (including before and after values, as well as modification date) for issue TEST-106
...