JQP to Filter by User and Range of Dynamic Date

[Marcelo Marques]

Hey Guys, hope you're well! Today I have a filter like this:

assignee was in (5e98a3e04152d50c325c6345, 5ed6c79f037d930c16c134761) AND updated > startOfWeek(3d)

The problem here is that if ticket was assigned before for this users and then updated by other user that is not into the query, I will get the ticket. I would like to do something like this:

issue in updatetBy("User1", startOfWeek(3d))

But I know that I can't use this funcion "startOfWeek" inside "updatedBy".

Is there any suggestion from you guys to filter something basivcally like this:

- Tickets that was updated in a dynamic date range (usually from Tue of last week until Tue of this week)

Thanks! :)

[Ste Wright · Accepted solution]

Hi @Marcelo Marques 

To be clear you want to see all issues updated by a specific user within a dynamic date range?

I'm not sure this is completely possible in Jira Cloud using JQL. UpdatedBy is your best option but the date needs to be absolute or relative - so as you've noted above, it could be "-7d" but not "startOfWeek()"

You could try:

issue in updatedBy("User1","-7d") and updatedDate >= startOfWeek(3d)

This gets you a little closer, as it looks for issues both updated since Tuesday and which have an update by the specified user in the last week. It won't be fool-proof but should limit some of the noise without the "-7d" where a user has updated the issue months ago and someone else updated since Tuesday.

Ste 

[Marcelo Marques]

Thanks @Ste Wright !! This should help!!! :)