Re: [Koha] My next adventure

Hi all, I don't understand why everybody is saying "good luck" and "congratulations". Are you all so happy to see Nicole leaving ? I'm so sad that I wish Nicole an epic fail. May an asteroid fall on your moving truck, may you have a massive allergy to Ralleigh NC trees pollen, may you face an

Re: [Koha] Managing new authority headings

Hi We have this report that looks for 'unauthorized' 650s in a time range. SELECT biblionumber, itemtype, ExtractValue(marcxml, '//datafield[@tag="650"]/subfield[@code="a"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml, '//datafield[@tag="650"]/subfield[@code="a"]')) != 0 AND

[Koha] Shelf List Report help

Dear Koha Community, Please can someone help to provide insight into creating shelf list report that includes the following; 1. Call Number 2. Title 3. Author 4. Barcode and 5. Cost This sort of information and report can help our library into doing simple stock-

Re: [Koha] Shelf List Report help

Hi David, What about this one: SELECT items.itemcallnumber,biblio.title,biblio.author,items.barcode,items.price,items.replacementprice FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)

Re: [Koha] Shelf List Report help

Thank you Irma, the information was helpful indeed Chrs Decka From: Irma Birchall [mailto:i...@calyx.net.au] Sent: Wednesday, July 20, 2016 1:48 PM To: Decka David Cc: Koha-List Subject: Re: [Koha] Shelf List Report help Hi David, What about this one: SELECT items.itemcallnumber,biblio