Status updated date prior to Create date

SJ_mizaii

I have a JQL that gives me a list of issues that have not had the status updated in more than 7 days

project = ODIT_Tech_Ops AND issuetype = "Help Services " AND status not in (Done, Cancelled) AND NOT status changed AFTER -7d

This is the result set

You'll notice that TO-2568 was created on 1/18/2023 and should not be included since the status update would have happened prior to the issue being created.

This same JQL produces results as I would expect in other projects but not this one.

Is the JQL not correct or do I have a different issue?

Trudy P Claspill

Hello @SJ 

In my opinion the results are correct.

Your query is asking for issues that have not had a status change in the past 7 days. That is a bit different than asking for issue that had a status change more than 7 days ago.

The status of TO-2568 has not changed in the past 7 days, assuming that Open is the initial status for your issues. It was created on the 18th and its status has not changed within the past 7 days. Therefore it is included in the list.