...
| No Format |
|---|
SELECT si.filtername, dbms_lob.substr( si.reqcontent, 4000, 1 ) as JQL FROM favouriteassociations fa JOIN searchrequest si ON fa.entityid = si.id WHERE fa.username = 'biasella'; |
Return information from jiraissue table given a list of comma separated keys
| No Format |
|---|
SELECT i.created, i.summary, p.pkey||'-'||I.issuenum as "Key",creator,resolutiondate
FROM JIRAISSUE i
JOIN project p ON I.project=p.id
WHERE
p.pkey||'-'||I.issuenum in
('PICO-5910','KIT-98') |