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 | [email protected] -----Original Message----- From: Paul [mailto:[email protected]] Sent: Wednesday, 28 August 2013 8:37 a.m. To: Gay Richards; [email protected] 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 | [email protected] > >-----Original Message----- >From: [email protected] >[mailto:[email protected]] On Behalf Of Paul >Sent: Wednesday, 28 August 2013 2:26 a.m. >To: [email protected] >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 [email protected] >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> _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
