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

[Thomas Schilk]

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]

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]

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