Hello,
I use chronoforms 6
I would like to have a dropdown field with all users with usergroup = 10
I 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 = 10
Can you help we how to do the filtering settings?
Thanks a lot,
Pascale
I use chronoforms 6
I would like to have a dropdown field with all users with usergroup = 10
I 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 = 10
Can you help we how to do the filtering settings?
Thanks a lot,
Pascale
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:
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
This topic is locked and no more replies can be posted.
