Example: IDO filters

This example applies to the Row Authorizations form.

Simple IDO filter example: Username Property = Current User

Suppose 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 could set the fields like this:

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.