you'll have to use report queries to get calculated columns.
ReportQueryByCriteria query;
Criteria crit;
crit = new Criteria();
crit.addLike("name", "%er");
query = new ReportQueryByCriteria(Person.class, crit);
query.setColumns(new String[]{"firstname", "sum(test)" });
broker.getReportQueryIteratorByQuery(query);
this query returns an array of "rows" (an array of objects) where the first object contains the "firstname" and the second the sum.
report queries do not return full blown business objects. for further examples have a look at the testcases in QueryTest.
Many thanks that is very helpful. Most of the tests don't demonstrate how to look into the results.
Dave
-- David Warnock, Sundayta Ltd. http://www.sundayta.com iDocSys for Document Management. VisibleResults for Fundraising. Development and Hosting of Web Applications and Sites.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
