Author & Readers View selection

Posted on 2005-04-09
Medium Priority
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

p_partha earned 1600 total points
ID: 13743654
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

ID: 13743990
tried that still no good
LVL 31

Assisted Solution

qwaletee earned 400 total points
ID: 13745638
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,

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
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 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…
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…

850 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