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.