Re: [Koha] SQL report for list of authorities with occurrences

2018-05-31 Thread Caterina Sansone
Dear Andreas, THANK YOU! It works perfectly for me! All best, Caterina De : Andreas Roussos Envoyé : mercredi 30 mai 2018 19:18:11 À : Caterina Sansone Cc : koha@lists.katipo.co.nz Objet : Re: [Koha] SQL report for list of authorities with occurrences Dear

Re: [Koha] SQL report for list of authorities with occurrences

2018-05-30 Thread Andreas Roussos
Dear Caterina, Try pasting the following SQL into a Koha report, it should give you the number of occurrences per authority. Please bear in mind that I made the following assumptions: (a) your Topical Subject authorities go in UNIMARC field 606 of your biblios (b) you have no more than 5 subjects

Re: [Koha] SQL report for list of authorities with occurrences

2018-05-30 Thread Caterina Sansone
ndreas Roussos Envoyé : mercredi 30 mai 2018 11:35:19 À : Caterina Sansone Cc : koha@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 rem

Re: [Koha] SQL report for list of authorities with occurrences

2018-05-30 Thread Andreas Roussos
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 co

[Koha] SQL report for list of authorities with occurrences

2018-05-23 Thread Caterina Sansone
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