Thank you Irma, the information was helpful indeed Chrs Decka From: Irma Birchall [mailto:[email protected]] 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 <[email protected]> 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 [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
