Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Help with JQL for Status of Jira tickets have not changes in last 2 days

Amit Dawani July 11, 2018

Can someone please help with writing JQL for below 2 requests

1. Identify Issues that have not moved from a particular status in last 2 days (example if the Jira ticket is in Testing for more than 2 days)

2. Identify issues that have not moved from any status in last 5 days (example all the stories for which status was same in last 5 days so that we know those stories needs attention)

3 answers

3 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.
July 11, 2018

Hello,

You can try to do it like this:

1. not status changed TO Testing after -2d and status = Testing 

2. not status changed after -5d

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.
July 19, 2018

@Amit Dawani If my answer helped you, kindly accept my answer.

0 votes
Amit Dawani July 19, 2018

Thank You for your help @Alexey Matveev

 

Regards,

Amit

0 votes
Thomas Deiler
Community Champion
July 11, 2018

 

@Alexey Matveev is right.

 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events