Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

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 video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

580 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