java - QueryDSL - Sum where a join is involed -
given following classes: class user { @onetomany set<transaction> transactions } class transaction { bigdecimal money; } i'm stumped how perform aggregate, functions don't appear available on following query: quser $user = quser.user; qtransaction $transaction = qtransaction.transaction; query().from($user) .innerjoint($user.transactions, $transaction) .where($user.eq(myuser)) // what? as bonus -- possible if money persisted joda money type, rather bigdecimal? (i'm using usertype's joda money support facilitate persistence) something should work quser $user = quser.user; qtransaction $transaction = qtransaction.transaction; query().from($user) .innerjoint($user.transactions, $transaction) .where($user.eq(myuser)) .singleresult($transaction.money.sum()); querydsl doesn't have (yet) direct support joda money, using joda money sum() method won't available directly.
