[Koha] Saving a new item type

Robin Sheat robin at catalyst.net.nz
Tue Oct 21 15:27:19 NZDT 2014


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



More information about the Koha mailing list