The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to group AND/OR when editing board queries

LoganM
July 22, 2024

Found same issue at: 

https://jira.atlassian.com/browse/JRACLOUD-39107

It is supposed to be fixed, but it isn't for board query editor... 

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Answer accepted
Carlos Garcia Navarro
Community Champion
July 22, 2024

Hi @LoganM ,

Welcome to the Community! Do you see that the results of the query are different after saving it? By reading the description and comments in the ticket, it seems that the resolution was that Jira normalizes the query but the it should work fine. From the developer assigned to it:

After investigating this issue it turns out that the documentation is wrong, not actual implementation in JIRA. This means that operator precedence is taken into account when evaluating JQL queries.

JIRA looses inner parentheses because before executing your query it normalizes it. This results in things like "and" being changed to "AND" and parentheses being put in place only where they are essential to override operator precedence. However resulting query is always logical equivalent of the provided one and should behave the same.

We are currently working on updating the documentation accordingly.

LoganM
July 22, 2024

As far as I know:


a OR ((b OR c) AND d)

and

a OR b OR c AND d

aren't equivalent due to operator precedence.

LoganM
July 22, 2024

Ok, give it a try and I may have messed with parentheses during my tests.

It is nicely normalized to:

a OR (b OR c) AND d
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events