2

Using the "Bookkeeping with extra fields" template, I noticed I was occasionally missing some transactions whenever I filtered on Transaction Date. I believe the issue is caused by the filter using only the date and not the time.

For example, if today is February 10 and I filter Transaction Date on "Yesterday", the WHERE clause looks like:

( financial_trxn.trxn_date >= '20190209') AND ( financial_trxn.trxn_date <= '20190209' )

Any transaction that isn't exactly at midnight is lost. Comparing to the Date Received filter, it uses date and time:

( contribution.receive_date >= '20190209000000') AND ( contribution.receive_date <= '20190209235959' )

Perhaps I'm misinterpreting the use of the filters. I can run the same query directly, but with the time included for Transaction Date, and it seems to return the correct results.

  • CiviCRM 5.10.0
  • PHP 7.2.13
  • MySQL 5.7.23
  • Wordpress 5.0.3

EDIT - originally this Q referenced ExtendedReports 3.5 but turns out it was a core report

Improve this question
5

1 Answer 1

Reset to default
1

The issue has been reported in https://lab.civicrm.org/dev/report/issues/7.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.