[Koha-bugs] [Bug 7683] statistic wizard: cataloging

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7683

Koha Team AMU <koha.aixmarseille at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Failed QA

--- Comment #50 from Koha Team AMU <koha.aixmarseille at gmail.com> ---
I tested on a sandbox (langres) by comparing the results with sql reports.

The acquired date filter doesn't work. It seems like the end of the limit is
not used.

--> SQL report
SELECT homebranch, itemtype, COUNT(itemnumber)
FROM items JOIN biblioitems USING(biblionumber)
WHERE dateaccessioned BETWEEN "2013-01-01" AND "2013-12-31"
GROUP BY homebranch, itemtype
--> résultat
MAURES LIVR 1
MAURES REV 147

--> using statistics wizards
Row = itemtype
Column = home library
Acquired Date Filter From 01/01/2013 To 31/12/2013
--> résultats
itemtype / items.homebranch BDP MAURES TOTAL
CD 380 380
LAUD 6 6
LIVR 20 3783 3803
REV 862 862
SPECIAL 2 2
VHS 3 3
TOTAL 20 5036 5056

I tried the filter with "From 01/01/2012 To 31/12/2012", "From 01/01/2013 To
31/12/2013", "From 01/01/2014 To 31/01/2014". Each time the total is growing as
if only the start of the limit is used.

For that reason, I change status in "Failed QA".

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