Page Comparison

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

...

Return a user's (biasella) favorite filters along with the JQL behind the filter

SELECT si.filtername, dbms_lob.substr( si.reqcontent, 4000, 1 ) as JQL
FROM favouriteassociations fa
JOIN searchrequest si ON fa.entityid = si.id
WHERE fa.username = 'biasella';

Return filter name and JQL given a filter id e.g. filter=15191

SELECT si.id, si.filtername, dbms_lob.substr( si.reqcontent, 4000, 1 ) as JQL
FROM favouriteassociations fa
JOIN searchrequest si ON fa.entityid = si.id
WHERE si.id = 15191

Return information from jiraissue table given a list of quoted comma separated issue keys 

...

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