[Koha] Checked In Status on Reports
chris at bigballofwax.co.nz
Fri Sep 2 12:57:08 NZST 2011
2011/9/2 Hal Bright <HBright at farmingtonlibraries.org>:
> I want a list of books in a particular Item Type that are only checked in.
> Is there a code like items.status 'checkedin'? for the item?
Nope, but there is a checked out one, called onloan, if that is null
or blank the book is checked in
SELECT title,author,barcode FROM biblio,items WHERE
biblio.biblionumber=items.biblionumber AND items.itype ='you item type
goes here' AND (items.onloan is NULL or items.onloan = '')
Thats two ' not one " :)
More information about the Koha