Hi,
I need your help, I created a view in my notes database, my database has approximately 450000 documents, I would like to display only those parent documents that has responses that were modified since 06/11. So far it shows me me all parents documents, and some with a twistie indicating that has a response created / updated after 06/11.
Could you help?
Thanks
Sunny
Subject: Can’t really do that with a view alone
The best way to accomplish this is to write to a field on the parent document whenever a response is first modified. Of course, you would have to create an agent to update your existing documents.
There is no way in a view selection formula to do a “lookup” into the response docs and get the date any of them were modified to determine if it should be in the view. That information is only stored on the response document itself.
Howard