nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Elisabeth Gie_cr9ahy

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?

Accepted answers

Elisabeth Gie_cr9ahy

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)

All comments

Yogesh Mude_u145qk

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.

Grigory Salnikov_0hffsd

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_cr9ahy

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

Elisabeth Gie_cr9ahy

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

Elisabeth Gie_cr9ahy

Grigory Salnikov_0hffsd

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?

Grigory Salnikov_0hffsd

Amazing!

I'm glad you've found a solution.

Elisabeth Gie_cr9ahy

I will check this out Thanks

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud