Re: [Koha] Checked In Status on Reports
On Thu, Sep 1, 2011 at 8:57 PM, Chris Cormack ch...@bigballofwax.co.nz wrote: 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 :) Or you can do this: SELECT title,author,barcode FROM biblio,items WHERE biblio.biblionumber=items.biblionumber AND items.itype = Item Type|itemtypes AND (items.onloan is NULL or items.onloan = '') So that it asks you for an item type and you don't have to edit again later. Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Checked In Status on Reports
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? Hal Bright Farmington Libraries ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Checked In Status on Reports
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