[fineract] branch develop updated: [FINERACT-1678] fix get odlest cob closed loan query

[taskain]

This is an automated email from the ASF dual-hosted git repository.

taskain pushed a commit to branch develop
in repository https://gitbox.apache.org/repos/asf/fineract.git


The following commit(s) were added to refs/heads/develop by this push:
     new 70dd1582b [FINERACT-1678] fix get odlest cob closed loan query
70dd1582b is described below

commit 70dd1582bc6e10b0aa09788a2fc44c80ea162564
Author: taskain7 <task...@gmail.com>
AuthorDate: Wed Feb 8 16:34:52 2023 +0100

    [FINERACT-1678] fix get odlest cob closed loan query
---
 .../apache/fineract/portfolio/loanaccount/domain/LoanRepository.java  | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git 
a/fineract-provider/src/main/java/org/apache/fineract/portfolio/loanaccount/domain/LoanRepository.java
 
b/fineract-provider/src/main/java/org/apache/fineract/portfolio/loanaccount/domain/LoanRepository.java
index 4d20391d3..691550356 100644
--- 
a/fineract-provider/src/main/java/org/apache/fineract/portfolio/loanaccount/domain/LoanRepository.java
+++ 
b/fineract-provider/src/main/java/org/apache/fineract/portfolio/loanaccount/domain/LoanRepository.java
@@ -83,8 +83,8 @@ 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"
-            + ".lastClosedBusinessDate <> " + ":cobBusinessDate)";
+    String FIND_OLDEST_COB_PROCESSED_LOAN = "select loan.id, 
loan.lastClosedBusinessDate from Loan loan where loan.loanStatus in 
(100,200,300,303,304) and loan.lastClosedBusinessDate = (select 
min(l.lastClosedBusinessDate) from Loan l where l"
+            + ".loanStatus in (100,200,300,303,304) and 
l.lastClosedBusinessDate <> :cobBusinessDate)";
 
     String FIND_ALL_NON_CLOSED_LOANS_BEHIND_BY_LOAN_IDS = "select loan.id, 
loan.lastClosedBusinessDate from Loan loan where loan.id IN :loanIds and 
loan.loanStatus in (100,200,300,303,304) and (loan.lastClosedBusinessDate <> 
:cobBusinessDate or "
             + "loan.lastClosedBusinessDate is null)";