Author: echatellier Date: 2012-02-22 10:56:52 +0100 (Wed, 22 Feb 2012) New Revision: 3336 Url: http://chorem.org/repositories/revision/lima/3336 Log: Fix sub entries sum query Modified: trunk/lima-business/src/main/java/org/chorem/lima/business/ejb/FinancialTransactionServiceImpl.java Modified: trunk/lima-business/src/main/java/org/chorem/lima/business/ejb/FinancialTransactionServiceImpl.java =================================================================== --- trunk/lima-business/src/main/java/org/chorem/lima/business/ejb/FinancialTransactionServiceImpl.java 2012-02-21 15:56:10 UTC (rev 3335) +++ trunk/lima-business/src/main/java/org/chorem/lima/business/ejb/FinancialTransactionServiceImpl.java 2012-02-22 09:56:52 UTC (rev 3336) @@ -317,7 +317,8 @@ TopiaQuery query = financialTransactionDAO.createQuery("T"); query.addFrom(FiscalPeriod.class, "F") .addLeftJoin("T." + FinancialTransaction.PROPERTY_ENTRY, "E", false) - .addWhere("T.amountCredit = T.amountDebit") + .addWhere("(select sum(amount) from " + Entry.class.getName() + " where debit = false and financialTransaction = T) <> " + + "(select sum(amount) from " + Entry.class.getName() + " where debit = true and financialTransaction = T)") .addNotNull("E.account") .addNotNull("T.entryBook") .addInElements("T.financialPeriod", "F.financialPeriod")