JQL Query for Date Ranges excluding Weekends

[Richard Canlas]

I am aware of this topic: https://community.atlassian.com/t5/Jira-Core-Server-questions/Exclude-weekends-in-JQL-Query/qaq-p/1030290

But I still cannot for the life of me solve this problem.

My goal is to find:

-All issues updated within last four hours

-All issues updated between 4-24 hours ago

-All issues updated between 24-28 hours ago

-All issues updated between 28-48 hours ago

-All issues updated  between 2-3 days ago

-All issues updated more than 3 days ago

^All with the caveat that the weekends should be excluded.

I know this is a really tough ask. If it is not possible, I will settle for:

-All issues updated within last 1 day

-All issues updated between 1-2 days

-All issues updated between 2-3 days

-All issues updated more than 3 days ago

^All with the caveat that the weekends should be excluded.

Thank you very much!!!

[Iryna Komarnitska_SaaSJet_]

Hi, @Richard Canlas 

This problem can resolve Text to JQL gadget developed by my team. It's free!

With it, you don't need to know the query syntax. Just enter your request in plain language and get the desired result in a few seconds. 

But, a little advice, experiment with it, asking your request in different forms.
An example is shown in the screenshot.

I hope the gadget will be helpful to you!

[Fabio Racobaldo _Herzum_]

Hi @Richard Canlas ,

this is a recurring question. Right now there is not a specific way to do that. You need to use startOfWeek()/endOfWeek() in your JQL in order to manually exclude specific weekend. 

Hope this helps,

Fabio

[Richard Canlas]

@Fabio Racobaldo _Herzum_ thanks for your reply. So the specific way is to include startOfWeek()/endOfWeek()  in my JQL? I am struggling to manually do that and need help. 

[Darryl Lee]

Hi - alongside this question in the right-hand nav is a section called Related Community Content. Following one of those links I found a few previous questions with answers and comments that should give you some examples and ideas on how to use startOfWeek()/endOfWeek():

• Exclude weekends in JQL Query 
• Need filter for tickets not updated for last 3 days excluding weekends 

(Excellent work by @Phill Fox there.)