Lotus Notes View for documents with No children

90 pts.
Tags:
Formula Language
Lotus Domino
Lotus Notes View
Is it possible to create a view for only the documents that have No responces/children using Lotus Notes Formula.

Answer Wiki

Thanks. We'll let you know when a new response is added.

No. In general, the view selection formula can only refer to the data in the document you are considering for inclusion. The only exception is @All<i>xxx</i> functions which can include responses based on whether their parents are in the view — sort of the opposite of what you want.

What you can do, however, is write agents to test whether documents have responses and flag them accordingly by setting a field. Then you can use that field in the view selection formula. This is easiest if responses are only created, never deleted, because then you can write a “when docs created/modified” agent to flag the main document when the response is created. If you have to notice when the last response is deleted, it becomes more complex, but it can be done using LotusScript scheduled agents.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Brooklynegg
    This is not possible. You can create a folder, then create a LotusScript agent to loop through parent documents, check for children, then move them to the folder if they have none. This folder would only update when the agent runs. The agent would need to empty the folder at the beginning of each run to clear previous results. It may be possible to do something like this with clever use of @formula, but you would still need to move the documents to a folder for display.
    3,845 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following