Lotus Notes Views Specific To A User
Posted on 2005-04-04
I have a Lotus Notes form that assigns job items to individuals. The name of the individual assigned a job matches their name in the ACL. I want each user when they log on to the Notes DB and opens the view and to see the job items relevant to them. Hence...
SELECT (my_form) & assigned_name = @Text(@Name([CN]; @UserName))
...would return a set of items for Joe, and on a different machine would return a different set of items for Karen.
What actually happens is that each time the shared view is opened on a user's machine, the view returns those items relevant to the person who first opened the view - it does not seems to reevaluate the final condition of the above statement because it returns the items displayed by the first person to open the shared view. I guess it is because I am defining this view as shared but does anyone have a workaround which means that each user only see their job items everytime the view is opened?