[Koha] SQL Reports on catalogue (list of books added/ entered date wise i.e today )

[Yatheesh lis]

  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 at 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 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
>
>
>
> --
>
> ----------------------------------------------------------------------------
>
> M. Panduranga Swamy
>
> +91 9664631017
>
> ORCID
>
> ------------------------------------------------------------------------------



-- 

Y.Yatheesh Babu