Get all filters that use a specific query / term?

[Deleted user]

Hello,

I want to get all filters in our instance that use a specific filter function (membersOf) or a specific value for a customfield "Team" in our instance which is a group picker. Is that possible?

Goal: I want to identify all these filters that use that kind of stuff and bulk change them to something new.

Thanks in advance

[Ravi Sagar _Sparxsys_ · Accepted solution]

Hi @[deleted] 

You need to look in the database and run a query like this.

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

Since you have ScriptRunner then you can also go to the ScriptRunner | Resources  | Create Resources

I hope it helps.

Ravi