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 < [email protected]> 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 > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
