Solved

Viewing only those documents that you created

Posted on 2000-03-09
2
172 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
Comment Utility
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
Comment Utility
Simon,

Many thanks!

This seems to work a treat!

Mat
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

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…
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 discusses moving either the default database or any database to a new volume.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

762 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

6 Experts available now in Live!

Get 1:1 Help Now