(fineract) branch develop updated: FINERACT-2054: BadSqlGrammar Error in Loans Awaiting Disbursal Summary Report

[adamsaghy]

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 557736585 FINERACT-2054: BadSqlGrammar Error in Loans Awaiting 
Disbursal Summary Report
557736585 is described below

commit 55773658582115d7f0a2e02ff2d7e07c21e4f80d
Author: Mariappan Sivakumar 
<148471944+mariappan-sivakumar-z...@users.noreply.github.com>
AuthorDate: Fri Feb 9 09:48:33 2024 +0530

    FINERACT-2054: BadSqlGrammar Error in Loans Awaiting Disbursal Summary 
Report
    
    This error is thrown because of Office/Branch( ounder.name) is not 
mentioned in the Group by clause
---
 .../src/main/resources/db/changelog/tenant/parts/0002_initial_data.xml  | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git 
a/fineract-provider/src/main/resources/db/changelog/tenant/parts/0002_initial_data.xml
 
b/fineract-provider/src/main/resources/db/changelog/tenant/parts/0002_initial_data.xml
index d30f543c6..69cb27587 100644
--- 
a/fineract-provider/src/main/resources/db/changelog/tenant/parts/0002_initial_data.xml
+++ 
b/fineract-provider/src/main/resources/db/changelog/tenant/parts/0002_initial_data.xml
@@ -12734,7 +12734,7 @@
             <column name="report_subtype"/>
             <column name="report_category" value="Loan"/>
             <column name="report_sql"
-                    value="SELECT &#13;&#10;concat(repeat(&quot;..&quot;,   
&#13;&#10;   ((LENGTH(ounder.`hierarchy`) - LENGTH(REPLACE(ounder.`hierarchy`, 
'.', '')) - 1))), ounder.`name`) as 
&quot;Office/Branch&quot;,&#13;&#10;pl.`name` as &quot;Product&quot;, 
&#13;&#10;ifnull(cur.display_symbol, l.currency_code) as Currency,  f.`name` as 
Fund,&#13;&#10;sum(l.principal_amount) as Principal&#13;&#10;from m_office o 
&#13;&#10;join m_office ounder on ounder.hierarchy like concat(o.hierarchy [...]
+                    value="SELECT &#13;&#10;concat(repeat(&quot;..&quot;,   
&#13;&#10;   ((LENGTH(ounder.`hierarchy`) - LENGTH(REPLACE(ounder.`hierarchy`, 
'.', '')) - 1))), ounder.`name`) as 
&quot;Office/Branch&quot;,&#13;&#10;pl.`name` as &quot;Product&quot;, 
&#13;&#10;ifnull(cur.display_symbol, l.currency_code) as Currency,  f.`name` as 
Fund,&#13;&#10;sum(l.principal_amount) as Principal&#13;&#10;from m_office o 
&#13;&#10;join m_office ounder on ounder.hierarchy like concat(o.hierarchy [...]
             <column name="description" value="Individual Client Report"/>
             <column name="core_report" valueBoolean="true"/>
             <column name="use_report" valueBoolean="true"/>