Hi Glenda, we are using 001 (Control number) excessively, and the ExtractValue should work ok. What's the exact problem you have? Can you describe it a bit more? What kind of report do you need? I notice that the report you link to is not using 001 but querying 035$a? SELECT b.title, b.author, ExtractValue(m.marcxml, '//datafield[@tag="035"]/subfield[@code="a"]') AS 'OCLC Number' FROM biblio b LEFT JOIN items i USING (biblionumber) LEFT JOIN biblioitems m USING (biblionumber) WHERE i.wthdrawn > 0 Katrin
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha- bounces@lists.katipo.co.nz] On Behalf Of glenda.claborne Sent: Wednesday, June 19, 2013 2:30 PM To: koha@lists.katipo.co.nz Subject: [Koha] Generating reports of values in 001
Hello, there have been previous posts on this issue but no satisfactory answers yet. I have posted the following query in Nicole Engard's ByWater Solutions website and she has referred me to this group in case the SQL queries <http://wiki.koha- community.org/wiki/SQL_Reports_Library#Withdrawn_Titles_Li st_to_Send_to_OCLC> she pointed me to don't work:
"I still can't find a good way to generate a report of the values stored in the 001 tag, either from Koha's report wizard or creating SQL queries using "ExtractValue(marcxml,'//controlfield[@tag="001"]') AS OCLC Control Number". And there's no easy way to map a Koha field to 001 and/or 003 to be able to run reports that include these control fields. I would appreciate some help."
Is this a data issue? Why don't the ExtractValue function work? There's data in the 'marcxml' or 'marc' fields when I simply select them in a query?
Many, many thanks for any help.
Glenda B. Claborne
Library Director
The American University of Iraq, Sulaimani (AUIS)
+964 (0)53-330-1011, ext.1218
Skype: glenda.claborne
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha