Hi Carlos, what I usually do for years is a free text entry: <<year (YYYY)>> or similar. So you could just switch out YEAR(NOW()) for that in your query below. We always try to use the statistics tables where possible as it's usually faster than having to work with than a union of issues and old_issues. Hope this helps, Katrin On 24.09.19 02:51, Carlos Lopez wrote:
Hi folks
I have the following report query: ---- SELECT monthname(datetime) month, type, count(datetime) as count from statistics where YEAR(datetime) = YEAR(NOW()) and type in ('issue', 'renew') GROUP BY month, type ORDER BY month(datetime) ----
This works well but I've been asked to provide a mechanism to select the year to run this for (I would guess similar to the construct " DATE (b.dateexpiry) BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>", except selecting only years)
Is it possible to do this? And if so, how?
With kind regards from the Dalton McCaughey Library Team
Carlos Lopez
Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340 8888 ext.1 | library@dml.vic.edu.au | library.dmlibrary.org.au
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha