Solved

Embedded view vs private view.... What's the best approach for filtering a view?

Posted on 2007-04-09
4
237 Views
Last Modified: 2013-12-18
Hi,
I trying to design a Notes 7 database that will store activity for a given set of accounts. The accounts have
separate managers and I need the view to filter the account activity so that managers only see the detail for
those accounts that they are assigned to. I considered doing this via a private query, but I haven't used embedded views before and it looks like I could get the same result via that. I've been toying with it but I'm struggling a bit. The base view lists all accounts with the first column being categorized by account name and the next 3 being account activity. I took this and added to a form as an embedded view, then added code to the show single categories (Account = "name of the account"). When I try to create the form it
failed telling me that the Category must be a single string.

Could give me some insight as to what that's telling me? Also, I'm concerned that I'm off on this approach too. Is there a better way to filter, or leverage security,  on a view? For a row, not a column?

Sorry to be so long-winded.
0
Comment
Question by:BillTr
[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
  • 3
4 Comments
 
LVL 63

Accepted Solution

by:
SysExpert earned 500 total points
ID: 18876698
Are you using reader/Author fields for security of the Doc or something else ?

You can use Roles, but it is difficult.

The reader/author fields provides the best security, but may require the most up-front work to get everything done properly.

Please provide more details.

I hope this helps !

0
 

Author Comment

by:BillTr
ID: 18876976
Thanks for getting back!
Here is an example of what I'm trying to get into the view.
Base View:
Account                    Activity Date                     Activity                
Acct A                          4/2/2007                         +100
Acct B                           4/2/2007                         +250

Embedded                                                                              
Manger Smith is assigned to Acct A. So he should see
Acct A                          4/2/2007                          +100

The form on which these values exist is called summary1.

I built the base view by just selecting summary1. The field on the form that has the manager name is called test1. Then I inserted that view into a brand new form called "embedded summary" and changed the Show Single Category with the following: (@Name( [CN] ; @UserName) = @Name([CN];test1))
I added my name to summary1.test1 and I thought from there I could create a doc with the new form and see data in the for my name. So far I have not been successful gettting any result.

I up'ed the points on this.
0
 

Author Comment

by:BillTr
ID: 18877211
When in designer, I look at the embedded view on the form I can see the base view displayed. So, I suspect my problem is on the syntax for the single category. The first column in the base view is the user name (test1). I have tried several variations on this, but I either get a blank on the embedded view or I get the single string message.

0
 

Author Comment

by:BillTr
ID: 18885499
I didn't realize that the read field can filter selected rows. Thanks for the fast response
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…
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
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

717 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