[Koha] Shelf List Report help

[Decka David]

Thank you Irma, the information was helpful indeed
 
Chrs
 
Decka
 
From: Irma Birchall [mailto:irma at 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 <ddavid at 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 at lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha