UserGroups

[Former Member]

Hi,

Could you please help the relationship between User and UserGroup.

I am unable to read the User Groups for the particular user using flexible search query.

Thank you. Regards, .M

[Former Member]

Hi Praveen,

I think the relation you are looking for is PrincipalGroupRelation. See if below query works for you:

    SELECT {u.uid}, {ug.uid}
     FROM {PrincipalGroupRelation  as pgr}, {User as u}, {UserGroup as ug}
     WHERE {u.pk}={pgr.source} AND {pgr.target}={ug.pk}

Hope this helps and Best Regards,