How do I make a list of all the admins of GJ groups?

Hey

In order to solve the above, I was thinking of promoting the admins of GJ groups into a separate ACL. I am aware that auto actions is the best thing to use in this case, I was just wondering how best to do it?

At the end of the day, what I want is to have a list with all admins and moderators as well as to put some kind of badge on their profile picture (I know how to do that as long as they are in a separate ACL/have some field in CB activated).

Another idea would be to have a field in CB profile set to YES if they are admin (I can take it on from there to put them in different ACL and do the rest of the changes needed)

You don't need ACL for that. For the list you can use a userlist with an Advanced filter to filter it down to only group owners. Next for the badge you can use a CB Query Field to check if they're a group owner then condition the query field using a substitution IF statement to output a badge of some sort. No need for extra ACL. If you still want the ACL you'd just condition the query field in your auto action to determine if they should have your usergroup or not. The below queries should do what you're wanting.

Userlist Advanced Filter:
CB Query Field:

Ok thanks. I am starting to understand it. Just one more thing: moderator= status 2 , admin = status 3, group owner= status 4 no?

Second question: Is it also possible to have in the list the name of the group that they are owner, admin etc... ? Maybe have a link to that group as well?

I cant find the button for this nor can I find a way to do it... Maybe Query field and then showing the Query field in the list? Any simple way to do that?

Ok thanks. I am starting to understand it. Just one more thing: moderator= status 2 , admin = status 3, group owner= status 4 no?

Yes, all the status are as follows.

-1 = Banned
0 = Pending
1 = Active
2 = Moderator
3 = Admin
4 = Owner

Second question: Is it also possible to have in the list the name of the group that they are owner, admin etc... ? Maybe have a link to that group as well?

You'd need a CB Query Field set to output multiple rows for that, but yes it's doable. Example as follows.

Query: Output: Multiple Rows
Row:

Thanks, very very helpful. I did not know that you could have a multiple row output of CbQuery. Opens new ideas...

I will have to get into reading up on CBQuery and will then post the final product here in case other people want to read up on it.

Hey,

Your query is wrong. I got a 1054 error.

I had a look in the table and found out that the group category is in another table (furthermore there is no NAME in the table #__groupjive_users).

How do I add it in there that it should SELECT from #__groupjive_users the ID and group_ID and then fetch the corresponding "Category" from #__groupjive_groups?

PS: I am starting to get it...