Versions Compared

Key

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

...

Code Block
languagesql
SELECT 		CF.cfname, count(CV.ISSUE) 
FROM 		customfield CF 
JOIN 		customfieldvalue CV on CF.ID = CV.CUSTOMFIELD
GROUP BY 	CF.cfname


Return screens where

...

a given SYSTEM field is used (not for custom fields)

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'

...

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


Return saved filters that have a given customfield set as a column

Code Block
SELECT SR.filtername, CLI.fieldidentifier 
FROM columnlayoutitem    CLI
INNER JOIN columnlayout  CL  ON CLI.columnlayout = CL.id
INNER JOIN searchrequest SR  ON CL.searchrequest = SR.id
WHERE CLI.fieldidentifier IN ('customfield_16165'); --'supervisor' custom field