How to pick the 2 rows of a view with the lowest total?

HCL Domino Domino Forum
1

Hi all,

I have a view with all the commands of a user ordered by date. What I’d like to do is, for each date, to pick the two commands with the lowest total to build my view statistics. Anyone has an idea on how to go through some elements of a view and pick only the good number of row for each date ?

Frank

2

Subject: How to pick the 2 rows of a view with the lowest total ?

Is the total a field on your documents (as opposed to the view calculating the total)? If so, you probably want to look at using the NotesViewEntryCollection. That, using a view that’s sorted by date and total, will allow you to loop through all documents.