[Koha] Report Help - Extracting XML

[Nicole Engard]

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 at samuelmerritt.edu> wrote:
> 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
>>
>