Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Ticket STATUS not updated for last 3 days ( Excluding Weekends ).

We would like to find out the tickets which are in particular status and were not updated for the last 3 days. 

 

Lets say Tickets in 'In Review' for the last 3 days (excluding weekends). We would like to send an email alert to PM's if the ticket status was in "In Review" for the last 3 days.

Thanks in Advance.

Regards

Madhu

5 comments

Comment

Log in or Sign up to comment
Marco Brundel
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.
Nov 01, 2021

Hi,

 

Is the JQL

status = "In Review" AND updated <= -3d

an option for you?

 

Regards, Marco

Bloompeak Support
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Nov 03, 2021

Hi @Madhu Mullangi ,

Unfortunately, what you are looking for is not possible with the built-in functionalities of JQL. Because JQL can not make calculations and you need status time calculation excluding weekends.

For this exact need we developed Status Time Jira app. It provides reports on how much time passed in each status. You can also export the report as CSV and open it in excel.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too.

Here is the online demo link, you can see it in action and try without installing the app.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.

Daniel Turczanski - __JQL Search Extensions
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Nov 03, 2021

How about:

status=Review and status changed BEFORE 3d and updated<-3d
Marco Brundel
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.
Nov 03, 2021

Hi @Madhu Mullangi ,

Is 

updated >-3 OR (updated > -5d AND updated > startofWeek(-3d) AND updated < startofweek())

an option?

This is a answer from @Phill Fox in https://community.atlassian.com/t5/Jira-questions/Need-filter-for-tickets-not-updated-for-last-3-days-excluding/qaq-p/1437566

Zoryana Bohutska _SaaSJet_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Nov 03, 2021

Hi @Madhu Mullangi 

I think automation can helps you

TAGS
AUG Leaders

Atlassian Community Events