2. PHPRunner General questions
  3. Advanced security settings, using a group id
This topic is locked

Advanced security settings, using a group id

 		9/7/2010 2:27:09 PM
PHPRunner General questions
jwoker author

(using 5.1) On the advanced security settings I choose "Users can see and edit their own data only", then in the dropdowns - Users table: OwnerID field I select company_id and company_id in the Main table: OwnerID field. But nothing shows up on the list page for the table.
What I am trying to achieve is that those within a company can see and edit records for that company. The advanced setting has worked in the past when I used "id" and "user_id" but it wont work using a different user field.
Sergey Kornilov admin 9/7/2010

Hard to tell what might be wrong without seeing details. As a first step I would enable debug more to print SQL query on the page and see if it looks right.
For this purpose set $dDebug variable to true in include/dbcommon.php file.
jwoker author 9/7/2010

Thank you for the tip. I figured out that I did not have company_id selected for use in the user tables query. So, company_id was showing up as a possible selection on the advanced settings page but not active I guess.