[Koha] Checked In Status on Reports

[Chris Cormack]

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 " :)

Chris