sql query for finding if a filter shared with a given project key

[Umair Haroon]

Hi .

I have a list of projects (PROJECT KEYS).

I would like to know the sql query for a given project key such that it lets me know the filter, if that filter was shared with that project.

As the list of project keys is long, I cant do this manually via gui.

Thankyou

Umair

[Nic Brough -Adaptavist-]

It's going to be ugly and probably give you false positives, but look in the table "searchrequest".  The plain strings of filters are in there, so you'll need to parse them for "project =" and "project in" type things