CAUTION: heavy queries could cause crashes!
...
- 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') |
...
Get the add-on key information from the Manage add-on administration page:
| No Format |
|---|
SELECT workflowscheme.name AS "Workflow Scheme", workflowschemeentity.scheme, issuetype.pname AS "Associated Issue Type", workflowschemeentity.issuetype FROM issuetype, workflowschemeentity, workflowscheme WHERE issuetype.id = workflowschemeentity.issuetype and workflowscheme.id = workflowschemeentity.scheme and workflowschemeentity.workflow in (SELECT jiraworkflows.workflowname FROM jiraworkflows WHERE jiraworkflows.descriptor like '%org.swift.jira.cot%'); |
...