| Summary: | Home > Reports > Circulation statistics showing no circulation | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Barton Chittenden <barton> |
| Component: | Reports | Assignee: | Tomás Cohen Arazi (tcohen) <tomascohen> |
| Status: | NEW --- | QA Contact: | Testopia <testopia> |
| Severity: | normal | ||
| Priority: | P5 - low | CC: | bibliwho, m.de.rooy, tomascohen |
| Version: | Main | ||
| Hardware: | All | ||
| OS: | All | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | Patch complexity: | --- |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: | ||
| Circulation function: | |||
Tomas, you are assignee here. Can you confirm if this problem can be reproduced on current master/main? |
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.