[Koha] Generating reports of values in 001

[Fischer, Katrin]

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 at lists.katipo.co.nz [mailto:koha-
> bounces at lists.katipo.co.nz] On Behalf Of glenda.claborne
> Sent: Wednesday, June 19, 2013 2:30 PM
> To: koha at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>