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 | 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 | 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 |
When you click
, 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.