[Xdoclet-user] Aggregats in QL

[kkaal]

Hi,

 

I tried hard to find the answer, how to formulate a finder-method with an aggregat in QL. I tried the following:

 

* @ejb.finder
* signature = "java.lang.Double findDebitSum( java.lang.Integer periodid, java.lang.Long simid, java.lang.String debitacc )"
* unchecked = "true"
* query = "SELECT sum(a.amount) from jrnl a where a.periodid = ?1 and a.simid = ?2 and a.debitacc = ?3"