JQL filter out tickets where users updated something within a time frame

[Jayanth]

Hi Community,

I’m looking for a JQL query that can filter issues from a specific project where one or more users have made updates within a particular time frame (for example, within the last 7 days).

Currently, I’m using the below JQL:

project = "ABC" AND (issue in updatedBy("user1") OR issue in updatedBy("user2")) AND updated >= -7d

However, this returns issues that the users have updated even outside the specified time frame.

I’d like to get only the issues that these users actually updated within the last 7 days.

Is there any way to achieve this in Jira Cloud (preferably using ScriptRunner JQL functions if needed)?

Thanks,
Jayanth

[Gor Greyan · Accepted solution]

Hi @Jayanth

Thanks for the question.

You should put the date window inside updatedby() rather than using a separate updated clause. Otherwise, Jira will bring back any issues those users ever touched that also happened to be updated in the last 7 days (by anyone).

Use this one.

issue IN updatedBy("gor.greyan", "-7d") or issue IN updatedBy("user.name", "-7d") 

[Jayanth]

Hi @Gor Greyan ,

It worked. Thanks for your help.

[Gor Greyan]

Hi @Jayanth

Glad that it helps.

Also, please accept the answer, as community members see that the solution was accepted.