I'm trying to create an interactive filter that will show me only the users that belong to my Service Desk. This is based on the assignment groups they are in. I thought the best way would be to create a database view to list the people and then to use that in the interactive filter.
In my PDI I'm trying to test the logic by creating a database view that shows me only the active users in the Database group. Base data shows three active users in this group so I've made one of them inactive.
I can not, for the life of me, get the database view to work. This is what I've done:
However when I "try it" I'm shown the one user that I set to active = false:
If I remove the su_active clause I get all three users:
I do not understand why this doesn't work! I thought it might be a caching issue but multiple clears of ServiceNow and browser would suggest otherwise.
I've even tried reversing the order of the tables but get the same problem.
Any help and direction would be most appreciated. It's driving me nuts!
