I could swear that I read that it is possible to get a collection, then get a smaller collection from that collection. I've checked R5 and R6 help and can't find this documented. Do any of you know if this is possible? Specifically, I want a scheduled agent to get a collection of all unprocessed documents, then get all the documents in that collection that have a specific form. I'm already walking through the collection and using Select Case using the form value, but it takes too long to process. Finally: Is there an incorrect database setting that could prevent a document from retaining a Processed value when I set it? My assumption is that as I walk through the collection and mark documents as processed, they should not get processed the next time it runs (unless modified) even if the agent ends abnormally (takes too much time). Instead, it appears that all documents are found as new or modified every time the agent runs.
This runs as a scheduled agent on an R6.5.3 server with a maximum agent run time of 90 minutes.
Thanks in advance for any help you can provide.