Need help with view formula & response documents

HCL Domino Domino Forum
1

I have a view that has a documents in it and these documents potentially have response documents.

I am looking to only show the documents (not response documents) however I want a column that shows “Paid” if any of the document’s response documents have a field where result=1.

For example I could have 1 document with 5 response documents and 4 of them could have result = 0 but one has result=1, then I would want the column to show “Paid”.

Is this possible?

2

Subject: Not possible the way you describe, I think

To show a calculated value in the view (derived from the respones docs), the responses have to be there. The only workaround would be to set the “Paid” flag as a field in the parent document and show that in a column.

BTW - only showing parent documents is easy - SELECT !(@IsResponseDoc)