in service/src/main/java/org/apache/fineract/cn/reporting/service/internal/specification/BalanceSheetReportSpecification.java [320:340]
private String buildLiabilityQuery(final ReportRequest reportRequest) {
final StringBuilder query = new StringBuilder("SELECT ");
final List<DisplayableField> displayableFields = reportRequest.getDisplayableFields();
final ArrayList<String> columns = new ArrayList<>();
displayableFields.forEach(displayableField -> {
final String column = this.accountingColumnMapping.get(displayableField.getName());
if (column != null) {
columns.add(column);
}
});
query.append(columns.stream().collect(Collectors.joining(", ")))
.append(" FROM ")
.append("thoth_accounts acc ")
.append("WHERE acc.a_type = 'LIABILITY' ");
query.append(" ORDER BY acc.identifier");
return query.toString();
}