7 Apr
2011
7 Apr
'11
8:27 a.m.
If your Koha uses MySQL 5.1, you can try something like SELECT ExtractValue(`marcxml`,'//datafield[@tag="100"]/subfield[@code="a"]') v FROM `auth_header` WHERE ExtractValue(`marcxml`,'count(//datafield[@tag="100"])>0') ORDER BY v This example extracts 100$a from the auth_header.marcxml column. HTH. Stefano On Apr 6, 2011, at 19:19 , Peel Lisa wrote:
Hello
I need to create a list of all authorities which I can export to excel. There do not seem to be any examples of these on the SQL Report Library, so if anyone could help me I would really appreciate it – I am trying to clean up our authorities and it is very time consuming doing this just through the Authorities module.
Regards
Lisa