Lotus Notes Views Specific To A User

Posted on 2005-04-04
Medium Priority
Last Modified: 2013-12-18
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?


Question by:morganw1978
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

BarryTice earned 150 total points
ID: 13703460
morganw1978 --

The short answer is that notes doesn't work this way. The reason is because the Notes server "indexes" each view at the server level, and there's only one index for the view. With what you're asking for (and what millions of other Notes users have asked for in the past) would require a separate index for each user.

That's where "Public/Private On First Use" views come into play. You can create a view and mark it as public, but private on first use, and use the username as part of the selection criteria there. The first time someone opens the view, it will create a separate copy of that view for the user, with the index stored locally on the user's desktop (or laptop, whichever), which overcomes the problems of having only having one index on the server.

The problem with this is, if you need to make changes to the view, you have to go to each individual workstation and remove the views people have created for themselves in order for them to get the updated view. If your view is stable and not changing much, that's not much of an issue. If you're still in develop-prototype-develop stage, you might want to wait a while longer.

The other way around this, if you're in R5 or later, is creating a page with an embedded single-category view. Technically this isn't a view, and it requires a bit more tap dancing to get things to look and act the way you want. But it will work.

Hope this helps.

-- b.r.t.

Author Comment

ID: 13705230
Brill thx for the tip particularly holding off the release of the view when prototyping and developing.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question