Viewing only those documents that you created

Posted on 2000-03-09
Medium Priority
Last Modified: 2013-12-18
Hi all,

Ive got a database that has a view in which I only want the person that created it (and some defined managers at created time).

The view seems to work ok for me using this code...
select form = "yadda" & @username = createdby | @username = manager

Createdby and Manager are fields on my form yadda.

Now this seems to work most times, but sometimes there is an anomoly and it fails.

Is there another way I could perform the same operations? I dont want to create personal views (30,000 employees is a lot of personal views!)

Question by:prenexus

Accepted Solution

Simon_Hendry earned 200 total points
ID: 2602892
You should use author and reader name fields to control the document  access, using view selections like this are pretty flakey at the best of times and course the view to need to be re-indexed a heap because @username is not static....

So create a field called readAccess on the document and make it a Readers Field

and also create a field called WriteAccess on the document and make it an Authors field

No you haven't specified whether there is any flow control in the document so I will assume that the access to the document is not dependent on some "Document State". So you should just be able to make both fields Computed when composed and set to the formula

@UserName:"[Managers]"  if you are using a Role called "Managers" in the ACL to specify managers


@UserName:"<Managers Name>" where <Managers Name> is either the name of the Manager or a group containing the managers or something like that...

This way only the user who created the documents will be able to see the documents....

PS .. It is probably a good idea to use a role, so if the manager changes you only have to change who is in the role and not edit thousands of documents..

Hope this Helps !!!  

Author Comment

ID: 2603117

Many thanks!

This seems to work a treat!


Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
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…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…

587 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