Department wise, Collection wise and Item Type wise Number of Books in Your Library (Koha SQL Reports Queries)

Department wise, Itemtype  wise and Collection wise Number of Books.

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

Report-1

Department Wise Number of Books.

SELECT location AS 'Department',COUNT(barcode) AS Count FROM items WHERE barcode <> ''

  AND barcode IS NOT NULL GROUP BY location

Report-2

Item Type Wise Number of Books.

SELECT itype AS 'Department',COUNT(barcode) AS Count FROM items WHERE barcode <> ''  
  AND barcode IS NOT NULL GROUP BY itype

Report-3

Collection Wise Number of Books.

SELECT

    av.lib AS  "Collection ",

    COUNT( i.barcode ) AS  "Count"

FROM items i

LEFT JOIN authorised_values av ON ( av.authorised_value = i.ccode ) 

    AND av.category =  'CCODE'

WHERE i.ccode IS NOT NULL

GROUP BY i.ccode

Run Report