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.
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
Also, you have to change the 2 in u2.group_id = 2 into a number ID of the group you want.
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.
