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