[Koha-devel] Koha 3.0 total number of books, cds, dvds, journals and others
Michael Hafen
mdhafen at tech.washk12.org
Mon Oct 5 23:19:06 CEST 2009
I don't mess with the reports, so I can't help with them. For this I
would run a few SQL commands. I'll write some here for you.
SELECT COUNT(barcode) FROM items WHERE barcode <> '' AND barcode IS NOT
NULL
SELECT categorycode,COUNT(barcode) FROM items WHERE barcode<> '' AND
barcode IS NOT NULL GROUP BY categorycode;
SELECT COUNT(biblionumber) FROM biblio
These will give you the total number of barcodes, the number of barcodes
per item category, and the total number of titles in the database.
Good luck.
On Tue, 2009-10-06 at 00:59 +0600, Zico wrote:
> Hi, If i want to see total number of inserted books,cds,dvds, journals
> and others which are inserted into my Koha 3.0 server, what i need to
> do? I went to:
>
> Reports --> Statistics Wizards --> Catalog
>
> But, nothing is showing but only 0. But, my inserted items are 5,000
> approximately. i want to know the exact figure.
>
> --
> Best,
> Zico
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-devel
--
Michael Hafen
Systems Analyst and Programmer
Washington County School District
Utah, USA
for Koha checkout
http://development.washk12.org/gitweb/
or
git://development.washk12.org/koha
More information about the Koha-devel
mailing list