[Koha-bugs] [Bug 27442] New: Circulation Module Report "Overdues" does not accurately show overdues by date

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27442

            Bug ID: 27442
           Summary: Circulation Module Report "Overdues" does not
                    accurately show overdues by date
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Reports
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: kelly at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org

I believe the SQL is wrong in the hardcoded report "Overdue" under the
Circulation Module.  When a due date range is added when running the report, it
is not showing the items that are overdue for a particular date, a library will
need to run a range of 2 days to find out the day's overdue.

Steps to Recreate:
1. Run Overdue report
2. Use the filter on the left to enter the date due to range of 10/12- 10/12.
3. No results are found with the actual date due to 10/12

4 Run the same report using the filter set at 10/12 - 10/13.
5 Koha will provide items that are due on 10/12.

The SQL is looking at date_due rather than date(date_due) which is not giving
accurate results.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.