Solved

Viewing only those documents that you created

Posted on 2000-03-09
2
176 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
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…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

735 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