JIRA filter and Query

[Ganesamoorthy S]

One of my leads have created a filter which many subfilters

E,g: filter in (123457, 784668) AND filter not in (184675, 184524, 188946)

My ask is how to view the QUERY behind 123457, 784668, 184675, 184524 and 188946.

[Tarun Sapra]

Hello @Ganesamoorthy S 

It's easy to view the source JQL of the filters, since you already know the filter ID based on the JQL you have described thus you can open each filter in it's own browser tab by accessing this URL

https://<Your-Jira-BAse-ulr>/issues/?filter=123457

instead of <You-Jira-base-url> enter the URL of your Jira instance and then you can access each filter and see the corresponding JQL query of each filter.

[Tom Lister]

Hi @Ganesamoorthy S 

If you need to identify the filters behind the numbers, there are two methods I use.

Easy option is to use SQL to list the searchrequest table in Jira database if you have access.

If you don't have access, then in the manage filters screen, hovering over a  filter link will show the id in the URL shown at bottom of page.

[PVS]

"Filter in ("123457, 784668, 184675,184524,188946" " When You use  this Filter  That time All Issues Are Displaying