Hi
I am trying to create a view, which only displays the documents based on the persons username.
This is for a change request database, and I want the developer to only see work that is assigned to him.
In the Assigned to column, I have the following, but it does not seem to work
@Name([CN];@Username)=change_request_developer
Any ideas;
Thanks
sCott
Subject: Display in View only by username
Look at including Readers and Authors fields. That way, only the people listed in these field can read and/or modify the document. And it doesn’t show up in the view if the person isn’t in the Readers field.
Remember to include a developers group or role in the Readers and Authors fields or you won’t be able to see the documents either.
Subject: Display in View only by username
If the developers are using notes clients (seems like they would) create a shared > private first use view - with the selection formula @username = change_request_developer
Subject: Display in View only by username
Well, as if there were not enough answers yet …
… but since the suggestions are so different, I’d like to line them up one by one.
Readers fields
If one developer must not be able to see another one’s CRs, you HAVE to use readers fields. No need for any other action, documents, a developer is not allowed to see will just be invisible. If displaying a personalized list is just a convenience feature, do NOT use readers fields, as they will drag performance unnecessarily, then.
Shared, private on first use views
They will do what you need (if security is not a concern), since you can personalize them using @UserName. But from a maintenance point of view they are pretty much a nightmare. E.g. refreshing those private views after making a design change to the original view requires quite a bit of additional work.
Single category embedded view
My personal favorite (again, if security is not a concern), I have to admit. You would categorize the view by a field containing the developers name and provide @UserName (or a converted form like @Name([CN];@Username), whatever is in the field) as the single category selector. Very easy and slick. In really big views, performance will be somewhat degraded compared to the private view.
For a non-embedded view, you can have the same sort of functionality using @SetViewInfo.
Subject: Display in View only by username
@Username should not be used in a public view as it produces unpredictable results.
You need to use a single category embedded view. The notes help for @username provides a link with instructions.