Search for a specific inactive JIRA user

[Casey Daniell]

How do I search jira for issues created by a *specific* inactive user?

We have ScriptRunner and I know about, https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_inactiveusers, but this gives me all issues created by all inactive users. I want something more like

project  = KittyBreak and reporter = Sanjay.Smith [x]

which gives me only issues created by Sanjay.Smith, who is no longer with the company, and only issues in the KittyBreak project.

Versus 

project  = KittyBreak and reporterin (inactiveUsers())

Which gives me all issues in KittyBreak created by folks that are no longer here. We have to be able to query by specific inactive users. 

[Andy Heinzer · Accepted solution]

Hi Casey,

I am afraid I am not clear on the problem here.   You actually should be able to search for issues that belong to inactive users by simply referring to their username in Jira.   I think from looking at your example, you might have been using the Display name for that user.  But if you use the actual username, Jira can do this:

So you're JQL would look something like this:

project=ABC AND reporter='sanjay.smith'

I can see from your example that you used the display name, because it contains a '[X]'.  The square brackets are actually reserved characters to JQL, so you should try to avoid them.  Also I recommend using quotes to surround the username, especially if the username contains spaces.

Even if the user is inactive, Jira should still be able to return to you a list of all the issues they reported in that project.  

A few things to note about the limitations of doing this:

• Autocomplete does not work when typing in an inactive username in Jira.  So you would need to know the exact username and enter is correctly: https://jira.atlassian.com/browse/JRASERVER-59274
• You can't search for inactive users if using the basic search: https://jira.atlassian.com/browse/JRASERVER-37935

But if you know the exact username, and you're using the advanced search in Jira, this should work.  If you find it is not, please let me know what version of Jira you are using.

[Casey Daniell]

I wasn't trying to include the [x], but I was relying on the autocomplete to suggest the correct name for searching. Typing in the user's full name resolved this issue. 

[Venugopal Paladi]

Hi @Andy Heinzer 

I have tried this and it worked for me.

Thanks!

[David Kott]

It doesn't work for me in 9.12.2.  Tried using this format listed above: project=ABC AND reporter='sanjay.smith' and it doesn't return anything.