SQL to find the custom field values filter

Prabhu Prabhakar

Hi 

I've a single select custom field with some options. There are many filters made from different peoples by the custom field values. 

I got a request to replace/change the values of the custom field, but If I replace/edit those values I have to change the saved filters as well.

Is there any SQL that would help me to find the filter by the values? 

I have one but it would fetch all the values that belong to that. 

Eg.

• Select * from searchrequest where reqcontent like '%Client Experience%'
  • Client Experience is the one of the value of the custom field. 

Please help me to resolve this.

 

Thanks,

Praba

 

KAGITHALA BABU ANVESH_z1zl10

Hi @Prabhu Prabhakar ,

 

in the below link, someone motioned about adaptive script runner can give outputs.

Not sure about the code, The answer is accepted. Can you please check this once 

https://community.atlassian.com/t5/Jira-questions/How-to-find-all-JIRA-filters-that-include-JQL-for-a-custom-field/qaq-p/732061 

 

and someone mentioned the below App, have that feasibilities --> https://marketplace.atlassian.com/apps/1215065/subscriptions-for-jira-filter-manager?tab=pricing&hosting=server 

 

if I found any SQL, will add to this comment thread.

 

Thanks