private String buildAccountQuery()

in service/src/main/java/org/apache/fineract/cn/reporting/service/internal/specification/CustomerListReportSpecification.java [292:307]


  private String buildAccountQuery(final ReportRequest reportRequest, final String customerIdentifier) {
    final List<DisplayableField> displayableFields = reportRequest.getDisplayableFields();
    final ArrayList<String> columns = new ArrayList<>();
    displayableFields.forEach(displayableField -> {
      final String column = this.accountColumnMapping.get(displayableField.getName());
      if (column != null) {
        columns.add(column);
      }
    });

    return "SELECT " + columns.stream().collect(Collectors.joining(", ")) + " " +
        "FROM thoth_accounts acc " +
            "LEFT JOIN maat_customers cst on acc.holders = cst.identifier " +
        "WHERE cst.identifier ='" + customerIdentifier + "' " +
        "ORDER BY acc.identifier";
  }