ge-
From: Koha On Behalf Of Kerrie Stevens
Sent: Wednesday, 25 September 2019 10:46 AM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Help with a report query
Adding to this report from Carlos below, we have multiple campuses so I'd love
to be able to run the report for each campus. I've
UCIS COLLEGE
--
Message: 2
Date: Mon, 23 Sep 2019 21:17:25 -0700
From: Eric Phetteplace
To: Carlos Lopez
Cc: koha
Subject: Re: [Koha] Help with a report query
Message-ID:
Content-Type: text/plain; charset="UTF-8"
Hi Carlos,
Your report is actually very close to doi
Hi Carlos,
what I usually do for years is a free text entry: <> 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.
Hi Carlos,
Your report is actually very close to doing that already. Since you're
already limiting by year in your WHERE clause, you just need to change it
to accept a parameter instead of using YEAR(NOW()). So this should do want
you want:
SELECT monthname(datetime) month, type, count(datetime)
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
5 matches
Mail list logo