[Koha] How to create a list of all authorities?

[Stefano Bargioni]

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