[Koha] Need with suppression report
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=""
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
k...@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@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Need with suppression report
Thanks all, we'll check with Bywater, I guess. I don't know
what mysql version they have us on.
Kathy
At 06:01 PM 7/19/2011, Chris Cormack wrote:
2011/7/20 Kathy Rippel
k...@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="">
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')
Hi Kathy
That seems to work fine for me, one possibility is that the mysql
server is not new enough to support ExtractValue, you would need to
get your support company to check this out for you though.
Since you are running official Koha, I'm sure they will be able to
do
this for you nice and fast ;)
Chris
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
k...@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@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Help with report, please!
I found Nicole's report in the SQL library for Patrons with fines. I modified it to allow our libraries to choose their branch. But it doesn't seem to run. Can someone show me where the problem is, please? Kathy --- SELECT borrowers.cardnumber, borrowers.surname, borrowers.firstname, FORMAT(SUM(accountlines.amountoutstanding),2) AS due FROM borrowers LEFT JOIN accountlines ON (borrowers.borrowernumber=accountlines.borrowernumber) WHERE accountlines.amountoutstanding 0 AND borrowers.branchcode='__BRANCHCODE__' GROUP BY borrowers.cardnumber ORDER BY borrowers.surname ASC Kathleen D. Rippel Dept. Head/Consultant--Resource Sharing and Access ; Pathfinder Central (Manager) Central Kansas Library System 1409 Williams Great Bend, KS 67530 (620-792-4865) phone (800-362-2642) toll-free, KS (620-792-5495) fax k...@ckls.org I'm currently reading: This fatal writ, by Sara Woods. I'm currently listening to: The passage, by Justin Cronin. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
