Greetings all,

I have a component using Wonder's ExcelGenerator framework, which is based on 
another component which is also using batching display groups.  I have a button 
which is supposed to generate an excel document version of the displayGroup.  I 
also am adding a row at the bottom of the excel page which is supposed to give 
me a grand total of all the objects in the displayGroup, for that column.  This 
all works, assuming the user did not set any queryMatch dictionary values on 
the preceding search page.

My action to do this returns the following excelPage:

        WOComponent excelPage = pageWithName(MyExcelComponent.class.getName());
        
        excelPage.takeValueForKey(displayGroup().filteredObjects(), 
"arrayOfObjects");

        excelPage.takeValueForKey(minRefreshDate(), "minRefreshDate");
        
excelPage.takeValueForKey(displayGroup().allObjects().valueForKeyPath("@sum.myFieldValue"),
 "myFieldValueGrandTotal");
        ...



Unfortunately, where the user did a search using values from the queryMatch 
dictionary, the @sum seems to give the total of all objects in the displayGroup 
and not just the ones that match the queryMatch.  Apparently filteredObjects() 
is overridden to use allObjects() where the displayGroup is batching.  
Obviously, I don't need to batch the excel page, so I thought about setting the 
displayGroup isBatching = false; but there seems to be no such method.  So I 
thought I'd post this as a question for the list.

So in short (?) we have a search page, which qualifies the displayGroup based 
on some information the user has no control over (e.g. does this user have 
access to this data), and also has user entry fields which are used via 
queryMatch to further qualify the displayGroup.  The results in the web page 
are properly totaled pages, which the proper number of batches.  The excel page 
version is not supposed to batch (obviously), but rather display all the data 
in all batches in one excel file, with a total of all (subject to all the 
qualifiers and queryMatch values).  The total seems to be the totals all in the 
displayGroup, without considering the queryMatch values.  However, in the 
debugger, the displayGroup has the queryMatch values, and the qualifier has 
that as a limitation, yet does still return totals for all objects including 
those which do not match the query match.

Any ideas?  What am I missing/doing wrong?

Andrew
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to