7 Posts
Hoodognik
6 years ago
3
Topic

I am sorry for my english). I'm from Russia and bad speak of english)

I can not choose a specific group of users. Since the users table and field groups store_user no error occurs. help to create a query selecting certain groups of users.

Get a VIP membership
175 Posts
webcastor
6 years ago
0
Level 1

Hello Hoodognik,

Maybe I haven't undestood well what you need, but to have a list of users in a particular group, you need to create a Select Dynamic, with the following settings:
SQL Query:

SELECT u1.name as text, u1.id as value FROM `#__users` as u1 LEFT JOIN `#__user_usergroup_map` AS u2 ON u2.user_id = u1.id WHERE u2.group_id = 2

P.S. I haven't specified the storage, since I do not know what exactly you need and where.

Regards,
Aleksandar

175 Posts
webcastor
6 years ago
0
Level 1

Also, you have to change the 2 in u2.group_id = 2 into a number ID of the group you want.

175 Posts
webcastor
6 years ago
0
Level 1

Sorry, my bad. I have misread your question.

To be able to select the group, you need the field User Groups, that collects all groups from #__usergroups table.

Get a Book for SEBLOD