private String buildLoanAccountQuery()

in service/src/main/java/org/apache/fineract/cn/reporting/service/internal/specification/LoanListReportSpecification.java [339:354]

• 15 lines of code
• 2 McCabe index (conditional complexity)

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

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