Versions Compared

Version Old Version 4 New Version 5
Changes made by

Amy Biasella

Amy Biasella

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Return information from jiraissue table given a list of comma separated keysissue keys 

No Format
SELECT i.created, i.summary, p.pkey||'-'||I.issuenum as "KeyKEY",summary,creator,resolutiondatecreated,updated,reporter,creator
FROM JIRAISSUE i
JOIN project p ON I.project=p.id
WHERE 
p.pkey||'-'||I.issuenum in 
('PICO-5910','KIT-98')

...