Browse Screen display rows conditionally
Posted: Wed Nov 28, 2018 7:52 am
How can I do this: Each user only sees his own entries but the globadmin and all users with the role "super" see all entries (of all users).
You can do this by using Hash Cookies in the Browse SQL of the Form properties.
eg.
Code: Select all
SELECT * FROM customer
WHERE cus_employee_id = '#USER_ID#'
OR '#USER_GROUP_ID#' = ''
If you want to know which Hash Cookies are available you could add this to the Before Browse event of the same Form.
Code: Select all
nuDebug(nuHash());
Steven