-
- 330 Posts
I'm creating some custom queries and need to figure out the relation between Member Groups and Document Groups.
My ultimate goal is to display the resources belonging to a particular User Group when a user log in. I am able to get their User ID from Sessions and so the relations I have figured out so far are:
User ID -> Member Groups Table -> ??Unknown table that pairs Member Groups with Document Groups?? -> Document Groups Table- > Resources Table
I just cant find that missing table(s)!
If any one can help me out that would be awesome!
Thanks
-
- 24,544 Posts
I think you're looking for 'modAccessResourceGroup' (the modx_access_resource_groups table).
http://bobsguides.com/modx-object-quick-reference.html#modAccessResourceGroup
-
- 24,544 Posts
I don't know of a way to get them all. You can get the current user's groups with this:
$modx->user->getMany('UserGroupMembers');
I think meltingdog wants to get the document groups linked to the user's user group.