Message-
From: Nicole Engard [mailto:neng...@gmail.com]
Sent: Thursday, July 28, 2011 5:02 PM
To: Grobani, Daniel
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Report Help - Extracting XML
Okay - this:
select count(statistics.datetime) as circs, CONCAT('a
href=\/cgi-bin/koha/catalogue
Daniel,
That part I knew :) it was getting it in to the query (the joining) I
was having trouble with :)
Nicole
On Wed, Jul 27, 2011 at 8:00 PM, Daniel Grobani
dgrob...@samuelmerritt.edu wrote:
Nicole,
This should give you the 520a:
extractValue(biblioitems.marcxml,
ON (biblioitems.biblioitemnumber =
items.biblioitemnumber)?
Daniel
-Original Message-
From: Nicole Engard [mailto:neng...@gmail.com]
Sent: Thursday, July 28, 2011 4:36 AM
To: Grobani, Daniel
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Report Help - Extracting XML
Daniel,
That part I knew
Try this (I also did some light cleanup):
SELECT COUNT(statistics.datetime) AS circs,
CONCAT(' \/cgi- ',biblio.title,' ') AS Title,
CONCAT(' \http://mycatalogv/cgi-
Okay - this:
select count(statistics.datetime) as circs, CONCAT('a
href=\/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\',biblio.title,'/a')
AS Title, CONCAT('a
stick.
Daniel
-Original Message-
From: Nicole Engard [mailto:neng...@gmail.com]
Sent: Thursday, July 28, 2011 5:02 PM
To: Grobani, Daniel
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Report Help - Extracting XML
Okay - this:
select count(statistics.datetime) as circs, CONCAT('a
href
Nicole,
This should give you the 520a:
extractValue(biblioitems.marcxml,
collection/record/datafield[@tag='520'][1]/subfield[@code='a'])
Of course, you'll have to do a join on biblioitems.
-
Cheers,
Daniel Grobani
Library Technology Specialist
John A. Graziano Memorial Library
Samuel
7 matches
Mail list logo