Missing transaction ids on reports
How to reproduce
- Create
contributionA
oncontactA
without assigning any transaction_id. A record oncivicrm_contribution
is created withtransaction_id = NULL
- Modify
contributionA
to assign a transaction_id = aaaaaa. The record previously created oncivicrm_contribution
stills havetransaction_id = ǸULL
- Create
contributionB
oncontactA
with a transaction_id = bbbbbb - Visualize a Contribution Details report with column transaction_id enabled and filtering results for
contactA
- Note that transaction_id column for
contributionA
is empty instead of aaaaaa and transaction_id column forcontributionB
is bbbbbb
Same happens on Event Participants List report for event related contributions in which the transaction_id was edited a posteriori.