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@nzfvc.org.nz
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Paul Sent: Wednesday, 28 August 2013 2:26 a.m. To: koha@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@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>
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@nzfvc.org.nz -----Original Message----- From: Paul [mailto:paul.a@aandc.org] Sent: Wednesday, 28 August 2013 8:37 a.m. To: Gay Richards; koha@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@nzfvc.org.nz
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Paul Sent: Wednesday, 28 August 2013 2:26 a.m. To: koha@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@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>
participants (2)
-
Gay Richards -
Paul