Did you see this:  https://www.ibm.com/developerworks/lotus/library/ls-The_Evaluate_statement/index.html  ?

Might help with the @DBLookup...

Might also try GetAllDocumentsByKey to get a DocumentCollection, then GetLastDocument to retrieve the last document from the collection.

Yes, as Mark says, GetAllDocumentsByKey will return the last doc in the collection. However -- this is the last document in natural order (increasing NoteIDs). Often this is the last doc created for the category -- but it's not sorted the way the view is.

If you are truly looking for the last doc *in the view category*, try GetAllEntriesByKey.

What's more, GetAll**ByKey() calls suffer from a longstanding problem introduced about R5.0.3. To avoid this problem, you *cannot* use subcategories in the view you're looking-up. Otherwise you may get the most-recent document and nothing else.

Cheers fellas, I'll take a look.

"Does anybody know how I can use this to return the last value in a specific column/field gathered by the collection of documents? "

Do you want the value from the last column for one, all, some, first, last, random doc?

If you need the value from all docs in the collection, then just loop through the collection and call the field for each doc.

You can use ViewEntries to get column values but I'm not sure that's any faster than looping a collection. If the collection is large, you probably want to do some time testing to see which runs faster. Speed will vary if you're running the code on the client or as a server agent.

If your collection is large, can you create a key that gives you smaller collections? Perhaps a hidden view that makes each doc unique (assuming you're wanting to get data from one and only one doc).