Is there a way where I can select all children documents (@AllDescendants & @AllChildren) and exclude specific response documents from the selection criteria

HCL Domino Domino Forum
1

Hi I am using the following View selection formula where I need to view the parent document and all its response and response to response documents except response documents create by form “NEW_Entry” SELECT Form = “NEW_Cad” | @AllDescendants | @AllChildren & Form!=“NEW_Entry” The issue is that documents created by Form “NEW_Entry” are still being viewed in the view Is there a way where I can select all children documents (@AllDescendants & @AllChildren) and exclude specific response documents from the selection criteria

2

Subject: specify forms in selection

Hi,

you can Remove (@AllDescendants & @AllChildren) and specify the form names.

Form =“New_CAD” | Form=“Another_CAD” … and so on and don’t mention “New_Entry”.

the parent child relationship will remain even if you don’t specify the @allchildren. And I presume what I have suggested is better for performance.

Hope this helps

3

Subject: question

Is the New_Entry form used only for response doucments or can it be used for a parent document?

I think using @AllChildren is redundant as @AllDescendants would include both immediate Responses and Responses to Responses.

Assuming the New_Entry form is for responses only, try this: SELECT Form!= “NEW_Entry” | Form = “NEW_Cad” | @AllDescendants

… but I don’t think it’s possible to exclude responses based on a formula when using @AllDescendants and @AllChildren

4

Subject: Question

Thank you Paul for your quick reply

Form = “NEW_Cad” is the parent document and Form=“NEW_Entry” could be response or response to response.

I tried your recommended formula but unfortunately I still can see documents created with Form=“NEW_Entry” in the view. Is there a solution for this issue?

5

Subject: Is there a way where I can select all children documents (@AllDescendants & @AllChildren) and exclude specific response documents from the selection criteria

Thank you Paul for your quick reply

Form = “NEW_Cad” is the parent document and Form=“NEW_Entry” could be response or response to response.

I tried your recommended formula but unfortunately I still can see documents created with Form=“NEW_Entry” in the view

6

Subject: Issue resolved

Thank you Samer so much. It is working now. This is s good solution