Understanding Parent-Child(=Response) document hierarchy

HCL Domino Domino Forum
1

I know that Notes is no relational database. But I can’t imagine there’s no solution for the following case I need in nearly every database:

I have parent documents and related child-documents in a database. How do you create a view with response documents and integrate a column with data from the parent document? Do I always need to inherit a field from the parent document to the response document and then show it?

Isn’t this how we did it 20 years ago? :wink:

To achieve a consistency of data is unneccessarily difficult in my opinion, if I always have to make sure, that all response documents get updated when the parent doc changes…

Or have I overlooked something fundamental?

Thank you all for your help… :slight_smile:

2

Subject: Understanding Parent-Child(=Response) document hierarchy

Notes is not a relational db. If you need a relational db, use a relational db. Those are kind of the choices, or going to something like XPages.

You may also use Notes data in a relational db to do joins outside of the system. It sort of depends on what you’re trying to do.

You can sync data between parents and by writing querySave code that finds all responses (and response to response docs) and pushes data down to the children. Do a search for recursive coding if you haven’t done this before; there are examples going back to the R4 forum.

3

Subject: RE: Understanding Parent-Child(=Response) document hierarchy

I will try and learn xpages then. Do you have any good tutorials other than the IBM Tutorial-Introduction-to-XPages?

Thank you for your answers…

4

Subject: I don’t do no XPages…

Sorry, I’m an old school kind of guy; this whole ‘Java’ thing is outside of my comfort zone.

Google is your friend. Plus check out the R9 forum.

5

Subject: RE: Understanding Parent-Child(=Response) document hierarchy

There are many good resources.Start at http://www.xpages.info/

There is a resource page at XPages - Resources with links to more resources.

You also have David Leedy’s excellent series of video tutorials at NotesIn9/XPages.tv: http://xpages.tv/

Good luck!

6

Subject: You are correct, for views you have to have the data in the document.

If you want to get more creative and use data, kind of like joins in view like structures you’ll want to use XPages. Views are basically 30 year old technology (still very powerful), but Notes hasn’t stood still, you now have Xpages.