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

[Toli An · Accepted solution]

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?

[Toli An]

if you mean "jql query", then like other custom field by field name or field key:

e.g.
customer = <user_name>
or 
cf [13802] = <use_name>