Is there a way to see who has marked a filter as a favorite?

[Danielle Mora]

When viewing shared filters, I see a column that says Popularity. The filter that I was going to delete says Popularity = 2. How do I find out WHO has marked this filter as a favorite?

[Angélica Luz · Accepted solution]

Hi Danielle,

Currently, Jira only stores who saved the filter in the database, so, unfortunately, it's not possible to search for users who have saved the filters.

The field Popularity is used only to have an idea of how many users have marked the filter as favorite.

I'm sorry that we can't be more helpful on it.

If you have any other question, please let us know.

Regards,

Angélica

[Danielle Mora]

Thank you!

[Amy Biasella]

If you have database access, you can find out who favorited it given either the filter name or the ID. 

Assuming the name is MyFilter:

SELECT f.username, sr.filtername, sr.id
FROM favouriteassociations f
JOIN searchrequest sr ON f.entityid = sr.id 
WHERE f.entitytype = 'SearchRequest' 
and sr.filtername = 'MyFilter'
--and f.entityid = 10001

(The last line is commented out - uncomment it if you know the filter ID instead and comment out the line that has the filter name. This is useful if you have filters with identical names like "Assigned To Me" and want to query a specific one.)