✕
Home » Blogs

Report on Patron vs Entry Count in Koha

×

Error message

  • Deprecated function: Return type of DatabaseStatementBase::execute($args = [], $options = []) should either be compatible with PDOStatement::execute(?array $params = null): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in require_once() (line 2244 of /home/eduvai/public_html/includes/database/database.inc).
  • Deprecated function: Return type of DatabaseStatementEmpty::current() should either be compatible with Iterator::current(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in require_once() (line 2346 of /home/eduvai/public_html/includes/database/database.inc).
  • Deprecated function: Return type of DatabaseStatementEmpty::next() should either be compatible with Iterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in require_once() (line 2346 of /home/eduvai/public_html/includes/database/database.inc).
  • Deprecated function: Return type of DatabaseStatementEmpty::key() should either be compatible with Iterator::key(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in require_once() (line 2346 of /home/eduvai/public_html/includes/database/database.inc).
  • Deprecated function: Return type of DatabaseStatementEmpty::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in require_once() (line 2346 of /home/eduvai/public_html/includes/database/database.inc).
  • Deprecated function: Return type of DatabaseStatementEmpty::rewind() should either be compatible with Iterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in require_once() (line 2346 of /home/eduvai/public_html/includes/database/database.inc).
Submitted by admin on Wed, 23 Oct, 2019 10:10 am

This report will output the surname, firstname, cardnumber, record count and item count columns.

Uses: Count the koha data entry operators total statistics. 

How to:

  1. Login to koha staff interface
  2. Go to reports
  3. find create > from sql (see the picture no. 2)
  4. Fill out the form using your own title

Run this report on koha: 

SELECT borrowers.firstname, borrowers.surname, borrowers.cardnumber, COUNT(DISTINCT(biblio.biblionumber)) as 'Records', COUNT(DISTINCT(items.barcode)) as 'Items' FROM `action_logs` LEFT JOIN biblioitems on action_logs.object = biblioitems.biblionumber LEFT JOIN items on items.biblionumber = biblioitems.biblionumber LEFT JOIN biblio on biblio.biblionumber = items.biblionumber LEFT JOIN creator_batches on creator_batches.item_number = action_logs.object LEFT JOIN borrowers on borrowers.borrowernumber = action_logs.user LEFT JOIN biblioimages on biblioimages.biblionumber = action_logs.object WHERE action_logs.module = 'CATALOGUING' AND action_logs.action = 'ADD' AND info LIKE 'biblio%' GROUP BY borrowers.cardnumber