JQL: query issues where assignee != project lead; or where assignee != reporter

Question

I'm looking to create a filter where issues are not assigned to the project lead.  Another way this could work is if the current assignee is not the same as the reporter:

- project = 'my project' and assignee != reporter

- project = 'my project' and assignee != projectlead()

Something along those lines.  Any suggestions?

JamieA · Answer

Scripted field will work fine providing you set an indexer. Better to use a jql function though.

Luis Ribeiro2 · Answer

Hi,

You can give a try on:

https://marketplace.atlassian.com/plugins/pt.lt.lfcribeiro.jira.jqlLTFunctions

It lets you run SQL staments in a JQL functions(executeQuery() )

Thx

Nancy Blackwell · Answer

Scripted field doesn't work because the scripted field is not rendered until the browser displays the issue (I think).  Our solution was to have a number field set to -1 on create, then when we assign the issue back to the requester, we set it to 0.  Then the number field is searchable.  Note: This only works if you know when you are setting it back to the requester through post functions.