Page Comparison

CAUTION: heavy queries could cause crashes!

...

SELECT f.username, p.pagename as Dashboard, p.id
FROM favouriteassociations f
JOIN portalpage p ON f.entityid = p.id 
WHERE f.entitytype = 'PortalPage' 
and p.pagename = 'QTP Overview'
--and f.entityid = 12272

Return who has 'MyFilter' or filter id of 10001 saved as a favorite:

SELECT f.username, sr.filtername, sr.id
FROM favouriteassociations f
JOIN searchrequest sr ON f.entityid = sr.id 
WHERE f.entitytype = 'SearchRequest' 
and sr.filtername = 'MyFilter'
--and f.entityid = 10001

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

...

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

...