nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL Query for tickets resolved "last friday" regardless of the current day.

Chris Buzon

Hello Fellow Jira peeps.

I've been trying to figure out a query that is smart enough to identify Tickets resolved "Last Friday", regardless of the day it is today.

I've tried things like ResolvedDate = EndOfWeek(-3d) , and variations on the other date functions, but haven't found anything that works.

Just putting out a question to see if any other jira users have managed to logic their way through this.

(it's for a board quick filter).

Thanks!
Happy 2023!

Accepted answers

Guilhem Dupuy

Hi @Chris Buzon ,

I think it didn't work because of the "=" operator, which checks for an exact date and time (as the resolutionDate is a date and time field). I checked this on my Cloud instance and the following JQL should work :

resolutiondate <= endOfWeek(-10d) AND resolutiondate > endOfWeek(-11d)

You can then adapt the number of days depending on which day of the week is set as last, I think the default is Saturday surprisingly.

Let me know if it helps,

Guilhem

All comments

Guilhem Dupuy

Hi @Chris Buzon ,

resolutiondate <= endOfWeek(-10d) AND resolutiondate > endOfWeek(-11d)

You can then adapt the number of days depending on which day of the week is set as last, I think the default is Saturday surprisingly.

Let me know if it helps,

Guilhem

Chris Buzon

I'm an idiot! That actually makes a lot of sense. Thank you so much @Guilhem Dupuy , I'll go give that a shot. I'm almost certain that'll work the way we want.

Guilhem Dupuy

Ahah lots of complexities in JQL so lots of ways to struggle sometimes

Happy to help anyway!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud