status changes before -7d returns me issues that has changes from today

[Shaya Brach]

I'm trying to find issues that did not have any status update in the last 7 days.

so I'm filtering by:

status changes before -7d 

but this returns me issues that has changes from today?

Any help

[Phill Fox · Accepted solution]

@Shaya Brach

The issues that you are getting are right for the SQL as "status changes" does not just pick up the last status change but any status change. I believe that you need the following.

status changed before -7d AND NOT(status changed after -7d)

To retrieve items that have changed status before 7 days ago and have not had a subsequent change since then. If you just use NOT(status changed after -7d) then this will pick up lots of new issues that have not yet progressed.

Hope this helps.