This is an automated email from the ASF dual-hosted git repository.
adamsaghy 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 afd262cfb FINERACT-2035: Client Trend For Day Scale is not work Due to
BadSqlGrammar Error
afd262cfb is described below
commit afd262cfb62a1e5e9426fab66e44dddbc367b20c
Author: Mariappan Sivakumar
<[email protected]>
AuthorDate: Fri Feb 9 09:19:45 2024 +0530
FINERACT-2035: Client Trend For Day Scale is not work Due to BadSqlGrammar
Error
---
.../db/changelog/tenant/parts/0087_update_dashboard_table_reports.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git
a/fineract-provider/src/main/resources/db/changelog/tenant/parts/0087_update_dashboard_table_reports.xml
b/fineract-provider/src/main/resources/db/changelog/tenant/parts/0087_update_dashboard_table_reports.xml
index 447bec969..655cfac35 100644
---
a/fineract-provider/src/main/resources/db/changelog/tenant/parts/0087_update_dashboard_table_reports.xml
+++
b/fineract-provider/src/main/resources/db/changelog/tenant/parts/0087_update_dashboard_table_reports.xml
@@ -75,7 +75,7 @@
FROM m_office o LEFT JOIN m_client cl on o.id = cl.office_id
LEFT JOIN m_loan ln on cl.id = ln.client_id
WHERE o.hierarchy like concat((select ino.hierarchy from m_office
ino where ino.id = ${officeId}),'%' )
- AND (ln.disbursedon_date BETWEEN DATE_SUB(CURDATE(), INTERVAL
12 DAY) AND DATE(NOW()- INTERVAL '1 DAY'))
+ AND (ln.disbursedon_date BETWEEN DATE_SUB(CURDATE(), INTERVAL
12 DAY) AND DATE(NOW()- INTERVAL 1 DAY))
GROUP BY days
"/>
<where>id='152' AND report_name = 'LoanTrendsByDay'</where>
