This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal



Feb 27, 2013, 3:16 AM
31 Posts

Categorized View with Totals

  • Category: Server Side JavaScript
  • Platform: Windows
  • Release: 8.5.3
  • Role: Developer
  • Tags: Repeat Control,Data Table,NotesViewNavigator
  • Replies: 1

Do you or can you use a NotesViewNavigator with its related classes with Repeat Controls or Data Tables? I want the category and totaling of the NotesViewNavigator but the iterating of a Repeat Control or Data Table. 
 
I am basically trying to reproduce a filtered view on a category in the first column (a particular user), then display the next three categorized columns and totals. This data is all contained within a view based on one form as the view selection. 
 
> User 
     > Year  |  $ < Year Total>
         > Quarter   |   $ <Quarter Total>
             > Period    |   $ <Period Total>
             > Period    |   $ <Period Total> 
 
I haven't been successful in finding a way to replicate this behavior and in this structure. Reading and testing the examples in the NotesViewNavigator examples using "While" loops or "For" loops returns the data in a long messy string. I want the look and feel of a repeat control or data table which I have used repeatedly in my applications - just unsure how to make them work here.
 
I hope I have made some sense and someone can offer some suggestions? 
 
Thanks, 
Kendra  
 
Mar 1, 2013, 2:19 AM
586 Posts
Re: Categorized View with Totals
 Kendra,
He way you want to handle this is with nested repeat controls. 
 
the the outer repeat  would just be the user name. Then inside that repeat make additional repeats as necessary using that username from the collection name variable to do whatever lookups you need to get that data.
 
i have a simple example of this on XPagescheatsheet.com.  There's a live demo and a downloadable db.  I'm sure this was featured in a notesin9 show or two but I don't remember which one it might be. 
 
give that a try 
 
dave 

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal