?
Solved

View Display

Posted on 2003-02-22
5
Medium Priority
?
203 Views
Last Modified: 2013-12-18
Hi,

I have a view named 'Branches'.
The columns that i have are : BranchName, Type, Description, Tag No and Serial No.

The BranchName column has : BranchA, BranchB, BranchC,..... which is categorized

 
    BranchA
                Xxxxx  ……..
                 yyyyyy  ………

    BranchB
               aaaaaa …………
               bbbbbbb ………….

    BranchC
                eeeeee …………
                ... and so on


The problem is i want a view wherein it display's only the records of BranchA when i preview it in Notes Client(5.0.11)other should not be shown.


Should i have to go for a new view? How do i do it?

0
Comment
Question by:Ram123022203
  • 3
  • 2
5 Comments
 
LVL 7

Expert Comment

by:scottrma
ID: 7998714
You need to change the view selection formula. You can either modify this view's selection formula, or create a copy of the view and modify the new view's selection formula. You need to add this condition to the current selection formula:

& BranchName = "BranchA"

so it would end up being something like this:

[current selection formula] & BranchName = "BranchA"

Regards,

Scott
0
 

Author Comment

by:Ram123022203
ID: 7998913
Already there is a formula for 'View Selecton' it is :
SELECT Form = "Equipment Profile"

And the BranchA column has a programmtic use name as : $11 and the column title is 'BranchName'which is categorized.

As u said i added the command like this:
SELECT Form = "Equipment Profile" & BranchName = "BranchA"

when i preview the view in Lotus Client(5.0.11) its blank.

Am i going wrong any where?

0
 
LVL 7

Accepted Solution

by:
scottrma earned 90 total points
ID: 8000632
Are these branch documents response documents? Try deselecting the view option "Show response documents in a hierarchy".

Also, are you sure you have the correct case, i.e. BranchName = "BRANCHA" is not the same as BranchName = "brancha".

Regards,

Scott
0
 

Author Comment

by:Ram123022203
ID: 8001650
Hi

I got it working, i put the following formula in the 'Veiw Selection' :

SELECT Form = "Form Name" & BranchName="BranchA" and removed the 'categorized' option for the first column and gave sort by ascending.

Now i am able to display the branch i want.

Thank you for your help and suggestions.



0
 
LVL 7

Expert Comment

by:scottrma
ID: 8011726
Glad to hear you were able to get it working. If you feel my comments helped you, please click on the "Accept comment as answer" link next to the comment that you feel helped you the most. Otherwise, if you feel that you solved the problem on your own, post a 0-point question in the Community Support area with a link to this question and ask them to refund your points.

Regards,

Scott
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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 Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Suggested Courses

579 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