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