http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7683 Koha Team AMU <koha.aixmarseille@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Failed QA --- Comment #50 from Koha Team AMU <koha.aixmarseille@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.