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

[Gay Richards]

Paul
Thank you. My novice SQL efforts hadn't quite figured that out. 

Regards, 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: Paul [mailto:paul.a at aandc.org] 
Sent: Wednesday, 28 August 2013 8:37 a.m.
To: Gay Richards; koha at lists.katipo.co.nz
Subject: RE: [Koha] Query for report on items catalogue in a date.

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.biblionum
>ber,'\">',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>