[Koha-bugs] [Bug 16703] New: Home > Reports > Circulation statistics showing no circulation
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Jun 9 18:11:37 CEST 2016
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 at gmail.com
Reporter: barton at bywatersolutions.com
QA Contact: testopia at 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.
More information about the Koha-bugs
mailing list