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 <[email protected]> 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 > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
