[Koha] Reporting on 942$c

[Katrin Fischer]

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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha