created JQL filter not showing tickets outside time frame

[isaiah_thompson]

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

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

[Kris Dewachter · Accepted solution]

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-INV) ORDER BY created ASC

Best regards,

Kris

[isaiah_thompson]

Yes! That worked! :D 

Thanks so much!