Circulation daily total transaction count (Koha SQL Reports Queries)

 Circulation Daily Transaction Count.
  • Crete the New SQL Report
  • Copy and Paste  following lines in the SQL report. Save and close.

SELECT type AS 'Transaction Type', Count(datetime) AS Count FROM statistics
WHERE date(datetime) BETWEEN << FROM |date>> AND <<TO |date>>
GROUP BY type
ORDER BY type ASC
Run Report



Post a Comment

2 Comments