JQL Query filtering for 2 status options

[Bruce Williams]

What's wrong with this JQL?

project = SIR AND status changed from "In Review" to "In Progress" during ("2024-07-01", "2024-08-01")

I got the following off a quick search, it works, but why wont the above work?

project = SIR AND status changed from "In Progress" to "Closed" during ("2024-07-01", "2024-08-01")

TIA,

[Laurie Sciutti · Accepted solution]

Hi @Bruce Williams and welcome to the Community!  Can you confirm that your workflow actually has a transition from "In Review" to "In Progress"?

[Bruce Williams]

Hi Laurie, Yes, it has that direct step.

[Lisa Forstberg · Accepted solution]

Hi!

So the first JQL does not work but the second does not work? 

What happens when you run the second one? Do you get an error or just no results? Can you post a screenshot?

Create a test ticket and move it through the workflow to status Closed to provide a test case to validate your JQL.

best regards

/Lisa

[Bruce Williams]

I can't seem to reply, I;ll try again

[Bruce Williams]

The first on failed, the second one (copied from Google, worked). I tried the first again without "during" and the dates, and it works. What's wrong with the dates' statement I wonder?

[Lisa Forstberg]

What is your hosting type ? Cloud / on Prem (DC or Server?)

If you remove DURING("2024-07-01", "2024-08-01") you will get any ticket in the project that has moved from one status to the other status at any point in time. If you want only those that changed from 1st of july to 1st of august you add the during statement.

Try to type your way through the JQL instead of copying it in if you get a mixed result, just to avoid the problem with characters / spaces etc 

/L

[Bruce Williams]

Thanks again for taking the time to look at this,

I'll type my way through step by step to see how it goes.

I've reviewed the Workflow and there is a join from "INREVIEW" to "IN PROGRESS" however the label on the arrow says "REVIEW TO IN PROGRESS". I'll try different versions of the Review status. I wonder if the labelled arrow exists as an action that can be filtered/captured or reported?

Cheers,

[Bruce Williams]

Today the filter worked, I'm not sure what changed:

project = SIR AND status changed from "In Review" to "In Progress" during ("2024-07-01", "2024-08-01")