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";
}