JQL Query for searching issues that are assigned to the reporter

Hi there!

I'd like to search for all issues that cirrently are assigned to their reporters, but I'm not able to find out how to do this in JQL. As it seems, Jira wants to resolve what is right of the operator as a user name rahter than another field value (thus giving something like "The value 'assignee' does not exist for the field 'reporter'." as a result).

How to solve this one?

Thanks in advance
Steffen

2 answers

1 accepted

0 vote

There is a hasSameValues function in JQL Tricks Plugin which can do this. But believe me, I wouldn't use this in a dashabord because the performance won't be that great.

It will be very handy if you want to just get a report or something by running this JQL. The function works for quite a lot of fields as long as they are comparable and the performance varies depending up on the fields.

Evaluating the plugin is a good idea. And yes, it is commercial.

Hi Jobin,

this sounds like a good idea. I'll have to check, maybe this plugin already is installed in our environment.

I'd use it only for reporting, once a week or so.

Thanks you!

Steffen

JQL Tricks literally did the trick \o/

Thanks again, much apprechiated!

I cant get issue in hasSameValues("assignee", "reporter") to work even if there is really a ticket which is assigned to its reporter.

I have done many attempts to execute this query on JQL and didn't succed. I've read some of the documentation about JQL an didn't find a way to run this query either.

I believe this happens because both "assignee" and "reporter" require a value to be compared.

But anyways, you can easily run this query with the SQL or MYSQL command line:

SELECT * FROM jiraissue WHERE assignee = reporter;

I Hope I have helped.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,198 views 13 19
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot