Advanced search JQL for tickets that have been in certain statuses within a date range

[mborinstein]

I am looking for the JQL that I can apply to advanced search that would give me any tickets that have been in "In Progress" "In UAT" "In Review" "Ready for Release" within a certain date range

[Bill Sheboy · Accepted solution]

Hi @mborinstein 

Please try using the WAS IN and DURING operators for that JQL query:

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#WAS-IN

Kind regards,
Bill

[Varsha Joshi]

Hi @mborinstein 

I would do something like this:

status in ("In Progress", "In UAT", "In Review", "Ready for Release") AND updatedDate >= "2025-01-01" AND updatedDate <= "2025-08-08"

Also, I noticed with improved AI helper it is really very straightforward to build your JQL.

Hope this helps.