Relation tables between filters, gadgets and dashboards

[VVC]

The requirement is for renaming the issue type which is to know to have some consequences in JIRA that I'm aware. Using Configuration manager addon > Power Admin module, I was able to list out all filters that has the references of this issue type old name. Now I need to find the source of these filters to extract the related gadgets and dashboards.

This would help for me to notify the impacted dashboard editors in regards to renaming  an issue type. Could anyone share this working SQL query please?

[VVC · Accepted solution]

I can't seem to find a JIRA DC ERD specifically showing the relations between Dashboards, Gadgets and Search Filters.

[VVC]

I don't think this is needed, as the owner information is published on the filters results set matching to the referenced keyword in the third party addon. Notifying the owners to make this flip should do the trick.