[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