get the sum in collection ???

ericmacau · **Joined:** Tue Nov 04, 2003 12:37 pm **Posts:** 57

Hello,

how can query the sum of a Set ??

For example?

Code:

class Man {

   public Set getCars() {
      return cars;
   }
}

class Car {

   public double getPrice() {
      return price;
   }
}

how can I get the sum(cars.price) for the Man ???

Eric

drj · **Posted:** Fri Dec 19, 2003 8:37 am

Code:

Double result = (Double)sess.createQuery(
    "select sum(car.price) from Man m " +
    "join m.cars car where .....").uniqueResult();

micho2001 · **Posted:** Fri Dec 19, 2003 10:46 am

another idea : have you had a look at the formula property?

Not sure myself if it would work... but if it does, drop a line! ;-)