https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/
× Welcome to the ToolsJX forum!


Default view for current logged in user.

  • mstieg
  • mstieg's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 5 months ago #3282

Could you please provide a more comprehensive explanation of how to have a table view default to the data belonging to the current logged in user?

I have a field in the table named 'owned_by' which was populated with the value of the logged in user that created the record.

I have tried adding 'owned_by' = '@user_id' (with and without quotes) to the Additional Condition WHERE value and get no results.

The table works fine if I turn on Show Search Form and remove the above WHERE clause.

Last edit: 9 years 5 months ago by mstieg.

Please Log in or Create an account to join the conversation.

More
9 years 5 months ago #3392

try without quotes

owned_by = @user_id

In MYSQL there is a difference between similar, but different quotes ' and `. Maybe this leaded to confusion.

Please Log in or Create an account to join the conversation.

Moderators: tomaz
Time to create page: 0.124 seconds

Contact Us

Contact us on Discord

Contact us on Facebook