[Koha] SQL Help - Daily (on Monthly basis) & Monthly (on Yearly basis) Transactions Counts (Circulation)

SATISH lis4satish at gmail.com
Mon Mar 6 19:33:11 NZDT 2017


Hi,

With Koha 16.5/Package Installation/ Ubuntu 14.04 Desktop /

Can you please help me to prepare the Circulation report (SQL), which
contain.
1* Daily and 2* Monthly Counts for Circulation.

1* Counts- Daily transactions/circulation report for a Month:
---------------------------------------------------------------
example: for the month of March 2017

Day | Issue | Renewals| Returns
01-03-2017   50       30 25
02-03-2017   40        25             12

so on...until last date of the month
---------------------------------------------------------------

2* counts -  Monthly transactions/circulation report for an Year:

example: for the year 2017

Month |  Issues | Renewals | Returns
January                55         45        50
February               50         45        35
so on .. until December
-----------------------------------------------------------------
As per 2* SQL, "Monthly circ in a date range"
in Koha SQL Library gives Issue/Renewals not Returns.


With Thanks
Satish MV
Librarian
Govt. Engineering College, Hassan
Karnataka
www.gechassan.ac.in
--


More information about the Koha mailing list