Need filter for tickets not "status changed" for last 3 days excluding weekends

[Ambrosino Salvatore]

 Anyone can suggest me a jql filter for tickets in a particular status with not "status changed" for last 3 days excluding weekends?  I found some thread with same problem but for "updated".  Status changed can accept just "after" and "before" instead of "<>". Thanks

[Mehmet A _Bloompeak_]

Hi @Ambrosino Salvatore , welcome to the Community!

Below JQL excludes weekends. Hope it helps.

(not status CHANGED DURING ("-3d", now()) AND not status CHANGED AFTER startOfWeek())
OR
(not status CHANGED DURING ("-5d", now()) AND not status CHANGED BEFORE startOfWeek())

[Ambrosino Salvatore]

hi @Mehmet A _Bloompeak_ thanks for your feedback, but doesn't work. I need that jql to integrate it in an automation that write a comment if a issue in status "Waiting Done" doesn't change in other status in last 3 days excluding weekend (Saturday and Sunday). With your jql appear issues from other projects also.

[Mehmet A _Bloompeak_]

Hi @Ambrosino Salvatore ,

If you want to restrict it to a single project then you can prepend your project JQL into it as below.

project=YOUR_PROJECT_KEY AND

((not status CHANGED DURING ("-3d", now()) AND not status CHANGED AFTER startOfWeek())
OR
(not status CHANGED DURING ("-5d", now()) AND not status CHANGED BEFORE startOfWeek()))

[Ambrosino Salvatore]

Ok thanks. I will try it!

[wouter de wit]

Worked like a charm. Thanks.

[Valeriia_Havrylenko_SaaSJet]

Hi @Ambrosino Salvatore 

You can use "NOT Status Changed AFTER" in your JQL query.

For example:

project=YOUR_PROJECT_KEY AND

((not status CHANGED DURING ("-3d", now()) AND not status CHANGED AFTER startOfWeek())
OR
(not status CHANGED DURING ("-5d", now()) AND not status CHANGED BEFORE startOfWeek()))

but i recommend you to try Time in Status for Jira , where in 2 clicks you can exclude weekends by calendars and filter data by issue or time ranges and get your report. All the reports you can display as Pie, Bar or Area Charts.



Add-on has a 30-day free trial version and free up to 10 users.

You can also book a live demo - we'll show you the application inside out and answer all your questions.

Have a nice day 🥳

[Ambrosino Salvatore]

Hi @Valeriia_Havrylenko_SaaSJet , thanks for your feedback, but doesn't work. I need that jql to integrate it in an automation that write a comment if a issue in status "Waiting Done" doesn't change in other status in last 3 days excluding weekend (Saturday and Sunday).

[Valeriia_Havrylenko_SaaSJet]

@Ambrosino Salvatore This JQL should work 

Project=X AND ((NOT Status Changed AFTER -3d AND not status CHANGED AFTER startOfWeek())

 Hope it helps :)