Output User Profile Information from specific User Group

josh_curtis · April 3, 2019, 12:54pm

I just turned this up:

gist.github.com

https://gist.github.com/pepebe/2483894

gistfile1.aw

by kairon - http://www.unchi.co.uk/author/admin/

Get all members of a user group in MODx Revolution. This can been done by accessing the database in the following way.

<?php
$usergroup = 4;
$c = $modx->newQuery('modUser');
$c->innerJoin ('modUserProfile','Profile');
$c->innerJoin ('modUserGroupMember','UserGroupMembers');
$c->innerJoin ('modUserGroup','UserGroup','`UserGroupMembers`.`user_group` = `UserGroup`.`id`');

This file has been truncated. show original

I’d switch line 20 to foreach($users as $user) and then you should be able to use something very similar to it.

$username = $user->get('username');
$photo = $user->getOne('Profile')->get('photo');

Profiles are effectively split into two tables. Username is part of the ‘user’ table and ‘photo’ is part of the profile. It appears you’re querying the profile for the username above which would have lead to nothing being returned.

Here’s a breakdown of fields to help with what should come from which part of the user object (‘core’ vs ‘profile’): https://docs.modx.com/revolution/2.x/administering-your-site/security/users