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 <pau...@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@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>
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
