Hi
Subject: View Selection formula
The view is built by the server for all users, not for each user on their own Notes client. You would need a SPOFU view to be able to use @UserRoles or @UserName in the selection formula.
Since you are the only one (if I understand you correctly) that needs to be able to see both countries, you should build a private view for yourself, or a shared access-controlled view, to display both countries.
SPOFU = Shared, Private On First Use
/Peter
Subject: View Selection formula
For a database on a server or a local database with “Enforce a consistent Access Control List across all replicas” in effect, returns a list of roles that the current user has. Roles are defined in a database’s access control list.Syntax
@UserRoles
Return value
roles
Text list. Each item in the list is the name of a role that the current user has in the current database. The role names are enclosed in brackets. Returns an empty string (“”) if the current database is local and “Enforce a consistent Access Control List across all replicas” is not in effect.
Usage
This function does not work in column, selection, mail agent, or scheduled agent formulas.