Example: IDO filters

This example applies to the Row Authorizations form.

Simple IDO Filter Example: Username Property = Current User

You want to allow all users to see their own user information on the Users form (description, email address, group memberships, etc.) but not any other user's information. To do this, you would set the fields as follows:

Field Setting Notes
IDO UserNames The filter applies only to the UserNames IDO.
User   Leave blank so the filter applies to all users.
Group   Leave blank so the filter applies to users in all groups.
Property Username the User ID field on the Users form is bound to the UserNames.Username property. (The Usernames.Userid property is only used internally.)
(Operator) =  
This Value Current User  

When you click Add This Clause, the pseudo-SQL query that displays looks like this:


(Username = dbo.UserNameSp())

After you activate and save the filter, any user who logs in (and who has the proper authorizations for the form) can open the Users form but will see only the record that matches their user ID.