Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Show parents and responses in seperate view frames

Posted on 2009-04-30
Medium Priority
Last Modified: 2013-12-18
I have this idea that I would like to have two views one showing response documents and one showing parent documents. These would be displayed in two frames on top of each other.

I would like to be able to click the parent document and see the children documents in the frame below.

My ideas were to try and use the onselect command on the view to pass the universalid as an environment reference between the views then update the selection formula.

Would this be easier with embedded views? What about the @SetViewInfo command?
Question by:RBCHARNLEY
LVL 22

Accepted Solution

mbonaci earned 2000 total points
ID: 24270885
It would be better to use Embedded View for that purpose.
The first column should have property "Show single category" selected.
Parent child relationship is maintained through $Ref field in response documents (it holds UNID of its parent doc).

From designer help:
You can restrict an embedded view to a single category. However, for the Show Single Category option to work, the embedded view must first have been categorized . Note that the category name will not appear in the embedded view. For example, if you check the Show Single Category box for a category named Kitchen, the embedded view will not have a line named Kitchen. Instead, you will see under Kitchen documents such as Stove, Refrigerator, and so on.
Also, if the Show Single Category formula evaluates to an asterisk (*), all categories are shown. This is useful if, for example, you want to restrict an embedded view to a single category for Web users and show all categories for Notes users.

  1.      Open a form in Designer.
  2.      Choose Create - Embedded Element - View.  The Insert Embedded View dialog box appears.
  3.      Highlight  the view you want and click OK.
  4.      Choose "Show Single Category" as the event in the object list in the Programmer's pane.
  5.      Enter a formula to compute the category. The formula can make use of information about the current user and information from the current document (the one embedding the view).

Hope this helps,

Author Comment

ID: 24271697
Okay here it is

You embed a view on a form (it dosen't work on a page) with the show single catergory formula
The view embedded should be catergorised by a column containing (@Text($REF)) and contain all children documents you want to show.

Create a second view that has in just the parent documents
In the on select command of this view put

And in the queryrecalc command

And finally the query open command

Create a frameset and split it into two rows. Make this the default frameset for the database.

In the top row specify your view of the parent documents

In the bottom row specify the form your embedded view is on

Load your database. Now when  you click a document in the top it will refresh the view at the bottom and re-filter appropriatley.

Thanks for your suggestions.


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone 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

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

564 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