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

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)

[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-