Filter JIRA issues for unchanged issue status

BenoitP
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 18, 2018

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.

2 answers

0 votes
Lizzie_Rogers
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 18, 2018

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

0 votes
Alexey Matveev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 18, 2018

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)

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events