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.
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.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 [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
