Example: IDO filters

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.