Sorry, I sent the
previous mail by mistake, it was not ready:
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"
----------------------------------------------------------------------------------------------------------------
In the interface, I am getting the findDebitSum Method which returns my EJB object. But I just need the Double result.
Thanks for your hints.
Klaus
