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