[Koha] Need with suppression report

[Brendan A. Gallagher]

Hi Kathy -

I just checked and this report should run perfectly...  Actually I just tested it on your system.

When you see an error like that - usually that means there was a space in-front of the 'SELECT'.  That will throw that error.

I've added it to your system it's report id #1085.

-Brendan

On Jul 19, 2011, at 2:04 PM, Kathy Rippel wrote:

> 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/3a7ac1ff/attachment.htm