Avatar of everetjo
everetjo asked on

showing res and res to res docs in view hierarchy

I have a project database with a view that has an all project view.  within this view, i need to show each project, then the product specs, system specs and testing specs.  in a separate layer, I need to show each version of the particular spec doc :  here's an example :

project1
     projec specs
          proj specs1
          proj specs 2
    system specs
          sys specs 1
          sys specs 2
project2
      projec specs
           proj spec1

i have tried having the specs documents as response and response to response docs and i still ahve trouble.  I'm using the inherit values feature in an attempt to copy the unique id to the child docs

Lotus IBM

Avatar of undefined
Last Comment
Sjef Bosman

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
olaraak

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
everetjo

how should the document types be set?

As it is right now : main form is document, and spec documents are of type response.

i still cant get them to appear in the hierarchy.
olaraak

Response documents are direct responses to main document.
Response to Response will do for any other level of hierarchy.

In Lotus Notes, there is always more than one way to accomplish something.

You can have different types of forms, categorized as shown, or you can use view categories as pseudo-levels of documents.

You can even not use document hierarchy at all, using Document type forms for specs, and using two category fields: one for Project (can be filled from list of Project documents), and another with spec type- Project or System.

Then, in view, show two category columns - first column is Project name and second column is category Spec Type. The view will be categorized by project and spec type.

Or, you can have Project documents as parent (or Document type) and specs as Response. In spec document, you can inherit Project name and use one category field for spec type.

And more step further, you can use property of Spec (Response) form called Versioning, specifying if new versions will be responses, parent or siblings.

Plenty of options, as you see.
Sjef Bosman

Documents must have been created as Parent/Repsonse/Response-to-response documents, otherwise you'll never be able to shown them in a response hierarchy. You can set or change parent-response relations later on with LotusScript, by using the NotesDocument.MakeResponse method. If that's not done, then only olaraak's 2nd alternative will work. You can create a view that is similar to the hierarchical view, but it will never be exectly equal.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck