I have read the docs, looked at the tests but I can't quite grasp how to get the calculated columns eg Max, Sum, Count.
eg I have
<class-descriptor
class="com.sundayta.balloons.model.implementation.Items"
table="Items"
>
<field-descriptor
name="itemId"
column="ItemId"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
sequence-name="GEN_ItemId"
/>
<field-descriptor
name="rowVersion"
column="RowVersion"
jdbc-type="INTEGER"
locking="true"
/>
<field-descriptor
name="Name"
column="Name"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="value"
column="Value"
jdbc-type="NUMERIC"
/>
</class-descriptor>I want to be able to find the following
a) Max RowVersion value
b) A List of distinct Names with the number of instances of each name
c) The sum of all the value's for each distinct name
I think I want to be using a ReportQuery.getCollectionByCriteria. But what I don't understand is
1. The relationship between the ReportQuery.setColumns and the Items class
2. When I get a Collection back what it actually contains and how I work with that.
Sorry if this is a bit basic, but thanks for your help. -- 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]
