fineract-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ippezrobert <...@git.apache.org>
Subject [GitHub] fineract issue #380: (FINERACT-241) Include "Add Note" to Savings Transactio...
Date Mon, 31 Jul 2017 06:04:04 GMT
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 infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

Mime
View raw message