Re: [Koha] Report Help - Extracting XML

2011-07-29 Thread Nicole Engard
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

Re: [Koha] Report Help - Extracting XML

2011-07-28 Thread Nicole Engard
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,

Re: [Koha] Report Help - Extracting XML

2011-07-28 Thread Nicole Engard
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

Re: [Koha] Report Help - Extracting XML

2011-07-28 Thread Daniel Grobani
Try this (I also did some light cleanup): SELECT COUNT(statistics.datetime) AS circs, CONCAT(' \/cgi- ',biblio.title,' ') AS Title, CONCAT(' \http://mycatalogv/cgi-

Re: [Koha] Report Help - Extracting XML

2011-07-28 Thread Nicole Engard
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

Re: [Koha] Report Help - Extracting XML

2011-07-28 Thread Grobani, Daniel
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

Re: [Koha] Report Help - Extracting XML

2011-07-27 Thread Daniel Grobani
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