[Koha] SQL report for list of authorities with occurrences

[Caterina Sansone]

Dear Andreas,

Thank you for your answer.

By "cleaning the indexes" I mean pruning doubles. For instance, we have a lot of redundant keywords with the same term in singlular or plural (for instance : "immigrant" and "immigrants") that I would like to merge.

I should also say that my background is not in IT at all, I am in the library for a short period, and I have to follow Koha among other missions. That means that I am not able to work with php scripts, I was wondering if there is a (relatively) easy way to use a SQL report to do what I wish.

I was thinking about a "simple" jointure on two tables but I am unable to find a way to express the relationship between the auth_header table and the biblioitems table.
I am not sure if I am making sense... Any ideas?
Thanks a lot for your help,
Caterina


________________________________
De : Andreas Roussos <arouss1980 at gmail.com>
Envoyé : mercredi 30 mai 2018 11:35:19
À : Caterina Sansone
Cc : koha at lists.katipo.co.nz
Objet : Re: [Koha] SQL report for list of authorities with occurrences

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 at palais-portedoree.fr<mailto:caterina.sansone at 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 at lists.katipo.co.nz<mailto:Koha at lists.katipo.co.nz>
https://lists.katipo.co.nz/mailman/listinfo/koha