How can I do a JQL query on CLOUD to check if the reporter and assignee are the same?

[Elisabeth Gie]

I am trying to either do a JQL query to find tickets where the assignee and reporter are the same or a workflow condition / validator in CLOUD where the reporter and assignee cannot be the same for a transition for deployment approvals.

I can't seem to find anything for CLOUD that allows me to do this. Has anyone found a solution to this?

[Elisabeth Gie · Accepted solution]

I found a way around this using the Separation of Duties condition within the workflow. Basically the user cannot move the ticket into Doing if he was the user that approved the ticket (basically if the user performed the first transition, they cannot perform the second transition)

[Grigory Salnikov]

Amazing!

I'm glad you've found a solution.

[Grigory Salnikov]

Hello @Elisabeth Gie and welcome to our Community!

I'm afraid there's no such possibility in a basic, out-of-the-box JQL functionality. To perform such a request you'll need to install something like ScriptRunner (or any other marketplace app extending JQL the required way).

If you have a small or medium team you could also run a JQL on a 'per-user' basis:

project = <Project name> AND Reporter = <user1> AND Assignee = <user1>

project = <Project name> AND Reporter = <user2> AND Assignee = <user2>

...

[Elisabeth Gie]

Thanks for the reply, I installed scriptrunner but only the server version has the assignee = reporter function, not the cloud version. :(

[Grigory Salnikov]

Oh, I see.

I've found an old similar question:

Is it possible to search for issues where assignee=reporter?

It's said there that we'd need to script something like

issueFunction in expression("project = <projectname>", "assignee == reporter")

Does it work in your environment?

[Elisabeth Gie]

I will check this out :) Thanks

[Yogesh Mude]

HI @Elisabeth Gie

You can find the tickets which have same Assignee and Reporter using below JQL.

project = XYZ and reporter = Username and assignee =Username

But there is no way you can find this for workflow conditions/validators using JQL, you need to go through the workflow transitions and then need to check.

[Elisabeth Gie]

Thanks for the reply, unfortunately we have too many users to try and do it one user at a time. :(