Hi Community,
I fail at creating a filter that extracts any issues that is currently in the same status for more than 2 weeks.
I tried:
status != Closed AND not status changed during (startOfWeek(-2), now())
but this does not do the right job because it shows issues that have never transitioned during the last 2 weeks and not the one where the current status is pending for more than 2 weeks.
I thought something like that could work:
status != Closed AND lastTransitionDate > 2w
but it does not exist...
Basically, I am trying to retrieve all issues that require attention...
Also, I do not want to use anything related to "updated" because I only care about the status, not the comments, etc.
Thanks for your help.
I would also try listing the statuses you are looking for, instead of just not Closed. That seems to be pulling the correct results for me.
For example: status in ("In Progress", "To Do") AND not status changed during (startOfWeek(-2), now())
Hello,
I am not sure, if I understood your question correctly, but maybe this one will help:
status != Closed AND not status changed during (startOfWeek(-2), now()) and status changed before startOfWeek(-2)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.