JQL Query to find issues updated by the assignee in last number of days

[George Abdo]

Hi All,

I am trying to construct a JQL that would filter the issues updated by a group of agents before a certain (relative date).
So conditions:
Updated 10 days ago or earlier by the assignee
Created 4 months ago or earlier.

I have tried this JQL, but it is returning results to any issues for the assignee regardless of who approved:

project = PROJNAME AND updated >= -28d AND (
(issuekey IN updatedBy("User 1") and assignee="User 1")
OR
(issuekey IN updatedBy("User 2") and assignee="User 2")
OR
(issuekey IN updatedBy("user 3") and assignee="User 3")
)
and created <=startofmonth(-3)

Also, all users are members of "SupportGroup" so assuming we can also use membersof("supportgroup") instead of individual lines

Thanks

George

[Trudy Claspill · Accepted solution]

Hello @George Abdo 

This part of your filter:

updated >= -28d

...is going to give you all issues updated within the past 28 days. That doesn't align with this requirement that you stated.

"Updated 10 days ago or earlier by the assignee"

If I understand that correctly you want to not include things that have been updated in the past 9 days. You want only issues where the last update made was 10 days ago or farther back in time. Is that correct?

To get "Updated 10 days ago or earlier" you would need

updated <= -10d

But do you only want issues that have not been updated by anybody in the past 9 days? Or do you want issues where the current Assignee has not updated the issue in the past 9 days, but the issue may have been updated by people other than the current Assignee in the past 9 days?

Also, no, you can't substitute "membersof(group)" in the updatedby() function. As per the documentation you have to provide a single user as the input parameter.

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#updatedBy--

[George Abdo]

Thanks Trudy for responding.

I should have explained myself better to avoid confusion.

What I am trying to achieve is to find all the issues (that are older than 3 months) that have been updated by the assignee in the last 4 weeks (28 days).

The date ranges is not the real issue I am having. My problem is this:
(issuekey IN updatedBy("User 1") and assignee="User 1")

is not returning only the issues updated by User1 in the timeframe (which is the purpose of this query), it is returning all issues assigned to User1 that have been updated by anyone in the timeframe.

Hope this explains my problem better.

[Trudy Claspill]

Thank you for that additional information.

With your current filter the date range is being applied to updates made by anybody, and the updatedby User  is being applied to all updates ever made for the selected issues.

So you get

- Issues created within the past 3 months
- that have been updated by anybody in the past 28 days
- that have also been updated by their current assignee at any time since they were created, not just within the past 28 days

If you want to apply a date range to when the current assignee made the update then you need to change the updatedby() parameters to include the date range. Refer to 

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#updatedBy--

project = PROJNAME AND (
(issuekey IN updatedBy("User 1","-28d") and assignee="User 1")
OR
(issuekey IN updatedBy("User 2","-28d") and assignee="User 2")
OR
(issuekey IN updatedBy("user 3","-28d") and assignee="User 3")
)
and created <=startofmonth(-3)

[George Abdo]

Hi Trudy,

This worked. Thanks for the help.

George

[Trudy Claspill]

I'm glad to help!

Please consider clicking on the Accept Answer button above my response to mark your Question as Solved. This helps others searching for answer find the posts that have validated responses.