View where all descndant docs meet criteria

HCL Domino Domino Forum
1

Hi,

I’m trying to create a notes view that only shows parent and child documents where the child documents, not the parent docs, meet selected criteria. For example, I want a view that shows lots (the parent document) and containers (the child documents) where all the containers in a specified lot have a Status of “Shipped”. I tried:

SELECT (Form = “lots” | @AllDescendants) & Status = “Shipped”

but that failed. Any suggestions?

Thanks in advance,

Maynard

2

Subject: Try: SELECT (Form = “lots”) | (Form = “containers” & Status = “Shipped”)

3

Subject: RE: Try: SELECT (Form = “lots”) | (Form = “containers” & Status = “Shipped”)

Tried that, but it shows me all parent documents, including the ones that don’t have child documents with status = “shipped”. I only want to show parent documents with child docs that have status = “shipped”.

I might have to create a flag on the parent document and only show docs and children with that flag, but I’d like to avoid that…any other thoughts?

4

Subject: RE: Try: SELECT (Form = “lots”) | (Form = “containers” & Status = “Shipped”)

You cannot select a document (Parent) based on data in other documents (Children).

The flag in the parent is the only way to go.