...
Code Block | ||
---|---|---|
| ||
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 | ||
---|---|---|
| ||
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 | ||
---|---|---|
| ||
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 |