❌

Vue normale

Reçu avant avant-hier Lib Power Tech

Customize koha Accession Register (Koha SQL Reports Queries)

✇Lib Power Tech
Par :noreply@blogger.com (Lib Power Tech)
12 mars 2021 à 08:47

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

SELECT items.Barcode,biblioitems.biblionumber,items.itemcallnumber AS 'Call Number',biblio.Author,biblio.Title AS Titles,biblioitems.size As 'Bill No', biblioitems.Pages, biblioitems.Editionstatement AS Edition,biblio.Copyrightdate AS Year,items.Price,biblioitems.illus AS 'OPAC Price',biblioitems.publishercode AS Publisher,biblioitems.Place AS 'Place of Publication',biblio.unititle AS Subject,items.ccode AS Collection,items.location AS 'Department Wise', items.itype AS 'Book Status / Item type',biblioitems.itemtype AS Department,biblioitems.url AS OnlineURL,items.Dateaccessioned,biblioitems.ISBN,biblio.notes As ' General Notes/Remarks',biblio.Serial,items.Issues,items.Renewals
FROM items 
LEFT JOIN biblioitems ON (items.biblioitemumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblnio.biblionumber)
ORDER BY LPAD(items.barcode,40,' ') ASC

Run Report



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

✇Lib Power Tech
Par :noreply@blogger.com (Lib Power Tech)
6 mai 2020 à 09:11

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

❌