Solved

Viewing only those documents that you created

Posted on 2000-03-09
2
173 Views
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!)

Mat
0
Comment
Question by:prenexus
2 Comments
 
LVL 3

Accepted Solution

by:
Simon_Hendry earned 50 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

Or

@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 !!!  
0
 

Author Comment

by:prenexus
ID: 2603117
Simon,

Many thanks!

This seems to work a treat!

Mat
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

943 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

10 Experts available now in Live!

Get 1:1 Help Now