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: "[email protected]" <[email protected]> To: [email protected] Sent: Wednesday, August 28, 2013 1:00 AM Subject: Koha Digest, Vol 94, Issue 50 Send Koha mailing list submissions to [email protected] 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 [email protected] You can reach the person managing the list at [email protected] 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 <[email protected]> To: Gay Richards <[email protected]>, <[email protected]> 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 | [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 --- 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 <[email protected]> To: 'Paul' <[email protected]>, "[email protected]" <[email protected]> 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 | [email protected] -----Original Message----- From: Paul [mailto:[email protected]] Sent: Wednesday, 28 August 2013 8:37 a.m. To: Gay Richards; [email protected] 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 | [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.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 [email protected] >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 <[email protected]> To: Bernardo Gonzalez Kriegel <[email protected]> Cc: Koha <[email protected]> Subject: Re: [Koha] JQuery Help Message-ID: <CAC0K6VG4+B_DWrmbD5jG8Yyx+=+a2vagsukd+ehf21oasca...@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Thank you! On Tue, Aug 27, 2013 at 9:43 AM, Bernardo Gonzalez Kriegel <[email protected]> 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 > [email protected] > > > On Mon, Aug 26, 2013 at 5:10 PM, Nicole Engard <[email protected]> wrote: >> >> I'd like to update this jquery >> >> http://wiki.koha-community.org/wiki/JQuery_Library#Relabel_Sort1_on_Patron_Record >> 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 >> [email protected] >> http://lists.katipo.co.nz/mailman/listinfo/koha > > ------------------------------ Message: 4 Date: Tue, 27 Aug 2013 19:21:58 -0400 From: Nicole Engard <[email protected]> To: Bernardo Gonzalez Kriegel <[email protected]> Cc: Koha <[email protected]> Subject: Re: [Koha] JQuery Help Message-ID: <cac0k6vhof4chcvhw_gz1qtssfbzep2yypgqrgfatdhosn3g...@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 <[email protected]> wrote: > Thank you! > > On Tue, Aug 27, 2013 at 9:43 AM, Bernardo Gonzalez Kriegel > <[email protected]> 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 >> [email protected] >> >> >> On Mon, Aug 26, 2013 at 5:10 PM, Nicole Engard <[email protected]> wrote: >>> >>> I'd like to update this jquery >>> >>> http://wiki.koha-community.org/wiki/JQuery_Library#Relabel_Sort1_on_Patron_Record >>> 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 >>> [email protected] >>> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> ------------------------------ _______________________________________________ Koha mailing list [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 94, Issue 50 ************************************ _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
