[Koha] Where are subtitles stored?

[Indranil Das Gupta]

Hi Randy,

the subtitle aka 245$b is being populated front the actual marcxml record
stored for each bib in the biblio_metadata table.

Thus, in order to fetch the subtitle in your SQL report, you will need to
pull it out of the marcxml data using the ExtractValue XML function in
MySQL / MariaDB.

If case you are not familiar with the syntax to use, the Koha SQL Reports
library on the koha wiki has several examples of this.

Cheers,
Indranil

On Fri, 2 Oct, 2020, 3:53 am Randy Wright, <RWright at sbbg.org> wrote:

> 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
>