Mk9894 commented on code in PR #3158:
URL: https://github.com/apache/fineract/pull/3158#discussion_r1192227372


##########
fineract-provider/src/main/java/org/apache/fineract/portfolio/savings/service/SavingsAccountReadPlatformServiceImpl.java:
##########
@@ -1267,6 +1270,99 @@ public Collection<SavingsAccountTransactionData> 
retrieveAllTransactions(final L
         return this.jdbcTemplate.query(sql, this.transactionsMapper, new 
Object[] { savingsId, depositAccountType.getValue() }); // NOSONAR
     }
 
+    @Override
+    public Page<SavingsAccountTransactionData> retrieveAllTransactions(final 
Long savingsId, DepositAccountType depositAccountType,
+            SearchParameters searchParameters, LocalDate fromDate, LocalDate 
toDate,
+            @DecimalMin(value = "0", message = "must be greater than or equal 
to 0") BigDecimal fromAmount,
+            @DecimalMin(value = "0", message = "must be greater than or equal 
to 0") BigDecimal toAmount, String transactionType) {
+
+        final StringBuilder sqlBuilder = new StringBuilder(200);

Review Comment:
   @galovics Using JPQL seems like a potential option, however, I came across a 
challenge where I need to join an unrelated entity (AccountTransferTransaction) 
to retrieve account transfer information, which as far as I'm aware is not 
feasible with JPQL. Would you happen to have any suggestions or alternative 
solutions to this issue?



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to