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') |
...
| 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%'); |
Return how many times a custom field is usedcustom fields and how often they're used (not null in issues)
| No Format |
|---|
SELECT CF.cfname, count(CV.ISSUE) FROM customfield CF join customfieldvalue CV on CF.ID = CV.CUSTOMFIELD group by CF.cfname |
...