Criteria API

Konstantin · **Joined:** Sun Jun 25, 2006 12:27 pm **Posts:** 5

Sorry, for my, may be newbie, question.

How can i get this select by Criteria API?

SELECT sum(p.sum*c.percent) FROM PAYMENT p, Commission c WHERE p.id = c.payment_id

Or this select can't be implemented by Criteria?

jbosseur · **Posted:** Thu Sep 28, 2006 7:43 am

Hi ,

I think it should be possible using projections take a look at
chapter 15.7. Projections, aggregation and grouping

Good luck

Konstantin · **Joined:** Sun Jun 25, 2006 12:27 pm **Posts:** 5

Yes now i can fetch p.sum and c.percent fields values. But how can i fetch p.sum*c.percent or sum(p.sum*c.percent).

How can i multiply p.sum and c.percent ?