How to prepare the report on the number of titles in koha.

Lib Power Tech August 15, 2024

     This article shows how to prepare the report on the Number of Titles in koha.

Go to: Koha Home/ Reports / Create from SQL


Copy and paste the below SQL source code.

SELECT 

ROW_NUMBER() OVER (ORDER BY DATE(title), CONCAT(title, " ", author)) As 'Sl.No',  Title, Author,  GROUP_CONCAT(biblionumber SEPARATOR ', ') AS Biblionumbers

FROM biblio 
GROUP BY CONCAT(title) 
HAVING COUNT(CONCAT(title,"/",author))>0


Save.

Run Report.

Reference: https://wiki.koha-community.org/wiki/SQL_Reports_Library


Lib Power Tech

Posted by Lib Power Tech

This situation will change

Post a Comment

3 Comments

  1. Money makersMarch 1, 2023 at 9:53 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  2. AnonymousJuly 31, 2024 at 10:46 AM

    it worked. Thanks

    ReplyDelete
  3. Billy BowmanJuly 15, 2025 at 1:36 PM

    In Koha, go to the Reports module and use SELECT COUNT(*) FROM biblio; to get the total number of titles. This simple query helps you track your catalog efficiently with support from yuzu ea .

    ReplyDelete