Easy Query?

hyperfoo · **Joined:** Wed Oct 31, 2007 6:17 am **Posts:** 2

Hi list,

I need to realize the following query using criterias and expressions:

SELECT columnA, intColumnB, intColumnC, intColumnD FROM table1 WHERE inColumnB>(intColumnC+intColumnD).

Right now I have no ideai how to do the WHERE CLAUSE. Does anybody have a hint how to do this?

regards,

hyperfoo

sethrohit1977 · **Joined:** Mon Jan 22, 2007 10:32 am **Posts:** 101

Add a formula property in you mapping like

<property name="sumCD" formula="intColumnC+intColumnD"/>

and add the restriction like

criteria.add(Restrictions.gtProperty("intColumnB", "sumCD"));

HTH