By
Published: 05 Aug 2005
Can you help a newbie? I am looking to create a view of documents that do not have Ref documents created for them. I wish to omit any document that has Ref documents. Can you help, either with code or else by directing me where to find the solution?
A view selection formula can only select documents for inclusion in a view based on the data in
that document, or based on whether its parent is also in the same view. There's no way to select only documents that have no responses (or that have responses, or whose responses contain particular field values).
What you can do, however, is write a server agent that will scan for documents that meet your criteria and set a field value in those documents. The selection formula can use this field to decide whether to include them in the view. Or the agent can find these documents and put them into a folder. (Use the access properties of the folder to prevent users from manually adding and removing documents in the folder.)
I wrote an article for The View that explains how to create fancy views like this. If you're not a subscriber, you can still download the sample database.
Do you have comments on this Ask the Expert question and response? Let us know.
Dig Deeper on Lotus Notes Domino Application Development
Learn how you can use LotusScript and OLE to create and populate Microsoft Excel spreadsheets, as well as a little bit about Lotus Symphony.
Continue Reading
Discover options you can use if you'd like external users to be able to access a workflow-based Notes Domino application through different ...
Continue Reading
When Notes/Domino developers say they want to "update the fields" in tha Lotus Notes view, they usually mean that they want to cause computed fields ...
Continue Reading