taskain7 commented on code in PR #2964:
URL: https://github.com/apache/fineract/pull/2964#discussion_r1100325567
##########
fineract-provider/src/main/java/org/apache/fineract/portfolio/loanaccount/domain/LoanRepository.java:
##########
@@ -83,7 +83,7 @@ public interface LoanRepository extends JpaRepository<Loan,
Long>, JpaSpecificat
String FIND_ID_BY_EXTERNAL_ID = "SELECT loan.id FROM Loan loan WHERE
loan.externalId = :externalId";
// should follow the logic of
`FIND_ALL_NON_CLOSED_LOANS_BY_LAST_CLOSED_BUSINESS_DATE` query
- String FIND_OLDEST_COB_PROCESSED_LOAN = "select loan.id,
loan.lastClosedBusinessDate from Loan loan where loan.lastClosedBusinessDate =
(select min(l.lastClosedBusinessDate) from Loan l where loan.loanStatus in
(100,200,300,303,304) and l"
+ String FIND_OLDEST_COB_PROCESSED_LOAN = "select loan.id,
loan.lastClosedBusinessDate from Loan loan where loan.lastClosedBusinessDate =
(select min(l.lastClosedBusinessDate) from Loan l where l.loanStatus in
(100,200,300,303,304) and l"
Review Comment:
that's correct.
fixed it.
--
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]
