Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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 Champion
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