Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,365,126
Community Members
 
Community Events
168
Community Groups

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

Tried !=

Tried *

Directions say ~ will not work

How to say where Assignee does not include (Inactive)

1 answer

1 accepted

0 votes
Answer accepted
John Funk Community Leader Jun 05, 2019

Hi Rachel - Welcome to the Atlassian Community!

Just did this same thing yesterday. :-)

Try this: 

assignee not in (membersOf(jira-users)) 

Hope that helps!

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 Community Leader Jun 05, 2019

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

AND assignee not in (inactiveUsers())

 

This is what seemed to work.  Thank you!

Like erik-foxcroft likes this
John Funk Community Leader Jul 11, 2019

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

Sure, this is what worked in our system:  

AND assignee not in (inactiveUsers())

Like John Funk likes this

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

John Funk Community Leader Aug 18, 2022

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

Something like AND assigned != john.funk

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.

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.

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

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!

Like John Funk likes this
John Funk Community Leader Aug 18, 2022

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

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events