Dropdown with users with specific usergroup

Question

Hello,I use chronoforms 6I would like to have a dropdown field with all users with usergroup = 10I use Read Data, this works. I can choose the database table "#_users"But now it shows all users. I need to filter them with usergorup = 10Can you help we how to do the filtering settings?Thanks a lot,Pascale

Max_admin · Accepted Answer

Hi Pascale,​In the "Read data", add a new model, call it "UserGroup", then in the new area, select the "#_user_usergroup_map" table, set the relation type to "one matching record, foreign key in this table", set "Related to" to the model of the users table, set the "foreign key" to "user_id", go back to the "users" table area, set the "where conditions" to:UserGroup.group_id:8Best regards

Forums

Dropdown with users with specific usergroup