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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha