selection within user group

[Vadim]

Task. User should select one user from user group #2 in a form. How to realize it?

 

[cheesegrits]

I'd use a join element, joining to your main J! xxx_users table, with a WHERE filter of something like:

WHERE {thistable}.id IN (SELECT user_id FROM xxx_user_usergroup_map WHERE group_id = 8);

Replace 8 with the numeric ID of the group you need. Replace xxx with your database prefix.

-- hugh