I’m trying to incorporate something similar to @dblookup in a LotusScript Agent.I’ve tried Evaluate for the @dblookup statement, but am getting nowhere.
I’ve read that you can use GetAllDocumentsByKey.
Does anybody know how I can use this to return the last value in a specific column/field gathered by the collection of documents?
Subject: NotesDocumentCollection
GetAllDocumentsByKey returns a NotesDocumentCollection.
Use the “GetLastDocument” method of NotesDocumentCollection as described in the Help File.
Hope this helps point you in the right direction.
Phil
Subject: cheers
Thanks I’ll take a look.
Subject: You are probably going to need GetAllEntriesByKey.
It’ll return the entries in view order, while documents are generally returned in order of addition to the database.