Query to filter tickets based on the week day creation

b_hafez

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

Tomasz Kowalczyk_aly1rm

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.