I am trying to do impact analysis of a Jira instance to see where (and whether) a user-installed add-on's custom fields are referenced by filters. I know the searchrequest table contains the underlying JQL of the filter, and thus can see if a field is referenced in the JQL itself, but what tables do I traverse to see if a custom field is referenced in the columns returned by a saved filter?
Thanks!
Figured it out:
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_10880','customfield_11280','customfield_10680');
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.