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

[Simarpreet Singh]

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

[Grigory Salnikov · Accepted solution]

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]

Works perfectly @Grigory Salnikov :)

Thanks a lot!

[Grigory Salnikov]

Glad it helped! :)

You are always welcome! 

[Mariana_Pryshliak_Saasjet]

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