RL Query Builder

Generated RL Query:

☝️🤓 The Join Field does not support dot-walking. If you need to dot-walk, please use a different method.

not enough information

Explaination: On a GlideRecord (or Aggregate) for the table sys_user_group, this will find all groups with at least one active member: we query from sys_user_grmember, "join" on the group field, and check for active users in the sys_user table. The condition is >= 1, meaning we want groups with at least one member. The additional query filters for active users.