Creating hierarchical view

Hi,

I’ve checked a previous posting of how to create a hierarchical structure with notes documents (http://www-10.lotus.com/ldd/nd6forum.nsf/DateAllThreadedweb/7f4fddbd51e382c385256cd8007cb539?OpenDocument).

So now I have documents that refer to their parents using a field which contains a unique identifier of the parent.

My question is, can I use this data to somehow create a view that shows the hierarchical strucure? So I don’t want to use the response documents.

Any idea’s/examples?

Regards,

Wouter de Vaal

Subject: Creating hierarchical view

The trick we have used to acomplish this is to have a sorted hidden column as the first column in the view. e.g.

ParentDataValue + “|” + ParentLink + “|” + ChildValue

Where:

ParentDataValue is some common data value between the parent and the child (e.g. company name)

ParentLink is the unique identifier you mention.

ChildDataValue is a sortable datavalue for the child docs (e.g. PersonLastName)

With this scheme, your view is sorted on a viewable data value and quick search still works! Since the parent doc does not have a ChildDataValue, it floats to the top of the group.

If you want to indent the children, just add

@If(Form =“Child”; " " + ChildDataValue; ParentDataValue)