How to create a list of all authorities?
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 [Description: Description: Description: CR_logo_POS_COULEUR b] LISA PEEL, PGDip, MA. Librarian César Ritz Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: lisa.peel@ritz.edu<mailto:hortense.hofer@ritz.edu> http://www.ritz.edu<http://www.ritz.edu/> - http://www.culinaryarts.ch<http://www.culinaryarts.ch/>
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
participants (2)
-
Peel Lisa -
Stefano Bargioni