JQL Query for Date Ranges excluding Weekends

Question

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!!!

Darryl Lee · Answer

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.)

Iryna Komarnitska_SaaSJet_ · Answer

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!

Richard Canlas · Answer

@Fabio Racobaldo _Catworkx_ 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.