Status updated date prior to Create date

[SJ]

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 Claspill · Accepted solution]

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.

[Bhanu KN]

Hi @SJ

When an issue is created, it begins its life cycle from the initial state. So, we can't really consider the starting status as a status change. 

You could add another condition that ensures that it's been at least 7 days since the issue was created i.e., 'created <= -7d'

<Your JQL query> AND created <= -7d might work as you expect. 

Let me know if this helps :)

Cheers,

Bhanu