updatedBy() is listing all project but not filtering from a single project

[Durgesh Jha]

Hi All,

I wanna use the updatedBy() in a manner where a set of specific users was updated last week from a single project.

I have used the below jql query but this is listing all projects where users updated.

project = Myproject AND issuekey in updatedBy(A, "2024/01/12", "2024/01/14") OR issuekey in updatedBy(B, "2024/01/12", "2024/01/14") OR issuekey in updatedBy(C, "2024/01/12", "2024/01/14") OR issuekey in updatedBy(D, "2024/01/12", "2024/01/14") OR issuekey in updatedBy(E, "2024/01/12", "2024/01/14") AND NOT (status = Done OR status = Closed) AND NOT created >= 2024-01-07 AND NOT created <= 2024-01-14 

Please help me to resolve this.

[Nic Brough -Adaptavist- · Accepted solution]

Welcome to the Atlassian Community!

This is because your filter is asking it to, because you've mixed AND and OR in the main statement without specifying the order, and Jira has no choice other than to read it left to right.

Reading it right to left, you say

• Project = Myproject : selects all issues in Myproject
• AND issuekey in updated by (A):  selects all the issues in the previous clause that were updated by A
• OR issuekey in updated by (B): Selects all the issues in your system, there's nothing there that tells it that you want to select any project.

and the rest of the ORs do the same, they're looking for all issues (except the last one which is ANDed with some status and created selections)

I suspect you want to actually group all the "updated by" bits together.  If that is true, then encase them all with a single pair of () so that the main statement reads 

Project = Myproject and (updated by A, B, C, or D) and Status bit and created bit.

[Durgesh Jha]

@Nic Brough -Adaptavist-, As per my finding updatedBy() can be used for a single user but not for a group of users. So I can not combine them in a single updatedBy().

Could you please help me with another JQL query that can solve my problem?

[Durgesh Jha]

@Nic Brough -Adaptavist-  Thanks for your help. The issue is now fixed as suggested by you.