Page Comparison

Use caution when querying a JIRA DB directly as CAUTION: heavy queries (e.g. multiple joins) could cause crashes.!

Lots of issue related SQL queries from Atlassian

...

• 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 ,

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')

Returns issues that have a Lucidchart diagram:

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';