http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7683
Koha Team AMU <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Failed QA --- Comment #50 from Koha Team AMU <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
