[SOLVED] Can I filter user lists by Groups (via Group Jive auto join field)?

Hi,

I'm using the auto join field to add new users to groups. I wanted to create a user list per group. Is there a way to assign a user group to a list? Here's what I've tried...

'cb_groupselect'="Entertainers" shows no results

cb_groupselect="Entertainers" produces an SQL error

The option in the field to allow it to be searchable is locked at 'off'. I also tried turning that option on in the database so it would hopefully show up in the simple filters on the user list, but it didn't do anything.

I looked through the documentation, but maybe missed something... am I missing something?

One more note... When you select the option in cb_groupselect field to show on a profile tab, it doesn't show.

Auto join has no storage. So there's nothing to filter the userlist off of unless you directly query the GJ table. This can be done with the below Advanced filter for example.


Replace GROUP_ID_HERE with the group you want the users from. Please note this is an example and may need to be adjusted as needed.

That works great... Thanks! I should mention in case someone else is looking for an answer to this that it didn't work until I removed an extra '('. So, for example, the following beginning with 1 left parenthesis instead of 2 worked for me:

( SELECT COUNT(*) FROM `#__groupjive_users` AS gj WHERE gj.`user_id` = u.`id` AND gj.`status` IN ( 1, 2, 3, 4 ) AND gj.`group` = 5 )

Thanks again!