including barcode number and publisher i want can you send updated sql query On Wed, Sep 25, 2019 at 10:16 AM pandu rangaswamy <pandumlib@gmail.com> 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 <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

--

----------------------------------------------------------------------------

M. Panduranga Swamy

+91 9664631017

ORCID

------------------------------------------------------------------------------

-- Y.Yatheesh Babu