Query

Question

Can we write a JQL for  when a ticket in the release has no status update for 5 days.

Natalia_Kovalchuk_SaaSJet_ · Answer

Hi @HaRsHaS_ V!

I propose that you try such a JQL query:

fixVersion = latestReleasedVersion() AND status NOT IN (Done) and updated <= -5d

Using this JQL, you can retrieve a list of tickets in the latest released version that are not marked as Done and haven't had any updates (including any change to status, comment, or other fields) for at least 5 days.

Here is also the article that may be helpful in similar cases: JQL Queries for Analyzing Team Performance in Jira

Thorsten Letschert _Decadis AG_ · Answer

Hey @HaRsHaS' V

Depends on what you refer to as "status update".

A query like

fixVersion = x.x.x and updated <= -5d

returns issues from a specific that have not been updated throughout the last 5 days (no field or status change, comment, etc.).

If you're referring to actual status changes, a query like

fixVersion = x.x.x AND NOT status CHANGED AFTER -5d

Might do the trick.

Regards,
Thorsten

Benjamin_tmh9yg · Answer

Hi @HaRsHaS' V ,

You can do something like this:

updated <= -5