I am trying to design a view called My Forms, and I have tried using the following search criterea.
SELECT (@Name([CN];@UserName) = @Name([CN];kwdAssignee))
I have since discovered that the view index is built from the selection criterea and I dont think this will work for individual users using the same database at the same time.
I followed another posters suggestion and tried to use an embedded view using ‘Show Single Category’, but this isn’t really working for what I want either. I believe you cannot use ‘@’ commands in the Show Single Category formula.
Does anyone have any other suggestions on how best to approach this.
Subject: Using @Username in view selection criterea
Hi,
What you mean by “I believe you cannot use ‘@’ commands in the Show Single Category formula” ?
Yes you cannot use @ command but @Name([CN];@UserName) is not a @ command, it’s @ function.
If you want a view to display all documents of the current user, thus, use an embedded view with “Show single category”, it works (Notes and web clients).
Search in Designer help for something like this “Display single catergory in embedded view”
HTH
Thierry
Subject: Using @Username in view selection criterea
The single category will work just fine. Categorize the view on @Name([CN];kwdAssignee) and use @Name([CN]; @UserName) in the single category formula.