including barcode number and publisher i want can you send updated sql query
On Wed, Sep 25, 2019 at 10:16 AM pandu rangaswamy <[email protected]> wrote: > > Sir, > > You can use the below SQL report, the result shows last 30 days added items. > > SELECT items.dateaccessioned,items.itemcallnumber,biblio.title,biblio.author > FROM items > LEFT JOIN biblioitems ON > (items.biblioitemnumber=biblioitems.biblioitemnumber) > LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) > WHERE items.homebranch=<<Home branch|branches>> AND > DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= items.dateaccessioned > ORDER BY biblio.title ASC > > 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 > > > > -- > > ---------------------------------------------------------------------------- > > M. Panduranga Swamy > > +91 9664631017 > > ORCID > > ------------------------------------------------------------------------------ -- Y.Yatheesh Babu _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
