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.
Code:
( ( SELECT COUNT(*) FROM `#__groupjive_users` AS gj WHERE gj.`user_id` = u.`id` AND gj.`status` IN ( 1, 2, 3, 4 ) AND gj.`group` = GROUP_ID_HERE ) >= 1 )
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.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
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 )
krileon
