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; } } }

Exclude weekends in JQL Query

Madhu Mullangi_nqfyjl

I want to find out the tickets which are not updated for last 3 days[ Excluding Weekends ].

Is it possible using Jira JQL filters?

Thanks in Advance.

Accepted answers

Phill Fox_0rx7av

Hi folks

You might like to look at my answer on https://community.atlassian.com/t5/Jira-questions/Need-filter-for-tickets-not-updated-for-last-3-days-excluding/qaq-p/1437566 which is looking at the rolling last 3 work days. For an explanation of the logic I used there.

Building on the JQL provided by @Christos Moysiadis

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

Hope this is still useful to someone out there.

Phill

All comments

Christos Moysiadis

Hi @Madhu Mullangi ,

yes i am sure its possible.try to run this jql:

updated >= startOfWeek(2d) and updated <= endOfWeek(-1d)
- Notes: 2d means , that you increase the days by 2
- -1d means , that you decrease the days by 1

Hope this info is helpful for you. maybe some customisations in the -/+ days will be needed ,because i dont know how your working calendar is.

Extra info:

Best regards

Madhu Mullangi_nqfyjl

@Christos Moysiadis Thanks for your Response.

I am totally confused with your Answer.

I think you are not clear with my question.I want tickets which are not updated for lats 3 days[Thursday,Friday,Monday] excluding weekends.

Today is Tuesday and my result should be tickets not updated from last Thursday Onwards i.e. [Monday, Friday, Thursday].

Thanks in Advance.

Christos Moysiadis

@Madhu Mullangi many many sorrys. i missread this not. I ll try to find out the solution and repost it here.

Adolfo Miguel Nunes

@Christos Moysiadis did you find a solution?

Luiz Cezer Marrone Filho

I have the same issue as the others, any solution? Thank you guys!

Phill Fox_0rx7av

Hi folks

Building on the JQL provided by @Christos Moysiadis

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

Hope this is still useful to someone out there.

Phill

Madhu Reddy_u009vn

Hi @Phill Fox my Scenario changed and Now I want to find the tickets which are not updated for the last 2 days and Exclude the weekends.

Could you please help me in this regard.

Phill Fox_0rx7av

Hi @Madhu Reddy

I covered that use case in this answer https://community.atlassian.com/t5/Jira-questions/Need-filter-for-tickets-not-updated-for-last-3-days-excluding/qaq-p/1437566 although this was for 3 days not 2. Please review that for the description of the logic but the based additional criteria for time is

(updated <-2d AND > startofweek()) OR (updated < -4d AND updated > startofWeek(-2d) AND updated < startofweek())

Phill

Owen Scott_cmck2h

Hey @Phill Fox !

Sorry to make you the defacto "ignore weekends" expert, but you seem the most knowledgeable!

I am trying, using the Jira Automation feature, to flag tickets (flag = Impediment) that get stuck in "In Progress" or "Peer Review" for 3+ days.

I tried the following query:

sprint in openSprints() AND status in ("In Progress", "Peer Review") AND ((statusCategoryChangedDate < -3d AND statusCategoryChangedDate > startofWeek(-1d)) OR (statusCategoryChangedDate < -5d and statusCategoryChangedDate < startofweek(-1d))) AND Flagged is EMPTY ORDER BY Rank ASC

Which makes the following checks:

ticket is in current sprint
ticket is in progress or PR
status hasn't changed in 3 days (ignoring weekends)
ticket is not already flagged

The 3 days + ignore weekends rule is not being respected. A ticket that transitioned to "In Progress" the previous day was flagged by the automation the following morning.

Any idea where I might be going awry?

Dipak Naokar

@Christos Moysiadis

@Phill Fox

My problem is very similar, hence I do not wish to open a new topic of discussion:

Here is my description.

We have a service level agreement (SLA) with our customer facing team. It says once the bug is created, within 3 business days, the status should move to at least "IN-DEV" (closed is not possible as the Queue of tickets is long).

So we have created a custom field called as "SLA breach". This field should have "YES" value if the duration between "NEW" and "IN-DEV" is longer than 3 business days (but exclude weekends).

Example:

If the new bug is created on Monday (then), it should go to "IN-DEV" before Wed (EoD), else on Thursday - it should be SLA breach.
If the new bug is created on Tuesday (then), it should go to "IN-DEV" before Thu (EoD), else on Friday - it should be SLA breach.
If the new bug is created on Wednesday (then), it should go to "IN-DEV" before Fri (EoD), else on Saturday - it should be SLA breach.
If the new bug is created on Thursday (then), it should go to "IN-DEV" before next Mon (EoD), else on Tuesday - it should be SLA breach.
If the new bug is created on Friday (then), it should go to "IN-DEV" before next Tue (EoD), else on Wednesday - it should be SLA breach.
If the new bug is created on Saturday (then), it should go to "IN-DEV" before next Wed (EoD), else on Thursday - it should be SLA breach.
If the new bug is created on Sunday (then), it should go to "IN-DEV" before next Wed (EoD), else on Thursday - it should be SLA breach.

I know the Automation and I have created the cron jobs to run every night.

My problem is -3d is not excluding the weekend. (So A bug created on Friday, is flagged as SLA breach on Monday itself as Sat and Sun are counted by system)

Can you please suggest me a JQL filter to have the SLA breach for above conditions that will exclude weekends from the counting of "3 days"?

In other words I just want to count business days.

Rajesh Ramankutty

Hi team,

I need to check only the tickets assigned and not taken any action for last 3 days of working days

Mehmet A _Bloompeak_

Hi @Rajesh Ramankutty ,

Hope below JQL works.

assignee IS NOT EMPTY AND 
NOT ( updated >-3d OR (updated > -5d AND updated > startofWeek(-3d) AND updated < startofweek()))

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-software

jira-core

jira-core-server