Versions Compared

Version Old Version 37 New Version 38
Changes made by

Rafael Sanchez (Deactivated)

Amy Biasella

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
SELECT screen.name 
FROM fieldscreenlayoutitem layoutItem 
INNER JOIN fieldscreentab tab 	on layoutItem.fieldscreentab = tab.id
  INNER JOIN fieldscreen screen on tab.fieldscreen = screen.id
  WHERE fieldidentifier = 'priority'


Return remote links (other Jiras,Confluence,Websites) and what page they're on

Code Block
languagesql
SELECT p.pkey||'-'||j.issuenum as Key, a.title, a.url,
       a.iconurl, a.icontitle, a.relationship, a.applicationtype, a.applicationname
  FROM remotelink a
  JOIN jiraissue j on a.issueid=j.id
  JOIN project p on j.project = p.id