private String buildDepositAccountQuery()

in service/src/main/java/org/apache/fineract/cn/reporting/service/internal/specification/DepositListReportSpecification.java [341:356]

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

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

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