Solved

Viewing only those documents that you created

Posted on 2000-03-09
2
174 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 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