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 | i...@nzfvc.org.nz
-----Original Message-----
From: koha-boun...@lists.katipo.co.nz
[mailto:koha-boun...@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>
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha