[Koha] Where are subtitles stored?

[Alvaro Cornejo]

Hi Randy

All marc info is xml-coded inside biblio_metadata table.

For reporting them, you need to use an xml parser like
Extractvalue(metadata, '//datafield[@tag="245"]/subfield[@code="a"]')

Therefore an example of a mysal report might be

SELECT DISTINCT CONCAT('<a href=\"/cgi-bin/koha/catalogue/
detail.pl?biblionumber=',biblionumber,'\">',biblionumber,'</a>') AS
EditRecord, Extractvalue(metadata,
'//datafield[@tag="245"]/subfield[@code="a"]') AS Title,
Extractvalue(metadata, '//datafield[@tag="245"]/subfield[@code="b"]') AS
Subtitle
FROM biblio_metadata


Regards

Alvaro





|----------------------------------------------------------------------------------------|
 Stay safe / Cuídate/  Reste sécurisé
*7* Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
mesure.
 *q *Recycle always / Recicla siempre / Recyclez toujours
 P Print only if absolutely necessary / Imprime solo si es necesario /
Imprimez seulement si nécessaire


Le jeu. 1 oct. 2020 à 17:23, Randy Wright <RWright at sbbg.org> a écrit :

> We migrated to Koha two years ago by importing MARC records from our old
> system. Recently I was asked to do a report which included both titles and
> subtitles. According to my mapping, this should be 245$a and 245$b mapped
> to biblio.title and biblio.subtitle, respectively. I find that there is
> nothing in any of the biblio.subtitle fields of the imported records. There
> is data in biblio.subtitle for the items we have added from within Koha
> after the import. I have checked the MARC records file we imported, and
> 245$a and 245$b are populated correctly. What puzzles me is that the OPAC
> shows the subtitles correctly for everything. Where would it be getting the
> data, if not from biblio.subtitle?
>
> Randy Wright
>
> Information Resource Steward
> Santa Barbara Botanic Garden Blaksley Library
> 1212 Mission Canyon Road
> Santa Barbara CA 93105
>
> 805-682-4726 x107
>
> www.sbbg.org
> www.sbbgphotos.org
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>