[Koha] Report help needed - filter by itemtype

I can't seem to get the report to filter on item type. Probably another typo somewhere. it works if I take out this line: biblioitems.itemtype=‘BK’ But I want to filter by books (and eventually other item types). SELECT ExtractValue(b.marcxml, '//datafield[@tag="100"]/subfield[@code="a"]'), Ex

Re: [Koha] Report help needed - filter by itemtype

Elaine Bradtke schreef op vr 06-06-2014 om 21:42 [+0100]: > WHERE biblioitems.itemtype=‘BK’ AND datecreated You have smartquotes around the BK. You can't have smartquotes anywhere. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF _

Re: [Koha] Report help needed - filter by itemtype

hi, For item pull down list try this: Replace this: biblioitems.itemtype=‘BK’ with: items.itype=<> On Mon, Jun 9, 2014 at 5:49 AM, Robin Sheat wrote: > Elaine Bradtke schreef op vr 06-06-2014 om 21:42 [+0100]: > > WHERE biblioitems.itemtype=‘BK’ AND datecreated > > You have smartquotes aro