nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Grigory Salnikov_0hffsd

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.

All comments

Grigory Salnikov_0hffsd

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_0hffsd

Glad it helped!

You are always welcome!

Mariana_Pryshliak_Saasjet_qysy8m

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud