find filters using fixversion?

[Raju Anumula]

Hi,

We are going to change our fixversion values, we know that people have used filters and quick filters using the old values. Is there a way we can query in our project to find those filters that should be changed?

thanks

[Alexey Matveev · Accepted solution]

Hello,

You can open the Jira database and query the searchrequest table. Your query would be like this:

SELECT * FROM SEARCHREQUEST where REQCONTENT like '%fixVersion%'

[Raju Anumula]

Hi @Alexey Matveev,

It is not working(we are using Postgres), any alternate option?

Thanks in Advance.

[Alexey Matveev]

What s the error?

[Raju Anumula]

Sorry, it is working as expected.

Thanks @Alexey Matveev