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