Hello Jira Experts,
I am have some issues in Jira reports, I am trying to filter incidents created during non-working hours (from 18:00 to 22:00), excluding weekends.
JQL should be:issuetype = Incident AND created >= startOfDay() ORcreated <= startOfDay() + 22h OR NOT (created >= startOfWeek() + 1d or created <= startOfWeek() + 2d)
But it doesn't work.... Maybe someone knows where is the issue?
Hi @Rokas ,
So, unfortunately, JQL doesn't natively support time-based filtering or complex logical operations like excluding weekends directly. However, we can approximate this by breaking down your query and using available JQL functions.
Here's a way we can approach this (hope it helps you):
Filter by Working Hours (18:00 to 22:00):
Exclude Weekends:
Here's an example JQL query that might help you get closer to your goal:
issuetype = Incident AND (
(
created >= startOfDay("+18h") AND created <= startOfDay("+22h")
) AND (
created >= startOfWeek("+1d") AND created <= startOfWeek("+5d")
)
)
What the above does:
This query will include incidents created between 18:00 and 22:00 on weekdays.
Limitations:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.