Login Restrict Records Global
Is there a way to build a stateless form and use that form to create a global variable or session in which i can restrict records. I need a way for people to use this login form to view records but also restrict records I don't want them to see.
The standard User functionality only stores two variables (added_user & modified_user) . Well i am the only one adding and modifying records so these filter don't do any good when you want to restrict records from people who did not create or modify them.
I have a table of users with the field username and state. I have another table titled cities that has the state and city name. I want the users to login using a stateless form, and then all records across the application that aren't in his/her state be restricted/hidden so that the user only sees the cities in his own state.
I have the stateless form that sets a variable for that page and then I can use that variable in a filter but the issue is when that user navigates to another page the variable/session is lost.
I need a global solution / session that will save the data and pass it from page to page.
I have looked at this (below) page but it makes no sense to me at all.
Thank you for any help.