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.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) WHERE items.homebranch=<<Home branch|branches>> ORDER BY items.itemcallnumber ASC Hope this helps. Irma CALYX On 20 July 2016 at 11:25, Decka David <dda...@lib.unitech.ac.pg> wrote: 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-take for the total records after migration. Thank you Decka David _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
