Just created security on a new project by user/group level. The SHOW USERS screen is tied to (mysql) sec_loginusers. Sec_loginusers has: login, pswd, name, email, active, activation_code, priv_admin. When I run the grid, it shows detail of those fields with the addition of: groups. It is grabbing the groups from sec_logingroups. BUT WHERE IS THAT ON THE GRID? There are no events, no field described as group, no foreign key nor triggers on the table. HOW is it displaying this field??
That is a special field called Relation N:N + Group, under Master/Ditail
There is such a thing in the form sec_form_edit_users but not sure of the magic in how it gets into the sec_grid_sec_users grid without showing up as a field or a link on that grid.
what do you need specifically? The function of that field is to insert records into sec_users_groups table.
It’s a grid, though. It should not be inserting anything until I say add new and then it links to a form for the insert. I wanted to add the field to the main page, not a detail, and be able to sort by it. Just a grid should not insert. I checked to see if it was a grid-view form in disguise and it isn’t…just a plain grid.
You must build a query between 2 tables sec_users and sec_users_groups adding the group_id fields. If the user belongs more than one group you are going to see multiple records, one for each group.
This is one way to do it. You can add a field with multiple groups per record.
Regards.
I can see where the one-to-many link was put in in sec_form_edit_users, but I can’t do a thing with it on the users grid. I’ll work around it or just eliminate that grid and make my own with a more useful join I can search. Thanks for your patience.