Any way to determine which filters are used on dashboards?

Christian Czaia [Decadis AG]

Hey,

I'd like to list all filters and potentially map them to the dashboards they are associated to. I can find all filters in the DB (searchrequests table) but I can't seem to find a link between a dashboard and a filter.

I'd like to determine which filters (my own filters) are being used on dashboards since I want to delete a few of them. The info if a filter is being marked as a favourite is helpful but I'd need the dashboard info aswell.

Any ideas?

Cheers Christian

Christian Czaia [Decadis AG]

SELECT * FROM `jira_prod`.`portalpage` p inner join portletconfiguration c on p.id = c.portalpage 
LEFT JOIN gadgetuserpreference g on c.ID = g.portletconfiguration
LEFT JOIN searchrequest s ON s.ID = SUBSTRING(g.USERPREFVALUE,8,5)   
WHERE USERPREFVALUE 
like "filter%"order by p.ID
;