I have a table with records of the timesheet, I want each login user can view the records for himself only. Because I do not want people to know others work time. I have a column called user with the user id of the user.
How can I filter the data source for the view with the login user only? if the user is an administrator, we do not need to filter the records.
This can easily be accomplished with an access group. Check the constraints section of the manual.
Glad it worked for you. You can filter a view based a user but it is not as dynamic, powerful, easy, and can be changed “on the fly” in production as business needs change. For example filtering rows based on a Role or Position.