<html>
<body>
<font size=3>I am trying to do a report of all items in a certain
location that is NOT suppressed.<br><br>
I went to the SQL report library and found the report by Chris Hobbs
called </font><h4><b>Bibs Suppressed in OPAC</b>. I figure if I can get
that to work I can probably tweak it for the
rest.</h4><font size=3>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<br><br>
<b>The following error was encountered:<br>
</b>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. We are now using Community Koha.<br><br>
<br>
</font><pre> 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')
</pre><font size=3>Kathy<br>
</font></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>