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-request@lists.katipo.co.nz" <koha-request@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-request@lists.katipo.co.nz You can reach the person managing the list at koha-owner@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 <paul.a@aandc.org> To: Gay Richards <g.richards@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 +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> ------------------------------ Message: 2 Date: Tue, 27 Aug 2013 20:59:04 +0000 From: Gay Richards <g.richards@auckland.ac.nz> To: 'Paul' <paul.a@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: <AB44DEB8CF4F784F90EBCDBBD9B81737895D4978@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 | 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> ------------------------------ Message: 3 Date: Tue, 27 Aug 2013 19:19:35 -0400 From: Nicole Engard <nengard@gmail.com> To: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> Cc: Koha <Koha@lists.katipo.co.nz> Subject: Re: [Koha] JQuery Help Message-ID: <CAC0K6VG4+B_DWrmbD5jG8Yyx+=+A2vAgsuKd+EHf21oaSca28w@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Thank you! On Tue, Aug 27, 2013 at 9:43 AM, Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> wrote:
Nicole, one more line is needed to change sort1 on those two places, the last one
$(document).ready(function(){
$("#memberentry_library_management label[for='sort1']").html("Jurisdiction :"); $("#patron-library-details .label:contains('Sort field 1:')").html('Jurisdiction:'); $("fieldset.rows label[for='sort1']").html("Jurisdiction :");
});
Regards, Bernardo
-- Bernardo Gonzalez Kriegel bgkriegel@gmail.com
On Mon, Aug 26, 2013 at 5:10 PM, Nicole Engard <nengard@gmail.com> wrote:
I'd like to update this jquery
http://wiki.koha-community.org/wiki/JQuery_Library#Relabel_Sort1_on_Patron_R... to also change sort1 on these pages:
/cgi-bin/koha/tools/modborrowers.pl /cgi-bin/koha/tools/import_borrowers.pl
Any help would be appreciated. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------ Message: 4 Date: Tue, 27 Aug 2013 19:21:58 -0400 From: Nicole Engard <nengard@gmail.com> To: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> Cc: Koha <Koha@lists.katipo.co.nz> Subject: Re: [Koha] JQuery Help Message-ID: <CAC0K6VHOf4cHCvHw_GZ1QTsSfBzeP2yYPGqrgfAtDHOsN3G-Cw@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Bernardo, Sorry ... it didn't work on /cgi-bin/koha/tools/modborrowers.pl , but it did on the other. Nicole On Tue, Aug 27, 2013 at 7:19 PM, Nicole Engard <nengard@gmail.com> wrote:
Thank you!
On Tue, Aug 27, 2013 at 9:43 AM, Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> wrote:
Nicole, one more line is needed to change sort1 on those two places, the last one
$(document).ready(function(){
$("#memberentry_library_management label[for='sort1']").html("Jurisdiction :"); $("#patron-library-details .label:contains('Sort field 1:')").html('Jurisdiction:'); $("fieldset.rows label[for='sort1']").html("Jurisdiction :");
});
Regards, Bernardo
-- Bernardo Gonzalez Kriegel bgkriegel@gmail.com
On Mon, Aug 26, 2013 at 5:10 PM, Nicole Engard <nengard@gmail.com> wrote:
I'd like to update this jquery
http://wiki.koha-community.org/wiki/JQuery_Library#Relabel_Sort1_on_Patron_R... to also change sort1 on these pages:
/cgi-bin/koha/tools/modborrowers.pl /cgi-bin/koha/tools/import_borrowers.pl
Any help would be appreciated. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------ _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 94, Issue 50 ************************************