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

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