[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
DateCreated,
items.itype AS Type,
items.price AS Cost,
FROM  biblio_metadata
LEFT JOIN biblioitems on
(biblio_metadata.biblionumber=biblioitems.biblionumber)
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