Forums

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

JQL produces all results even if limited to just created >= "-1d"

Casey Golliher
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 8, 2023

using a JQL like <search criteria> AND created >= "-1d" ORDER BY Labels DESC

 

I get all results as if the last AND clause wasn't honored. even if I search by a specific user, I get all users. I'm not sure how to show this, but the JQL doesn't return an error, I just always get all results. My search criteria is:
"Field Priority[Dropdown]" = P2 OR "Field Priority[Dropdown]" = escalation then the AN clause above, is there something i can do to debug this?

1 answer

0 votes
Casey Golliher
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 8, 2023

ah it looks like i missed a () and needed it to be ("Field Priority[Dropdown]" = P2 OR "Field Priority[Dropdown]" = escalation) and createdDate >= "2023/02/01" that results in the proper output. =\

Aron Gombas _Midori_
Community Champion
May 9, 2023

Yes, it was caused by the precedence of the OR/AND operators.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events