[Koha] list of issues at a given point
Stephen Hedges
shedges at skemotah.com
Tue Dec 20 06:49:17 NZDT 2005
Priyanka Mishra said:
> Hi,
> I am not able to find the list of issues of items at any given point and
> also the transaction details for the specific period which is neede from
> the
> audit point of view.Could anyone please help me out.
I usually just use a MySQl query, something like:
SELECT itemtype, COUNT(itemtype) AS count FROM statistics WHERE
YEAR(datetime)=2005 AND MONTH(datetime)=11 AND branch='APL' AND
type='issue' GROUP BY itemtype;
If you know a little about MySQL, you can create just about any report you
want.
--
Stephen Hedges
Skemotah Solutions, USA
www.skemotah.com -- shedges at skemotah.com
More information about the Koha
mailing list