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 _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
