JQL Query to finde items thats current assigee is not the same as the initial assignee

Question

We want to create a filter for items that are currently in testing. As we re-use the testing state also for items that need to be tested, i would like to distinguish these two item process states although from JIRA point of view it is the same technical state.

The developer puts it to testing, where as somebody else assigns it to itself in order to actually test it. So I would like to query like this:

all items in a certain state (testing) thats current assignee is not the initial assignee

OR if this is not possible, all items in a certain state that have multiple assigness over time

Thanks in advance

Thomas

John Funk · Answer

Hi Thomas - Welcome to the Atlassian Community!

I think your best approach might be to create a custom user picker field and copy the first assignee into the field. Then later on you can run the report where the Assignee field is not equal to the custom field value.

Peter Van de Voorde · Answer

Hi @Thomas Schilk ,

Welcome to the Atlassian Community.

You might be able to do this using the CHANGED operator on the assignee field, but I'm afraid that's going to show all issues that had an assignee changed, not just the once that had an assignee changed while in a certain status.

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#CHANGED

Cheers,
Peter