How to fetch Filter Query present in "Configure Board" (or) "Configuration Board"

[Bhanu Prakash]

Hello Everyone, 

Filter Query navigation : 

Go to Jira Active Board==> Click on "Configure Board" dropdown ==> Search for "Filter Query")

Question: 
We have More than 5000+ Filter Queries, We want to see what is the query for all of these Filter Queries. Is there any possibility to fetch this information without having to manually go to all 5000+ queries and open the Filter Query. May be via REST API?? IF Yes, please provide steps on how to fetch the data.

[Bill Sheboy · Accepted solution]

Hi @Bhanu Prakash 

That is possible with a REST API function, and the expand=JQL parameter.  Although that would be quite cumbersome to do for 5000+ filters as you would need to page through them.  A better approach might be to write code or a script to iterate the pages, or use a marketplace addon.

For more information about using that REST API function approach, please review this recent question: https://community.atlassian.com/t5/Jira-Software-questions/Hey-I-would-like-to-change-a-value-rename-in-a-custom-field/qaq-p/2617507

Kind regards,
Bill

[John Funk]

Hi @Bhanu Prakash  - Did you get this to work?

[Bhanu Prakash]

@John Funk ,

Yes, I was able to fetch using the below. But it was cumbersome. If there is a easier way to do it., I am still open to it. 

yourJiraUrl/rest/api/3/filter/search?expand=JQL&maxResults=100&startAt=0

yourJiraUrl/rest/api/3/filter/search?expand=JQL&maxResults=100&startAt=100

yourJiraUrl/rest/api/3/filter/search?expand=JQL&maxResults=100&startAt=200

...

yourJiraUrl/rest/api/3/filter/search?expand=JQL&maxResults=100&startAt=5000