Dear Caterina, When you say "clean the indexes", do you mean finding _unused_ subject authority records and removing them? If the answer is "yes", have a look at the following thread: https://lists.katipo.co.nz/pipermail/koha/2017-November/049404.html On the other hand, if your intention is to correct your authorities (fix misspellings, etc.) based on the number of occurrences for each record a somewhat different approach is required. Let us know what you're trying to achieve and I might be able to help. Kind regards, Andreas On 23 May 2018 at 18:13, Caterina Sansone < caterina.sansone@palais-portedoree.fr> wrote:
Dear all,
I have been wandering the web in the last days but couldn't find a solution to my problem :
I have a SQL report to obtain a list of authorities (subject : 250a and subfields), but in order to clean the indexes I would like to create a SQL report to obtain a list of authorities with their occurences (how many times each authority has been used).
Also, sorting it by alphabetical order would be great.
Of course I can see them on Koha but surfing 140 pages is not ideal!
We are on Koha 3.22.
Does anyone have any idea how to do that?
Thanks to all,
Caterina
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha