How to filter out where Assignee includes: (Inactive) Tried a bunch of things to no avail -

[rachel rutti]

Tried !=

Tried *

Directions say ~ will not work

How to say where Assignee does not include (Inactive)

[John Funk · Accepted solution]

Hi Rachel - Welcome to the Atlassian Community!

Just did this same thing yesterday. :-)

Try this: 

assignee not in (membersOf(jira-users)) 

Hope that helps!

[rachel rutti]

okay, thanks!  I tried it and it filtered everything out including those that don't have inactive in the name.  So, maybe our system is set up differently.  

[John Funk]

Hmmm, wondering how your system is labeling what makes a user inactive. Can you find that out from your system administrator?

[rachel rutti]

AND assignee not in (inactiveUsers())

This is what seemed to work.  Thank you!

[John Funk]

Great! Can you go ahead and click on the Accept answer button to close the issue?

[rachel rutti]

Sure, this is what worked in our system:  

AND assignee not in (inactiveUsers())

[erik-foxcroft]

That filters out all inactive users.  Is there a way to filter out a specific inactive user?

[John Funk]

Sure @erik-foxcroft  - just use there account id or user name directly. 

Something like AND assigned != john.funk

[erik-foxcroft]

That was the first thing I tried, but it did not work.  When I started typing their name in the query it did not suggest a full name, as it had for all the active people, so I tried putting their name in quotes, and I tried putting their name as it appeared in the tickets, with '(Inactive)' after it, but they still kept appearing.

I tried to find their ID but it was not obvious where to find it.

[erik-foxcroft]

That was the first thing I tried, but it did not work.  I tried to find their ID but it was not obvious where to find it.

[John Funk]

No, their name will not appear when typing - sorry, I should have mentioned that. You have to use the username or the accountID. 

You can those under the User Management (Admin) section. 

Settings > User Management and then search for the user.

Click on the user. The accountID will be the entire long string after the users/ in the URL

[erik-foxcroft]

Thanks.

I don't have admin access, so I cannot list the users.  However, I downloaded an all-fields csv of a filter result containing some of their tickets and that contained the user ID.  I used that and the filter works!

[John Funk]

Ah, nice way to do that - sneaky  :-)