Hi, the 952 tag is used for item information on export and import, but within Koha the item information is only kept in the items table and not as part of the MARC data. If you want to query for the itemtype (952$y) you need to use the items table, for example: SELECT items.itype FROM items; Hope this helps, Katrin On 18.01.20 16:23, fauzi AB wrote:
Hi Eric and everyone
I'm having the same requirement as Joel
Taken from koha wiki report
SELECT ExtractValue(( SELECT metadata FROM biblio_metadata WHERE biblionumber=12), '//datafield[@tag="942"]/subfield[@code>="c"]') AS ITEM
This sql is working fine for tag 942$c but not for tag 952$y
Is there any special extractvalue for 952?
Thanks in advance Kind regards fauzi AB
-- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha