[Koha] Subtitles

[Paul]

At 01:21 PM 3/31/2012 -0400, Nicole Engard wrote:
>This report on the Koha wiki shows how to get the title and subtitle:
>http://wiki.koha-community.org/wiki/SQL_Reports_Library#Title.2FSubtitle_List

Thanks, but I'd already tried that and get as output (Barcode, Acc Date, 
Title, Subtitle, Author, Publisher, Year, Edition, FMV, Condition, ) e.g.:

1MEGN09120078 :: 2011-07-22 :: Heroes of the Atlantic : :: 
//datafield[@tag="245"]/subfield[@code="b"] :: Halstead, Ivor :: Lindsay 
Drummond :: 1941 :: 1941 :: 15 :: g/fair

So apparently not finding the data, which is "A Tribute to the Merchant Navy".

Our "Keyword to MARC Mapping" shows 245$b as mapped to 'Subtitle', so I am 
just looking for a simple way (we can concatenate later if needed) to get 
the value of the field into the report.

Best - Paul


>Nicole
>
>On Sat, Mar 31, 2012 at 12:17 PM, Paul <paul.a at aandc.org> wrote:
> > Could some kind person please help with subtitles MARC 245$b in mysql
> > reports?
> >
> > We're trying to improve a fully functional script, but for a SELECT neither
> >
> > [other things],biblio.subtitle AS Subtitle,[other things]
> > nor
> > [other things],biblio.remainderoftitle AS Subtitle,[other things]
> >
> > appears to function (the second comes from the Koha Wiki which suggests 
> that
> > it was introduced in/after 3.2 having been dropped in v3.) Â The 
> "SchemaSpy"
> > also appears to be silent on this field.
> >
> > Many thanks - Paul
> >
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha

---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://UltraMarine.ca>, <http://AandC.org> and <http://MarDoc.ca>