column = " lt.loantypeid,lt.loantype, SUM(ld.LoanDr) as dr, SUM(ld.LoanCr) as cr, SUM(ld.LoanDr-ld.LoanCr) as balance "; $bQuery = "SELECT " + column + " from loandetail ld inner join loantype lt on( lt.loantypeid = ld.loantypeid) " + " where ld.memberid = ? And ld.Centerid =? And ld.officeid= ? " + " group by lt.loantypeid,lt.loantype " + " order by lt.loantypeid "; nparameters = new HashMap(); nparameters.put(1, $memberid); nparameters.put(2, $centerid); nparameters.put(3, $branchid); List loans = nqe.ExecuteNativeSelectQuery($bQuery, nparameters, em); columns = this.nqe.getColumnsArray(column); columnType = new Integer[]{Types.INTEGER, Types.VARCHAR, Types.DOUBLE, Types.DOUBLE, Types.DOUBLE}; JsonArray LoanDetail = null; if (loans != null && loans.size() > 0) { LoanDetail = rg.getJsonArrayFromDatabase(loans, columns, columnType); }