private String buildDepositProductQuery()

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

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

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

        return "SELECT DISTINCT " + columns.stream().collect(Collectors.joining(", ")) + " " +
                "FROM shed_product_definitions pd " +
                "LEFT JOIN shed_product_instances pi on pd.id = pi.product_definition_id " +
                "WHERE pi.product_definition_id ='" + productIdentifier + "' ";
    }