How to retrieve Favorite Filters for a specific user via database query
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
To retrieve JQL of Favorite Filters of a specific user through the database, run the SQL query below:
1
2
3
4
5
SELECT si.filtername, si.reqcontent
FROM favouriteassociations fa
JOIN searchrequest si
ON (fa.entitytype = 'SearchRequest' AND fa.entityid = si.id)
WHERE fa.username = 'YOUR_USERNAME';ℹ️ Replace "YOUR_USERNAME" with the username of your choice
Updated on April 8, 2025
Was this helpful?
Still need help?
The Atlassian Community is here for you.