https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17788 Bug ID: 17788 Summary: (MARC21) $9 fields not indexed in authority-linked fields Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: MARC Bibliographic data support Assignee: gmcharlt@gmail.com Reporter: tomascohen@gmail.com QA Contact: testopia@bugs.koha-community.org If you check the default framework shipped with Koha, you will notice several fields are linked to authority records (even though they might be hidden in the editor): MariaDB [koha_kohadev]> SELECT tagfield,tagsubfield,authtypecode FROM marc_subfield_structure WHERE authtypecode IS NOT NULL AND authtypecode<>'' AND frameworkcode='' GROUP BY tagfield,tagsubfield,authtypecode ; +----------+-------------+--------------+ | tagfield | tagsubfield | authtypecode | +----------+-------------+--------------+ | 100 | a | PERSO_NAME | | 110 | a | CORPO_NAME | | 111 | a | MEETI_NAME | | 130 | a | UNIF_TITLE | | 440 | a | UNIF_TITLE | | 600 | a | PERSO_NAME | | 610 | a | CORPO_NAME | | 611 | a | MEETI_NAME | | 630 | a | UNIF_TITLE | | 648 | a | CHRON_TERM | | 650 | a | TOPIC_TERM | | 651 | a | GEOGR_NAME | | 654 | a | TOPIC_TERM | | 655 | a | GENRE/FORM | | 656 | a | TOPIC_TERM | | 657 | a | TOPIC_TERM | | 658 | a | TOPIC_TERM | | 662 | a | GEOGR_NAME | | 690 | a | TOPIC_TERM | | 691 | a | GEOGR_NAME | | 696 | a | PERSO_NAME | | 697 | a | CORPO_NAME | | 698 | a | MEETI_NAME | | 699 | a | UNIF_TITLE | | 700 | a | PERSO_NAME | | 710 | a | CORPO_NAME | | 711 | a | MEETI_NAME | | 730 | a | UNIF_TITLE | | 796 | a | PERSO_NAME | | 797 | a | CORPO_NAME | | 798 | a | MEETI_NAME | | 799 | a | UNIF_TITLE | | 800 | a | PERSO_NAME | | 810 | a | CORPO_NAME | | 811 | a | MEETI_NAME | | 830 | a | UNIF_TITLE | | 896 | a | PERSO_NAME | | 897 | a | CORPO_NAME | | 898 | a | MEETI_NAME | | 899 | a | UNIF_TITLE | +----------+-------------+--------------+ But looking at etc/zebradb/marc_defs/marc21/biblio-koha-indexdefs.xml you will notice the $9 subfields is not correctly added to the Koha-Auth-Number:w index. This has the consequence of authority usage count not being precise if those fields are used and linked. -- You are receiving this mail because: You are watching all bug changes.