Use caution when querying a JIRA DB directly as heavy queries (e.g. multiple joins) could cause crashes.
...
Return information from jiraissue table given a list of quoted comma separated issue keysÂ
To create a comma separated list from an excel column e.g. if you have a bunch of JIRA records:
- Copy the desired column out of excel and paste directly into Word.
- In Word, press Ctrl+H (find and replace). Find ^p and replace with ,
| No Format |
|---|
SELECT p.pkey||'-'||I.issuenum as "KEY",summary,created,updated,reporter,creator
FROM JIRAISSUE i
JOIN project p ON I.project=p.id
WHERE
p.pkey||'-'||I.issuenum in
('PICO-5910','KIT-98') |