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
2011/9/2 Hal Bright <HBright@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
On Thu, Sep 1, 2011 at 8:57 PM, Chris Cormack <chris@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
participants (3)
-
Chris Cormack -
Hal Bright -
Nicole Engard