[Koha] Need with suppression report

[Chris Hobbs]

Do you know which version of mysql you are using? ExtractValue requires a
minimum of mysql 5.1.5 to be used. I wonder if this is what is causing the
error?

Chris

-- 
Chris Hobbs
Director, Technology
New Haven Unified School District



2011/7/19 Kathy Rippel <kdr at ckls.org>

>  I am trying to do a report of all items in a certain location that is NOT
> suppressed.
>
> I went to the SQL report library and found the report by Chris Hobbs called
> *Bibs Suppressed in OPAC*. I figure if I can get that to work I can
> probably tweak it for the rest.However, I can't get this report to run, as
> is. I've tried some minor changes, but I keep getting an error message that
> says
>
> *The following error was encountered:
> *The database returned the following error:
> 1
> Please check the log for further details.
>
> I don't have access to the log, as far as I know.
>
> Here is the report, please let me know if there is something wrong with it.
> We are now using Community Koha.
>
>
>   SELECT concat( '<a
> href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=',
> biblio.biblionumber, '">', biblio.title, '</a>' ) AS title,
> biblio.author
>   FROM biblioitems
>   JOIN biblio ON ( biblioitems.biblionumber = biblio.biblionumber )
>   WHERE ExtractValue( marcxml,
> '//datafield[@tag="942"]/subfield[@code="n"]' )
>   IN ('Y', '1')
>
>
> Kathy
>
>  Kathleen D. Rippel
> Dept. Head/Consultant--Resource Access and Sharing
> Central Kansas Library System
> 1409 Williams
> Great Bend, KS 67530
>
> (620-792-4865) phone
> (800-362-2642) toll-free, KS
> (620-792-5495) fax
>
> kdr at ckls.org
> ********************************************************************************************
> I'm currently reading: The game of kings, by Dorothy Dunnett.
> I'm currently listening to: The astonishing life of Octavian Nothing. Vol.
> 2, The kingdom on the waves, by M. T. Anderson.
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110719/ae0164b1/attachment.htm