Re: [Koha] Checked In Status on Reports

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