...
| 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 or system field 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 ('summary','customfield_16165'); --'supervisor' custom field |
...