Looking for all issues with multiple assignees in history

[scottmota]

I'm looking for a way to display all the issues that have had more than 1 assignee in their history. I've tried using the assignee CHANGED operator, but it's not returning all the issues I would expect to see. I have one specific example where the history shows 2 different users being assigned but it doesn't appear in my search using the following JQL. Screenshot of the issue history is below. What am I missing?

project = "Project 1" AND assignee CHANGED DURING ("2025/01/01","2025/04/01") order by key DESC

[Bill Sheboy · Accepted solution]

Hi @scottmota -- Welcome to the Atlassian Community!

First thing: the JQL you show may find any Assignee "changes" during that window of time, but it will not necessarily indicate if the value changed from another user.  It could have been set for the first time, from null to the value, from a value to null, etc.

Next, has your site converted from Server to Cloud?  If so, there is an open defect for the change history and the symptom you note: https://jira.atlassian.com/browse/JRACLOUD-84058

Finally, to actually detect if the Assignee changed from one user to a different one you may need a marketplace addon to extent the features of JQL or to extract / parse the issue changelog entries.

Kind regards,
Bill

[Aaron Pavez [ServiceRocket]]

Hi @scottmota 

I tested it and the JQL works as expected. I can filter correctly.

Could it be that the work item has a security level applied?

That's all I can think of why it won't be shown.

Regards - Aaron