private String buildCaseQuery()

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

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

    private String buildCaseQuery(final ReportRequest reportRequest, final String caseIdentifier){
        final List<DisplayableField> displayableFields = reportRequest.getDisplayableFields();
        final ArrayList<String> columns = new ArrayList<>();
        displayableFields.forEach(displayableField -> {
            final String column = this.caseColumnMapping.get(displayableField.getName());
            if (column != null) {
                columns.add(column);
            }
        });

        return "SELECT " + columns.stream().collect(Collectors.joining(", ")) + " " +
                "FROM bastet_cases cases " +
                "LEFT JOIN bastet_il_cases il_cases on cases.id = il_cases.case_id " +
                "WHERE il_cases.case_id ='" + caseIdentifier + "' ";
    }