JQL for Inactive Reporters with Unresolved Tickets

[Peter Rufo]

Does anyone know of this query? All tickets resolution = unresolved in a project and the reporter is an Inactive User.

[Giovanni Melai · Accepted solution]

Hi @Peter Rufo

If I get it right you are on the server version, in that case, I think Atlassian decided not to implement that functionality, I found this request related to it: https://jira.atlassian.com/browse/JRASERVER-29149

You should use an addon like Scriptrunner to add additional JQL functions, you can find the documentation here.

In case you are on the Cloud you should be able to directly use the following JQL:

reporter in inactiveUsers()

I just tested it and it works 

I hope this helps 

[Peter Rufo]

Thank you for the response.

[Mikael Sandberg]

In order to search on reporters that are inactive you have to know their Atlassian Id in order to do it. If you go to admin.atlassian.com and search for the user and go into their profile you can see the Id as part of the URL.