nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to display the JQL for a filter?

John Smart

Folks - apologies if the following has been asked many times. I was not able to find it.

When I create filters in JIRA, the JQL is easy, and for my filters I can see the syntax used, like:

project = MYTEAM AND labels = Accessibility AND status not in (Closed) AND type = Story

But for filters shared by my coworkers, I can access a filter, but the query textbox is reduced to something like:

filter=91274

In JIRA, I can see the matched tickets, but how do I find out the JQL criteria that resulted in those matches?

Thanks for your patience.

John

Accepted answers

Gemma Clark_1tbpgl

QUICK FIX

When opening a filter from Confluence you will be directed to a URL akin to:

https://your.site.com/issues/?jql=filter%3D18011

Simply change this to the following and you'll be able to see the jql for the filter

https://your.site.com/issues/?filter=18011

(Answer edited to correct example URL)

All comments

Matt_oft0zp

Hey John,

You can request the JQL from the filter owner, or I've seen it happen that the ownership gets passed to you ( to get the JQL) and then passed back to the original owner. I would personally just reach out to the owner and ask nicely for the JQL. I'm sure they'll comply .

Nic Brough -Adaptavist-

That doesn't look right to me. If you visit a filter, you get the whole text of it.

It looks to me like your colleagues are sharing a filter that's looking at another filter. Ask them for the actual filter instead of the obscured one.

John Smart

Matt and Nic, thanks for the replies! Unfortunately, at my current company, and at all prior tech firms where we used JIRA, it doesn't show the JQL statement in the filtered JIRA page's UI for any filter that a coworker created/shared. It just shows the filter number, like this:

filter=91274

These are not redirected or secondary filters. This is direct access to the page.

... which is not as helpful, from a usability (UX) standpoint, as it should be. For filters that I create, I do see the JQL for my filters. Good for me, but not for my coworkers. We each rely on filters defined by many others on our teams. Just seeing the filter number in JIRA is not great.

And while I like chatting with my coworkers, asking each one about the JQL defined per filter is not an efficient way to work. Couldn't Atlassian designers do the simple thing and display both the JIRA filter's number and the JQL in the page UI, for any user who's in the auth'd share group?

Thanks for listening. UX matters!

John

Nic Brough -Adaptavist-

There's a problem here - Atlassian already have that. You go to a shared filter, you get the JQL for it, and you can then save it or modify and save it for yourself.

In every version of Jira from Server 4.0 to 7.7 and all incarnations of Cloud, going to a saved filter displays either the simplified selections or the advanced JQL for it.

So, my best guess is that you are NOT going to the filter in the issue navigator, but looking at it from some other place, which is not where you'd normally be editing filters.

Matt_oft0zp

I agree, something is amiss. Could there also be some add-on involved here? John, can you provide a screenshot? Might help us understand what's going on.

John Smart

Thx again guys. I'll post a screen shot after a backlog grooming session at work today.

Carson Price

I was having the same issue and it was driving me mad. In the query line it only said:

filter = 1487

I wanted to know what exactly that was searching for.

So, open any filter, go to the address bar and it will say

https://YOUR SITE.COM/issues/?filter=1511

change the number after "filter=" to the filter who's query you want to see and it will show up in the query bar.

Kelvin Dsouza

I'm having a similar problem,

In mycase, I've picked this filter from a dashboard and I want to find out how this dashboard was created So I clicked on hyperlink and was redirected to this page in JIRA. Here it only shows what the FilterID is but not the actual JQL.

I've tried poking and prodding to try and get the JQL that was used to filter this information to no avail.

Screenshot of my setup

Some of these dashboards were created by people who no longer work with the company so I'm not sure whom to even ask for the original JQL.

Any help would be most helpful!

Carson Price

Carson Price Jan 16, 2019

I was having the same issue and it was driving me mad. In the query line it only said:

filter = 1487

I wanted to know what exactly that was searching for.

So, open any filter, go to the address bar and it will say

https://YOUR SITE.COM/issues/?filter=1511

change the number after "filter=" to the filter who's query you want to see and it will show up in the query bar.

Try that and let me know if it works.

Kelvin Dsouza

Thanks for the heads up @Carson Price

Unfortunately, I got the query from a widget from Confluence so I don't know what the name of the query is, I only know the filterID.

I essentially clicked on one of the numbers from the widget and got redirected to the JIRA screen I attached earlier. where I see the ID but not the JQL.

I've made sure that the URL is https://YOUR SITE.COM/issues/?filter=1511 but not really sure what you're asking me to do next.

Mike Aniskovich

OK, next logical question: how do I find out the filter owner? Jira is like a rabbit warren.

Mike Aniskovich

What a firedrill. Just another example of how confusing and unwieldy this tool is. I curse it every time I try to build something. The architects should be sacked.

Gemma Clark_1tbpgl

QUICK FIX

When opening a filter from Confluence you will be directed to a URL akin to:

https://your.site.com/issues/?jql=filter%3D18011

Simply change this to the following and you'll be able to see the jql for the filter

https://your.site.com/issues/?filter=18011

(Answer edited to correct example URL)

Craig Wyndowe

The persons responsible for sacking the architects have been sacked.

Craig Wyndowe

I think the intuitiveness of changing a URL from "?jql=filter%3D18011" to "?filter=18011" is lost on most people; the Advanced SQL should be displayed whenever the Filter is executed. For what reason should the JQL only reflect the Filter name?

Honestly, would you include this into an operations manual?

"Simply change the URl by doing the following two steps;

1. Deleting the "jql="

2. Replace the "%3D" to "="

Then run the filter.

Also, when presented with only the Filter number, we should be able to search on this number to locate the details of the Filter in the filter results.

Nic Brough -Adaptavist-

Yeah, but no-one bothered to tell the architects that one of the requirements was to make a Klein bottle that didn't look like one.

Most of the question here is about being unable to find out why a query reports a list of issues. The problem here is that computers are fast, logical and dumb, and humans don't really understand that.

Jira search is missing a lot of functions we humans would really like, yes, but most of what we want is there. It's perfectly valid to criticise that (and I do, a lot).

But this is not "confusing and unweildy". You don't have a human-level brain running this stuff. It needs simple and clear instructions on what to report on. If you can't provide that, it's a computer, it's stupid, you need to expect it not to understand vagueness.

Jira can answer clear questions. It fails if we are fuzzy. At least it doesn't lie when it responds. It's not a politician.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-software

jira-server

jql