Github user Ippezrobert commented on the issue:
https://github.com/apache/fineract/pull/380
@nazeer1100126 , am working on the changes you requested for FINERACT-241.
But i have a challenge of relating m_note table with either
m_savings_account_transaction or m_savings_account for getting this note to
show it in the UI. Any clue here?
It would be better to match each notes with its transactions so that we
know how each transaction has be narrated. So we must relate m_note table with
m_savings_account_transaction tr 'left join m_note mn on tr.id =
mn.savings_account_transaction_id' . But duplicates each transaction row in the
result-set.
This query would have worked but i realized savings_account_transaction_id
is not getting inserted into m_note when a transaction occurs.
select tr.id as transactionId, sa.account_no as Account,
tr.transaction_date as transactionDate, tr.amount as transactionAmount,
tr.running_balance_derived as runningBalance,
au.username as submittedByUsername,
mn.note as note
from m_savings_account sa
join m_savings_account_transaction tr on tr.savings_account_id = sa.id
left join m_appuser au on au.id=tr.appuser_id
left join m_note mn on tr.id = mn.savings_account_transaction_id
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
