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_Lis...
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
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
On Sat, Mar 31, 2012 at 12:17 PM, Paul <paul.a@aandc.org> wrote: 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>