Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,368,128
Community Members
 
Community Events
168
Community Groups

Help with JQL: Filter out tickets created only over weekends.

Dear Community,

I am really badly looking for a help regarding filtering out issues, created only over weekends ( Saturda, Sunday).

I've seen several topics, where people were using JQL with startWeek and so on, but in my case that doesn't work at all. 

Maybe there is any other 3rd party plugin, which has the option to filter out such issues, with specific days? 

 

Thank you!

 

 

 

1 answer

1 accepted

1 vote
Answer accepted

Hi,

you can try comthing like this:

created > startOfWeek(-26h) AND created <= startOfWeek(1d) ORDER BY created DESC

May be you will need to adjust the argument in the first startofweek function

Thank you very much Mohamed! Do know maybe how this query is calculating the startofWeek, like whats the timestamp base to calculate -26h?

 I am struggling also to filter out issues during working week and specific time frame like 09:00-18:00

created > startOfDay("+9h") and created < startOfDay("+18h")

and the same during working week, but including nights only

created > startOfDay(-6h) AND created < startOfDay(8h)

Do you think this querys make sense? 

Thank you once again!

Hi,

by default startofweek means sunday at 12am so i think the correct syntax should be

startOfWeek(-24h)

instead of

startOfWeek(-26h)

 StartOfDay() is equal to 12am so your first query seems correct. If you want the issue created outside working hours you could do it like below:

created > startOfDay("+18h") AND created < endOfDay()

But be aware that this JQL will return results only when you launched it after 18h, so you will need to create a subscription to have a mail with the issue list.

you can take look at this thread:

https://community.atlassian.com/t5/Jira-questions/Find-all-issues-created-outside-of-normal-working-hours/qaq-p/1978132

Like Tomasz likes this

Thank you @Mohamed Benziane  for your brilliant help. 

Like Mohamed Benziane likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events