Hello all,
I think this might be a bug in the because I notice the date set for an item in
acquisition is on the dateaccessioned in items table (items.dateaccessioned)
and also if the cataloguer select the date while cataloguing the date is also
on dateaccessioned (items.dateaccessioned), so using this field for the 2
reports i.e. items acquired per date and also items catalogue per date is
making one of the report right while the other wrong.
Pls, where do i report this bug?
From: koha-requ...@lists.katipo.co.nz koha-requ...@lists.katipo.co.nz
To: koha@lists.katipo.co.nz
Sent: Wednesday, August 28, 2013 1:00 AM
Subject: Koha Digest, Vol 94, Issue 50
Send Koha mailing list submissions to
koha@lists.katipo.co.nz
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.katipo.co.nz/mailman/listinfo/koha
or, via email, send a message with subject or body 'help' to
koha-requ...@lists.katipo.co.nz
You can reach the person managing the list at
koha-ow...@lists.katipo.co.nz
When replying, please edit your Subject line so it is more specific
than Re: Contents of Koha digest...
Today's Topics:
1. Re: Query for report on items catalogue in a date. (Paul)
2. Re: Query for report on items catalogue in a date. (Gay Richards)
3. Re: JQuery Help (Nicole Engard)
4. Re: JQuery Help (Nicole Engard)
--
Message: 1
Date: Tue, 27 Aug 2013 16:37:19 -0400
From: Paul pau...@aandc.org
To: Gay Richards g.richa...@auckland.ac.nz,
koha@lists.katipo.co.nz
Subject: Re: [Koha] Query for report on items catalogue in a date.
Message-ID: 5.2.1.1.2.20130827163157.05b45e88@localhost
Content-Type: text/plain; charset=iso-8859-1; format=flowed
At 08:17 PM 8/27/2013 +, 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 (-mm-dd)
AND and (-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 (-mm-dd)
AND and (-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
--
Message: 2
Date: Tue, 27 Aug 2013 20:59:04 +
From: Gay Richards g.richa...@auckland.ac.nz
To: 'Paul' pau...@aandc.org, koha@lists.katipo.co.nz
koha@lists.katipo.co.nz
Subject: Re: [Koha] Query for report on items catalogue in a date.
Message-ID:
ab44deb8cf4f784f90ebcdbbd9b81737895d4...@uxcn10-5.uoa.auckland.ac.nz
Content-Type: text/plain; charset=utf-8
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 | i...@nzfvc.org.nz
-Original Message-
From: Paul [mailto:pau...@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 +, 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: