https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16703 Bug ID: 16703 Summary: Home > Reports > Circulation statistics showing no circulation Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: gmcharlt@gmail.com Reporter: barton@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org koha/reports/issues_stats.pl is giving incorrect results. Here are the parameters added: Period From: 01/01/2016 To : 06/07/2016 Type: Checkout group by: None Library: Takoma Park Maryland Library Home Library: Takoma Park Maryland Library Holding Library: Takoma Park Maryland Library The output is: Circulation statistics Filtered on: Period From 01/01/2016 Period To 06/07/2016 Library = TPML Home library = TPML Holding library = TPML Event issue / TOTAL TOTAL 0 Here are the actual circulation statistics: select count(*) from statistics where type = 'issue' and branch='TPML' and date(datetime) between '2016-01-01' and '2016-06-07'; +----------+ | count(*) | +----------+ | 33891 | +----------+ To re-create: 1/ Choose a koha instance that has circulation 2/ Go to Home > Reports > Circulation statistics 3/ Select the following: Period From: <Your start date> To : <Your end date> Type: Checkout group by: None Library: <BRANCH> Home Library: <BRANCH> Holding Library: <BRANCH> Cell Value: Count total items Output: To screen into the browser 4/ Click submit You will see Event issue / TOTAL TOTAL 0 5/ select count(*) from statistics where type = 'issue' and branch='BRANCH' and date(datetime) between '<Your start date>' and '<Your end date>' (Replace BRANCH and dates with values corresponding to the report above). Assuming that your date range contains checkouts, the output from issues_stats.pl is clearly incorrect. -- You are receiving this mail because: You are watching all bug changes.