[Koha] Query for report on items catalogue in a date.

[Paul]

At 08:17 PM 8/27/2013 +0000, Gay Richards wrote:
>Paul
>This is great. I was looking for this too. Unfortunately the html doesn't 
>seem to work when downloaded to csv but I guess I could remove that.

Without the html, it is a little shorter:

SELECT biblio.title AS Title, biblio.author AS Author,
items.barcode AS Barcode
FROM items
LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
WHERE
DATE(items.dateaccessioned) BETWEEN <<Accessioned BETWEEN (yyyy-mm-dd)>> 
AND <<and (yyyy-mm-dd)>>

Best - Paul


>Thanks, Gay
>
>Gay Richards
>Information Specialist
>New Zealand Family Violence Clearinghouse
>Tâmaki Innovation Campus
>The University of Auckland
>Ph: (09) 923 4640
>
>
>    09 923 4640 | www.nzfvc.org.nz | info at nzfvc.org.nz
>
>-----Original Message-----
>From: koha-bounces at lists.katipo.co.nz 
>[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Paul
>Sent: Wednesday, 28 August 2013 2:26 a.m.
>To: koha at lists.katipo.co.nz
>Subject: Re: [Koha] Query for report on items catalogue in a date.
>
>At 04:41 AM 8/27/2013 -0700, Akin Adigun \(Akinomatics\) wrote:
> >I want the title, author, barcode for all items catalogue in a date or
> >range of date
>
>SELECT CONCAT('<a
>href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',items.biblionumber,'\">',biblio.title,'</a>')
>AS Title, biblio.author AS Author,
>items.barcode AS Barcode
>FROM items
>LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
>WHERE
>DATE(items.dateaccessioned) BETWEEN <<Accessioned BETWEEN (yyyy-mm-dd)>> 
>AND <<and (yyyy-mm-dd)>>;
>
>Best - Paul
>
>---
>Maritime heritage and history, preservation and conservation, research and 
>education through the written word and the arts.
><http://NavalMarineArchive.com> and <http://UltraMarine.ca>
>
>_______________________________________________
>Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz 
>http://lists.katipo.co.nz/mailman/listinfo/koha

---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>