Forums

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

created JQL filter not showing tickets outside time frame

isaiah_thompson
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!
April 27, 2023

Hey everyone, 

I'm trying to find tickets from a list of part numbers from the beginning of this year to April 26th 2023, but it seems like it's still taking tickets that were made in 2022. 

Here's my jql: 

created >= 2023-01-01 AND created <= "2023-04-26 23:59" AND project = PROD AND "Part Number[Short text]" ~ 10-210-01-16 OR "Part Number[Short text]" ~ 10-210-00-16-INV OR "Part Number[Short text]" ~ 10-210-01-00-INV ORDER BY created ASC

Screenshot 2023-04-27 144026.png

 

Looking for some help with my project, I'm not sure why I'm not getting exactly the dates that I need. 

1 answer

1 accepted

2 votes
Answer accepted
Kris Dewachter
Community Champion
April 28, 2023

Hi @isaiah_thompson ,

 

I think you are missing some parenthesis symbols around the part number selection in your JQL query.

Try this

created >= 2023-01-01 AND created <= "2023-04-26 23:59" AND project = PROD AND ("Part Number[Short text]" ~ 10-210-01-16 OR "Part Number[Short text]" ~ 10-210-00-16-INV OR "Part Number[Short text]" ~ 10-210-01-00-INVORDER BY created ASC

Best regards,

Kris

isaiah_thompson
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!
April 28, 2023

Yes! That worked! :D 

Thanks so much! 

Suggest an answer

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

Atlassian Community Events