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

Jayanth_39yfjq

 

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

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")