[Koha] Report Help - Extracting XML

[Grobani, Daniel]

How about LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber = items.biblioitemnumber)?

Daniel

-----Original Message-----
From: Nicole Engard [mailto:nengard at gmail.com] 
Sent: Thursday, July 28, 2011 4:36 AM
To: Grobani, Daniel
Cc: koha at 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 at 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 at lists.katipo.co.nz 
> http://lists.katipo.co.nz/mailman/listinfo/koha
>