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; } } }

Advanced filters stripping parenthesis

Ari Brown

Hi All,

I'm using a saved search filter to power my Agile boards. It is a rather complex set of ANDs and ORs as it combines information from three different projects. When I save the filter, however, Jira strips out all the parenthesis. I think I'm getting additional results because of it. Is there something I can do to preserve the exact search I entered instead of simplifying it? Thanks!

Accepted answers

StevenA

Hi Ari,

May we know that did the search result change? Because the AND operator actually connect 2 variables, so it is not necessary to have parentheses at all, the system just remove redundancy items to enhance the JQL search request.

For example, X1 OR (X2 AND X3) would be same with X1 OR X2 AND X3

Best Regards,

Steven

All comments

StevenA

Hi Ari,

Can you let us know the exact JQL on your filters in order to enable us to see how Jira strips out all the parenthesis?

Best Regards,

Steven

Ari Brown

Hey Steven - thanks for getting back to me. The actual query (slightly obfuscated to remove personal info) should be:

project = "Dev Platform" OR (project = "Splunk Server" AND assignee in (username1, username2, username3, username4)) OR (project = "Microsoft Apps" AND component = Palette)

But when I save, Jira flattens it to:

project = "Dev Platform" OR project = "Splunk Server" AND assignee in (username1, username2, username3, username4) OR project = "Microsoft Apps" AND component = Palette

Any thoughts?

StevenA

Hi Ari,

For example, X1 OR (X2 AND X3) would be same with X1 OR X2 AND X3

Best Regards,

Steven

Ari Brown

So JQL just implies parens on either side of the AND statement? Confusing but acceptable. Just makes things a bit harder to read. Thanks Steven. My problem must be elsewhere.

Michael Bovilsk1

My opinion is that the parenthesis should not be stripped because they aid with readability. Especially, given not every user understands this functionality.

Nyamdavaa

Really? are you joking on me

Gautham Hari

You could save them as separate filters and then combine them using the following query:
filter = "filter 1" OR filter = "filter 2"
It would be easier to read, understand the results and to troubleshoot.

Welcome!

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

Quick Links

Find more posts tagged with

jql

filter

query