Paul A schreef op ma 20-10-2014 om 20:55 [-0400]:
mysql> SELECT itemtype from biblioitems Group by itemtype; +----------+ | itemtype | +----------+ | NULL | | AU | | BK | | CM | | CR | | HB | | VI | | VM | +----------+ 8 rows in set (0.00 sec)
This is 942$c, which is less commonly used. It doesn't apply to items.
mysql> SELECT ExtractValue(marcxml,'//datafield[@tag="952"]/subfield[@code>="y"]') AS itemt FROM biblioitems HAVING itemt REGEXP 'FB'; Empty set (0.59 sec)
This will never work, as 952 isn't stored in with the rest of the MARC record. You want to be looking at the 'items' table: http://schema.koha-community.org/tables/items.html -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF