CAUTION: heavy queries (e.g. multiple joins) 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 distinct p.pkey || '-' || i.issuenum from propertyentry pe inner join fileattachment fa on pe.entity_id = fa.id inner join jiraissue i on fa.issueid = i.id inner join project p on i.project = p.id where pe.property_key = 'lucidchart.attachment.id'; |
Finding a certain add on used in workflows, e.g. JIRA misc workflow extensions.
Get the com.company.plugin information from the Manage add-on administration page:
| No Format |
|---|
SELECT
workflowscheme.name,
workflowschemeentity.scheme,
issuetype.pname,
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%'); |