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
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
_
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
3 matches
Mail list logo