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.
"Filter in ("123457, 784668, 184675,184524,188946" " When You use this Filter That time All Issues Are Displaying
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.
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.
It looks like you're new here. Sign in or register to get started.