Re: [Koha] Regarding SQL query for Analytical entries

2019-01-23 Thread Suresh Kumar Tejomurtula
Thank you. Able to get the report using this : ExtractValue( marcxml, '//datafield[@tag="600"][1]/* ) as subject1 Regards T Suresh Kumar On Tue, 22 Jan, 2019, 10:41 Barton Chittenden Suresh, > > Unfortunately, there's not a great way to do this -- the problem is that > repeated tags in marcxml

Re: [Koha] Regarding SQL query for Analytical entries

2019-01-21 Thread Barton Chittenden
Suresh, Unfortunately, there's not a great way to do this -- the problem is that repeated tags in marcxml are extracted as a single value by ExtractValue. Here's what the Koha wiki has to say in the matter: Note that ExtractValue concatenates multiple tags into a single field. These can be indivi