[Koha] Shelf List Report help

[Irma Birchall]

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
>