Hello, my filter is not getting exactly what I am looking for

Question

Sprint in closedSprints() AND (issuetype = Story OR issuetype = "Bug/Defect" or issuetype = Enhancement) AND ((status changed from 10019 to 3 during (-14d, now())) OR (status changed from 10009 to 3 during (-14d, now()))) AND project != "Web Content" ORDER BY project ASC

The filter I am looking to create is all status changes from QA to In Dev and UAT to In Dev, in the most recently closed Timebox.

(I believe that the first part of my statement Sprint in closedSprints() does not work with my DURING clause..)

Thank you

Ignacio Pulgar · Answer

I've just executed the query and I confirm it works like a charm.

Jason Pines · Answer

Thank you.

I am looking for all issues that ever changed, but only in the most recent Sprint.

Can you confirm,  that statement Sprint in closedSprints() does not conflict with my DURING clause..)

Have a great day

Ignacio Pulgar · Answer

Maybe you expect all issues that have ever changed to that status to be currently in that status too?

If that's the case, you should add:

... AND Status = 3 ...