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
Podcast: Play in new window | Download