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
@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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.