private String buildAddressQuery()

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


  private String buildAddressQuery(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.addressColumnMapping.get(displayableField.getName());
      if (column != null) {
        columns.add(column);
      }
    });

    if (!columns.isEmpty()) {
      return "SELECT " + columns.stream().collect(Collectors.joining(", ")) + " " +
          "FROM maat_addresses adr " +
              "LEFT JOIN maat_customers cst on adr.id = cst.address_id " +
          "WHERE cst.identifier ='" + customerIdentifier + "' ";
    }
    return null;
  }