Nicolás asked 3 years ago
Hi, I have several comercial people accessing the same grid, so they can see all existing clients at once. I want each of them to be able to edit only their clients (other comercial people clients blocked for edition). It is possible to allow edition only on specific rows?
Thank you!!
1 Answers
Abu Ghufran Staff answered 3 years ago
Hi,
I think practical way to solve this situation is to use WHERE clause in your select query that will limit to show clients based on logged in USER_ID. e.g.
$g->select_command = “SELECT * FROM clients WHERE owner_id = “.$_SESSION[“logged_in_user_id”];
Your Answer
