Author & Readers View selection

Posted on 2005-04-09
Last Modified: 2013-12-18

I have two fields in a form; 1 Author & 1 Readers the code is the same:

@UserName : "[CSRep]" : "[Office Manager]"

This works fine, ie it restricts anyone other than the author of the document or anyone who does not have the user role of "CSRep" or "Office Manager" from either editing it or infact reading it.

The issue i have is with the view, as everyone regardless of the above restrictions can see the totals in the view, i have played with the following selection code, but to no avail:

& @IsMember(@UserName; Authors) | @IsMember(@UserName; Readers)

What i am after is the user only seeing his/her docs and only the totals that relate to those docs and not the totals of all the fields regardless of being able to view the invisible docs that the totals relate to.

Any help would be great Thanks

Question by:DavidAbbott
    LVL 14

    Accepted Solution

    it hides all documents where user isn't in readers field but totals tally with every document in the database regardless of whether they are hidden or not. YOu can try using private on first use views


    Author Comment

    tried that still no good
    LVL 31

    Assisted Solution

    Hi Synthetics,

    You can't eliminate the totals from the bottom of the view, but you can eliminate subtotals (catgeories).  Normally, if theer are categories that all the documents have reader fields so you can't see them -- you will see "empty" catgeories, which show titals.  If you choose the view option to not show empty cateories (in view design), you will eliminate them, but you can't eliminate the totals from the overall view.

    Private views will work.  You responded to Parha that it did not work, but that isn't true -- the private views index only data the user can see, so it is as if the document doesn't even exist, even for totals.  I'd have to see a demonstration otherwise, because that is teh way it has ALWAYS worked, ever since reader fields started in R3.

    Best regards,

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

      In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
    IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    779 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

    14 Experts available now in Live!

    Get 1:1 Help Now