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 Filter - All tickets assigned by someone on particular day every week

Jeff Boon

HI everyone I am trying to setup a JQL filter for my team, condition as below:

Filter all tickets assigned by one person on every Tuesday and Thursday.

Below is what I have now, however it returns no tickets which is not accurate, as the particular person has assigned ticket on Tuesday and Thursday

project = projectid AND status changed from (open, kiv) to ("review approved", kiv, "ready for review") on startOfweek(3) by userid ORDER BY created DESC

Kindly help me on this. Thank you

Accepted answers

Toli An

Hi, Jeff!
Instead of "on startOfWeek(3)" try this:
AFTER startOfWeek(3d) BEFORE startOfWeek(4d)

All comments

Toli An

Hi, Jeff!
Instead of "on startOfWeek(3)" try this:
AFTER startOfWeek(3d) BEFORE startOfWeek(4d)

Jeff Boon

Does this mean filter for task status changed on Thursday?

after startOfWeek(4d) before startOfWeek(5d)

If I do like above, it also meant the same thing right?

Toli An

Yes, I think jql ON check exact date and time, so you should use period from start to end day, betwen startOfWeek(4d) and startOfWeek(5d) for whole Thursday

4d - if Monday is set as the start of the week, of course

Jeff Boon

Thank you so much for your replies. May I know if I have a custom field (user picker) how do I incorporate this into my SQL query?

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