[Koha] Checked In Status on Reports

[Nicole Engard]

On Thu, Sep 1, 2011 at 8:57 PM, Chris Cormack <chris at 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