Query to filter tickets based on the week day creation

b_hafez August 1, 2024

Hi Community,

 

Need a query that filters based on the day of the week. I am basically looking for the ticket that were created on Thursdays and Fridays only since the beginning of this year.

I have this query but it is not showing me the results, and I am not sure why

created >= "2024-01-01" AND created < now()

AND ( (created >= startOfWeek(3d) AND created < startOfWeek(4d)) OR (created >= startOfWeek(4d) AND created < startOfWeek(5d)) ) 

1 answer

0 votes
Tomasz Kowalczyk
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 1, 2024

Hi, function startOfWeek gives you date on Monday and when you pass f.e. 3d parameter it adds to this date 3 days. So query you just showed is looking for issues from this week. I don't think that there is a date function in jql which can resolve your problem. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events