Query to check the 4 eyes principle

[Mees]

I would like to write a JQL filter where I see wich tickets have been tested by a different assignee than the assignee that built the story: 

Example:
Ticket 1, built by person A, tested by no one.  (NO) 
Ticket 2, built by person B, tested by A.  (YES)
Ticket 3, built by person C, tested by B.  (YES)
Ticket 4, built by person C, tested by C.  (NO)

Result: ticket 2& 3 

[John Funk]

Hi Mees,

I would create a custom field with a user picker field - something like: Tested By

Then populate that field with the assignee when the issue has been tested. 

Then you can do a Scheduled trigger in Automation for Jira which will email you the results.