Filter for inactive users with a manager OR inactive users still on a team

[RandyRoberts]

I'm trying to find inactive users who have a manager listed or who are still on a team. I can create a filter for either one but not for both. This should display deactivaed users where the Team IDs field OR the Manager field is NOT blank but NOT both blank.

This works:

This also works:

When combined, this does NOT work: (meaning users are displayed that don't have a manager OR a team)

This also does NOT work:

isActive=false

isActive_Mod=eq

teamIDs_Mod=notblank

OR:1:isActive=false

OR:1:isActive_Mod=eq

OR:1:managerID_Mod=notblank

I'm thinking maybe my logic is wrong and not the code. Any ideas?

[Sheri_Whitten]

I'm having issues with filtering not working in general - it's sporadic and odd, and my usual workaround is to make a copy of the report and voila! filtering works again. I realize my first instinct is to find a workaround, and it should be to open a support ticket. So, I just tried copying a filter to create a new one and the filtering does not work. It's not the same criteria you're using, but similar. I think I'll go ahead and open that support ticket now...

[RandyRoberts · Accepted solution]

Perhaps this thread will shed some light.

https://one.workfront.com/s/question/0D54X00007ekIbMSAU/what-is-going-on-with-workfront

[Sheri_Whitten]

oye 😞

Thanks for sharing that 👍