How to search for issues that are in a particular status for exactly 10 days?

Simarpreet Singh November 11, 2021

Hi,

I need to auto transition issues to next status that are in a particular status for exactly 10 days now. 

I'm not counting these 10 days from the creation of ticket, but from the day the ticket went into that status.

The objective here is to keep the workflow moving in case someone who was supposed to manually run that transition was not able to perform that within 10 days.

Any help is appreciated..

Thanks,

Simar

2 answers

1 accepted

0 votes
Answer accepted
Grigory Salnikov
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.
November 12, 2021

Hi @Simarpreet Singh !

Try the following JQL:

... and status changed to <your status> after startofday(-10) and NOT status changed after startofday(-9)

Hope it works as desired. 

Simarpreet Singh November 12, 2021

Works perfectly @Grigory Salnikov :)

Thanks a lot!

Like Grigory Salnikov likes this
Grigory Salnikov
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.
November 12, 2021

Glad it helped! :)

You are always welcome! 

1 vote
Mariana_Pryshliak_Saasjet
Atlassian Partner
November 29, 2021

Hello @Simarpreet Singh 

Time in Status for Jira Cloud generates a Time in Status report, that shows how long an issue has been spent in each status. You just need to choose date ranges (those 10 days you need), and get necessary data.

Hope, you find it helpful.

Best regards, Mariana

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events