Can I find out in which dashboards a filter is used?

[Evelin]

Hi,

I like to clean up a little amongst my shared filters and wonder how I can find out if other people used them in their dashboards. Is there a query for such?

Thanks for your attention.

[Tsol · Accepted solution]

If you have scriptrunner you can do it in a indirect way, from change filter ownership built in function you can see the filters that each dashboard uses per user.

Hope that helps

[Evelin]

Hi Kostas, thanks for your answer. We don not have Scriptrunner. Do you know of another way, just with JIRA itself?

[Tsol]

Hi Evelin,

another way is to do a query in JIRA database. A first step to see which filters are used in dashboard gadgets can be done with the following query.

SELECT * FROM gadgetuserpreference WHERE USERPREFvalue LIKE '%filter%'

you can also join tables gadgetuserpreference and searchrequest so you have filter names next to ids.

Hope that helps

[Evelin]

Kostas, thanks a lot. We will try that.

[Tsol]

No prob,

Hope it works.