[Koha] SQL Reports on catalogue (list of books added/ entered date wise i.e today )

vikram zadgaonkar vikramczadgaonkar at gmail.com
Wed Sep 25 16:55:55 NZST 2019

You may use date parameter. see if following is useful for you:

SELECT  items.barcode AS Barcode, biblio.author AS Author, biblio.title AS
Title, items.itemcallnumber AS Shelflocation,biblio.datecreated AS
items.itype AS Type,
items.price AS Cost,
FROM  biblio_metadata
LEFT JOIN biblioitems on
LEFT JOIN items on (items.biblioitemnumber=biblioitems.biblioitemnumber)

LEFT JOIN biblio on (biblio_metadata.biblionumber=biblio.biblionumber)

WHERE biblio.datecreated BETWEEN <<Between Date (yyyy-mm-dd)|date>> AND
<<and (yyyy-mm-dd)|date>>  ORDER BY items.barcode ASC
Else you can use option Build report in koha.
Vikram Zadgaonkar

On Wed, Sep 25, 2019 at 9:40 AM Yatheesh lis <yatheeshb at gmail.com> wrote:

> hi
> I would like generate the daily report   list of books added / entered
>  on particular date / (single day)
> kindly suggest sql query
> --
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list