dynamic group query for manager not functioning logically

[cscott-sqz]

I'm trying to create a dynamic group for "executive management" defined by "any user whose manager = (the CEO's name)."

I use the query builder and wind up with the statement:

user.managers.exists(manager, manager.user_id==userId('<CEOuniqueID>'))

Unfortunately, this returns not only the users who's "Manager's email" filed is set to the CEO's email address but everybody under them!

That makes the query effectively useless; definitely need some more granularity built into this (ie the ability to specify the number of levels to go down this reporting chain).