198 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
Domino server licensing entitlement for developers. POLL
Tue, May 9th 2017 3
Developers Entitlement Announced!! Joke of the month
Mon, May 8th 2017 5
Docker ! interesting concept
Mon, May 8th 2017 5
IBM champion ! What does that mean ?
Sat, Dec 17th 2016 3
MWLUG Recap and the future of Notes/Domino
Sat, Aug 20th 2016 5
Password Reset Tool
Thu, Mar 24th 2016 4
Office 365 for 10 $
Thu, Mar 17th 2016 2
Top 10
Buying IBM Verse is not that easy
Sat, Jan 30th 2016 5
MWLUG Recap and the future of Notes/Domino
Sat, Aug 20th 2016 5
Developers Entitlement Announced!! Joke of the month
Mon, May 8th 2017 5
Docker ! interesting concept
Mon, May 8th 2017 5
Single Page Application Wizard control from Patrick Kwinten
Mon, Jun 30th 2014 4
Password Reset Tool
Thu, Mar 24th 2016 4
Everyone is laughing at IBM Verse
Sat, Mar 14th 2015 3
IBM champion ! What does that mean ?
Sat, Dec 17th 2016 3
Domino server licensing entitlement for developers. POLL
Tue, May 9th 2017 3
h plus valves sa
Wed, Feb 4th 2015 2


Getting Total Value from View column
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
palmi    

Am Puzzled, So I looking to you guys , Here is what am trying to do.

Getting Total amount  from a flat view with one Column that keeps Total Sales of many documents.

Getting Total sale into a XPages form using computedField

I have tried this

var key = viewRow.getColumnValue(“Totalsale”);
var lookup = @DbLookup(@DbName(), “MyTotelSale”, key, 12);
return lookup

and from Notesin9 from my friend David. His solution is based on Key and its works like a charm where i use a KEY. but not in this case.

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];
}

Any idea how to get this value ?

 




---------------------
http://northrenlotusblog.wordpress.com/2014/07/13/getting-total-value-from-view-column/
Jul 13, 2014
1 hits



Recent Blog Posts
3
Domino server licensing entitlement for developers. POLL
Tue, May 9th 2017 5:36p   Palmi Lord
A
5
Developers Entitlement Announced!! Joke of the month
Mon, May 8th 2017 6:46p   Palmi Lord
A
5
Docker ! interesting concept
Mon, May 8th 2017 6:11p   Palmi Lord
A
3
IBM champion ! What does that mean ?
Sat, Dec 17th 2016 8:50a   Palmi Lord
A




Created and Maintained by Yancy Lent - About - Planet Lotus Blog - Advertising - Mobile Edition