MS SQL Query for deleting shared Filters

Gantner

I have cloned my production JIRA instance, and now I have got several shared filters, out of which most of them are no use to anyone. I want to delete all the filters, which are linked to concerned project.

E.g Delete filters, which matches to Project X (the X project doesn't is deleted in current instance)

somethingblue

Hi,

In the searchrequest table, the reqcontent column holds the saved query, e.g. I have a save filter titled Branden.  The text in the reqcontent column is as follows:

project = SR and reporter = Branden

You can find the filters that have that project key in the text:

select * from searchrequest where reqcontent like '%DAL%'

You can similarly use a query such as the above to find any text within the search query.

Hopefully that helps!

Cheers,

Branden