taskain7 commented on code in PR #3112:
URL: https://github.com/apache/fineract/pull/3112#discussion_r1163877559
##########
fineract-provider/src/main/java/org/apache/fineract/portfolio/loanaccount/domain/LoanRepository.java:
##########
@@ -74,7 +75,8 @@ public interface LoanRepository extends JpaRepository<Loan,
Long>, JpaSpecificat
String FIND_ALL_NON_CLOSED = "select loan.id from Loan loan where
loan.loanStatus in (100,200,300,303,304)";
- String FIND_ALL_NON_CLOSED_LOANS_BY_LAST_CLOSED_BUSINESS_DATE = "select
loan.id from Loan loan where loan.loanStatus in (100,200,300,303,304) and
(:businessDate = loan.lastClosedBusinessDate or loan.lastClosedBusinessDate is
NULL)";
+ String FIND_MIN_AND_MAX_NON_CLOSED_LOAN_IDS_BY_LAST_CLOSED_BUSINESS_DATE =
"select new org.apache.fineract.cob.data.LoanCOBMinANdMaxLoanId(min(loan.id),
max(loan.id)) from Loan loan where loan.loanStatus in (100,200,300,303,304) "
+ + "and (:businessDate = loan" + ".lastClosedBusinessDate or
loan.lastClosedBusinessDate is" + " NULL)";
Review Comment:
fixed
--
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]
