Filter JIRA issues for unchanged issue status

[BenoitP]

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.

[Lizzie_Rogers]

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())

[Alexey Matveev]

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)