CODEWITHSUNDEEP
selectlotus-noteslotuslotus-formula
PRNDL Development Studios
PRNDL Development Studios

Reputation: 3300

Select only documents with a certain response (Lotus Notes)

In lotus notes, I have documents which can have many types (Forms) of response documents.

I would like to select documents that have a certain response document with them.

For example:

Doc1
--Response1 (Red)
--Response2 (Blue)
Doc2
--Response1(Red)
Doc3
--Response1(Blue)
--Response2(Green)

If I would like 'all documents with a response of form type 'blue'' (eg Doc1 & Doc 3), how would I do that? It seems like I can only base criteria off of the main document.

Thanks

Upvotes: 1

Views: 1209

Answers (1)

David Navarre
David Navarre

Reputation: 1022

It depends on how you want to select them. Note that response documents all contain a reference to their parent document in the $REF field.

In a view: If you want them to appear in a view only if they have a certain type of response document, they need to have a field value that indicates they have that kind of response. So, when someone saves the response document, have it also change a field on the parent document to indicate that it has that kind of response.

In an agent: Instead of looking at the parent documents, cycle through the response documents of the type you want and return information about or from the parent document.

Upvotes: 1

Related Questions