Toggle Adv. UserID Security filter for administrator users

mpopkin · Post by **mpopkin** » Wed Apr 29, 2015 5:41 am

Is there a way to default a form to be filtered by UserID for administrator users, with an option, perhaps a toggle button, to show all records?

The administrator users need to view just their records, by default. Then have an option to see them all, if needed.

Thanks!

vincenthung · Post by **vincenthung** » Tue May 05, 2015 1:55 pm

Administrator had the right to list all the records of the table which is setup with "User ID Security"
So you can filter the records in "Recordset_Selecting" server event with condition to perform your task.

For example: (If the query string value exit, show all records)
if ((CurrentUserID() == "-1") && ew_Empty(ew_Get("<parameter>"))) {
filter = "<User ID Field> = -1";
}