sql Query to fetch the project name in shared filters

[sasis]

Hi,

Any one have idea about sql Query to fetch the project name in shared filters

ie if filter name is fdpio which consists project =xyz

i would like to get the filters with particular value xyz

[Alexey_Rjeutski__Polontech_]

You can search for filters in table searchrequest.

As for the query, you can use something like

SELECT filtername FROM searchrequest WHERE reqcontent LIKE '%xyz%';

but that will give you a lot of false alarms. As jira uses jql query string to keep the filter query that can be interpreted in a big set of ways - creation of such universal query seems to be impossible.