Can you search for issues that have been assigned to more than one person?

[Mike Rudy]

Hello, 

If I need to search for issues that have been assigned to more than a single person in its history, is there a way to do this?

Thanks!

[Trudy Claspill · Accepted solution]

If you have a user group that contains all the users who might be valid assignees for the issues, I think you can use something like this:

project=XXX and assignee changed from membersOf("jira-software-users") to membersof("jira-software-users") order by created DESC

I plugged in "jira-software-users" as the group name, but there may be members of that group that are not valid to use as Assignees in the project. So you might need to create another more constrained user group for the valid users in the scope of your project.

[Mike Rudy]

Thanks, Trudy.  Were you able to get that query to work?  Using this query:

project="XYZ Project" and assignee changed from membersOf("jira-users") to membersOf("jira-users") order by created DESC

I get this error:

A value provided by the function 'membersOf' is invalid for the field 'assignee'

[Trudy Claspill]

I did not work through getting results from the query, but we can tell that the syntax is correct.

That error indicates that there is somebody in the group that does not have the Assignable Users permission in the project. Check the permission scheme for the project to see if it limits who can be set as an Assignee. Alternately, the group may contain users who have been deactivated, and those users would not be valid Assignees for a project any more.

You may need to create a new user group in your JIRA instance that encompasses the users who are active users and have permissions to be assigned to issues in the project.

[Mike Rudy]

Great, that makes sense.  Thanks a lot!