Adam Saghy created FINERACT-2742:
------------------------------------
Summary: Journal Entry Aggregation - update reader query to
default to null instead of ''
Key: FINERACT-2742
URL: https://issues.apache.org/jira/browse/FINERACT-2742
Project: Apache Fineract
Issue Type: Improvement
Affects Versions: 1.15.0
Reporter: Adam Saghy
Assignee: Adam Saghy
Fix For: 1.16.0
Currently, Journal entry aggregation reader job uses COALESCE((SELECT \s""" +
aggregateFunction + """ to build the aggregation query. Before these changes,
journal entry aggregation has been inserting data into the summary table with
originator_external_ids as null wherever it’s not available. This caused an
issue during report reconcilation whereby the reports used aggregated data and
duplicated the rows based on “null” originator ids (for old/existing data) and
‘' originator ids for new aggregation runs.
So we need to update the reader query to not default to '’.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
