View Selection

Posted on 2006-06-05
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
    LVL 18

    Accepted Solution

    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

    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

    Lotus notes cant filter a view dynamically on the fly??

    Author Comment

    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

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

    Expert Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
    Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now