<html>
<body>
<font size=3>Thanks all, we'll check with Bywater, I guess. I don't know
what mysql version they have us on.<br><br>
Kathy<br><br>
At 06:01 PM 7/19/2011, Chris Cormack wrote:<br>
<blockquote type=cite class=cite cite="">2011/7/20 Kathy Rippel
<kdr@ckls.org>:<br>
> I am trying to do a report of all items in a certain location that
is NOT<br>
> suppressed.<br>
><br>
> I went to the SQL report library and found the report by Chris Hobbs
called<br>
><br>
> Bibs Suppressed in OPAC. I figure if I can get that to work I can
probably<br>
> tweak it for the rest.<br>
><br>
> However, I can't get this report to run, as is. I've tried some
minor<br>
> changes, but I keep getting an error message that says<br>
><br>
> The following error was encountered:<br>
> The database returned the following error:<br>
> 1<br>
> Please check the log for further details.<br>
><br>
> I don't have access to the log, as far as I know.<br>
><br>
> Here is the report, please let me know if there is something wrong
with it.<br>
> We are now using Community Koha.<br>
><br>
><br>
> Â SELECT concat( '<a<br>
> href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=',<br>
> biblio.biblionumber, '">', biblio.title, '</a>' ) AS
title,<br>
> biblio.author<br>
> Â FROM biblioitems<br>
> Â JOIN biblio ON ( biblioitems.biblionumber =
biblio.biblionumber )<br>
> Â WHERE ExtractValue( marcxml,<br>
> '//datafield[@tag="942"]/subfield[@code="n"]'
)<br>
> Â IN ('Y', '1')<br>
><br>
Hi Kathy<br><br>
That seems to work fine for me, one possibility is that the mysql<br>
server is not new enough to support ExtractValue, you would need to<br>
get your support company to check this out for you though.<br><br>
Since you are running official Koha, I'm sure they will be able to
do<br>
this for you nice and fast ;)<br><br>
Chris</font></blockquote></body>
<br>
<body>
<font face="Garamond" size=4>Kathleen D. Rippel<br>
Dept. Head/Consultant--Resource Access and Sharing<br>
Central Kansas Library System<br>
1409 Williams<br>
Great Bend, KS 67530<br><br>
(620-792-4865) phone<br>
(800-362-2642) toll-free, KS<br>
(620-792-5495) fax<br><br>
kdr@ckls.org<br>
</font><font size=3>
********************************************************************************************<br>
</font><font face="Garamond" size=4>I'm currently reading: The game of
kings, by Dorothy Dunnett.<br>
I'm currently listening to: The astonishing life of Octavian Nothing.
Vol. 2, The kingdom on the waves, by M. T. Anderson.</font><font size=3>
</font></body>
</html>