Notes In 9 – 019 – Xpages: Getting Column Totals From a View

Notes In 9 Podcast Training XPages

It’s been a little while. I’m glad to be back and look forward to getting some more shows out in the next several weeks. Lots of ideas in the “queue”. :-)

This show starts out with some announcements and details of some Free and Paid training options for XPages that are available in August.

For the technical portion of the show, I give a demo on how to use Server Side JavaScript (SSJS) to retrieve a categorized column total and put it on an XPage.

The code for the main example is:

var cView:NotesView = database.getView(“vOrders”);
var nav:NotesViewNavigator = cView.createViewNav();

// Since you can’t do ‘getCategory’ – find the first doc and backup 1
var entry:NotesViewEntry = cView.getEntryByKey(sessionScope.get(“key”));
entry = nav.getPrev(entry);
if (entry == null) {
// Nothing to Do
}
else {
return entry.getColumnValues()[2];
}

Links:
IamLUG
MWLug
Tack It On