JQL Is there a way to make a statement for a filter where creator = assignee

Shawn G Kelly December 7, 2018

I want to show all the our service desk issues where the person who created it also assigneed themselves to it.  

It gives me an error saying assignee is not a property of creator. 
How do I make the query for them to be equal? 

3 answers

1 accepted

0 votes
Answer accepted
Brant Schroeder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 7, 2018

It's not possible without plugins. For example Script Runner has the expression function, which allows you to do:

issuefunction in expression("project = PNAME", "assignee != creator")

0 votes
Payne
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 7, 2018

Jira itself doesn't allow such a comparison, but if you happen to have ScriptRunner installed, you can use the following expression:

issuefunction in expression("", "assignee == creator")

0 votes
Alexey Matveev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 7, 2018

Hello,

You could also use the Power Scripts add-on:

https://marketplace.atlassian.com/apps/43318/power-scripts-jira-script-automation?hosting=cloud&tab=overview

In this case your JQL would look like this:

key in silJQLExpression('assignee == reporter', 'project = TEST and issueType = \"Bug\"')

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events