If you don't mind, put your two pieces in to my report in the right places - my problem is that I'm not sure the Join goes where I would normally put it. Nicole On Thu, Jul 28, 2011 at 12:45 PM, Grobani, Daniel <DGrobani@samuelmerritt.edu> wrote:
How about LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber = items.biblioitemnumber)?
Daniel
-----Original Message----- From: Nicole Engard [mailto:nengard@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 :) 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 <dgrobani@samuelmerritt.edu> wrote:
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 Merritt University
-- View this message in context: http://koha.1045719.n5.nabble.com/Report-Help-Extracting-XML-tp4640604 p4640701.html Sent from the Koha - Discuss mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha