[Webinar] Learn how to a build a cloud-first strategyRegister Now


View Selection

Posted on 2006-06-05
Medium Priority
Last Modified: 2013-12-18
I am having a problem with a view selection... I want the users to only see the records that pertain to them.... I have a selection that looks like:

SELECT ((Form = "Request") & reqRequester = @Name([CN];@UserName))

But sometimes it works and other times it does not. I have a field reqRequester that has the name of the user in it... Please help need it in a hurry...
Question by:TheBull369
  • 4
  • 2
LVL 18

Accepted Solution

marilyng earned 2000 total points
ID: 16834503
SELECT ((Form = "Request") & reqRequester = @Name([CN];@UserName)) << this WON'T work because every one shares the same view.  

If you want them to open the view to see their documents, then you have two choices:

Embed the view in a form and use a category based on the user name on the form. Set the form to never save, put it in a frameset.  Nice thing about this is that you can embed the view in a table, and put other stats or instructions in adjacent columns.

Use Reader's Fields, or a private view for each person, then the formula should work.

Author Comment

ID: 16835673
I do use Reader / Author fields in the documents.... Is there a way to say anyone listed in the author fields can see the documents or anyone with a role listed in the author/reader field can see it???

The database is suppose to have a Manager and User view (where manager can see all of their employees requests as well as there own)

Author Comment

ID: 16835724
Lotus notes cant filter a view dynamically on the fly??
Independent Software Vendors: 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!


Author Comment

ID: 16836172
Here is another question for you... I worked with the Creation of Form route and ran into a problem with it.... I have a button the view that asks the user for input through a prompt and then is suppse to add that information to a field on the selected form. This does not seem to be working.... It will present the input box but will not put the contents into that field??? Is this a limitation to the embedded view?

Author Comment

ID: 16837149
I went with the embedded view approach... worked nice
LVL 18

Expert Comment

ID: 16837993
Ah to answer your questions, if you  use readers fields, then no matter what  the view says, the user can only see a list of things that they are supposed to see.  You can encrypt each document or a section with the user's note Id so that everyone can see part of the document, but only the named person can see the "personal" stuff.

Notes can't filter a view dynamically to a person, because the view is shared.  At any time one or more people can have the view open, so the view will cache the last person.  

The embedded editor will work with the embedded view - see embedded editor in the Designer help.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

864 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