2011/9/2 Hal Bright <hbri...@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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha