[Koha] Shelflist report

[Stephen Hedges]

David, to produce a shelflist, you want a list of your items in callnumber
order, right?  So that would depend on where you've stored your call
numbers.  If you use the items.itemcallnumber field for that, then you
could  use MySQL commands to produce a shelflist.  Something like:

mysql> SELECT itemcallnumber, title, barcode FROM items, biblio WHERE
items.biblionumber=biblio.biblionumber ORDER BY itemcallnumber;

If you aren't using itemcallnumber, then you have to do some trickier
joins to wherever you are storing the call numbers.  It all depends on how
you've set your call number mapping.

Stephen

David Miner said:
> Good day,
>
> How do I make Koha produce a shelflist of items in the library for
> inventory purposes?  There does not seem to be one under Reports.
>
> Thanks,
>
> David
>
> David R.
> Miner                                                  Voice:  (850)
> 644-8107
> Assistant In Information Studies                Fax:    (850) 644-6253
> College of Information                          E-mail: miner at ci.fsu.edu
> The Florida State University
> Tallahassee, FL 32306-2100

-- 
Stephen Hedges
Skemotah Solutions, USA
www.skemotah.com  --  shedges at skemotah.com