Hello,I have a view with multiple documents with a column with dollar amounts that is categorized.
I am attempting to get a document collection of based on a category and from that collection get the first 25 documents sorted by highest dollar amount to lowest.
Is this possible?
Subject: Doc Collection
create a view where the first column is the catogory field (Sorted)using Lotus script access the view and use GetAllDocumentsByKey(“Category”,true)
Look in Notes designer help
Plenty of examples
Subject: RE: Doc Collection
Hello,I have that already. I am attempting to do an analysis report. I have view that has a sorted column with vendor.business.period for my billing data. I prompt the user for these three values and do a getalldocumentsbykey(vendor & “.” & business & “.” & period,true) to get all matching values. This is working perfect. I am attempting to take this data and either sort the collection or build a second collection that has these matching documents sorted largest to smallest based on my total field in these documents.
Subject: RE: Doc Collection
Hello Stephen,
see the NotesViewEntryCollection from the designerhelp.
From this collection You can retrieve the docs in the SAME ORDER as they appear in Your view.
axel