[Koha] How to include 952$x in a report
paul.a at aandc.org
Tue Feb 21 11:47:10 NZDT 2012
At 10:24 AM 2/21/2012 +1300, Chris Cormack wrote:
>On 21 February 2012 10:17, Paul <paul.a at aandc.org> wrote:
> > Help requested please from an expert in MySQL reports. Â The code below
> > perfectly, but I want to add 952$x (a text string for the condition of our
> > holdings as in "good/fair" or "fine tpb") to the first line.
> > If I add items.more_subfields_xml (which includes 952$x) I get a
> plethora of
> > formatted XML that is unsuitable for copying straight into a spreadsheet.
[snip first trial code]
Thanks Chris, I had tried something along those lines, and have now tried
again. Started with deleting the:
per mysql manual "The statement selects all rows if there is no WHERE
clause", but still get error "can't use undefined value as an ARRAY
reference" at guided_reports.pl line 618. After multiple trial/error
changes to punctuation, etc, here's what I have, still non-functional:
LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber)
ORDER BY items.biblionumber asc
Removing the "SELECT ExtractValue ..." and preceding semi-colon works fine,
I'm just totally flummoxed on getting the 952$x part to function. Is
another LEFT JOIN required?
Could you possibly suggest the correct syntax? Many thanks.
More information about the Koha