Uploaded image for project: 'mod-marccat'
  1. mod-marccat
  2. MODCAT-108

It's not possible to see authority record for subject starting from a Browse function

    XMLWordPrintable

    Details

    • Template:
    • Development Team:
      @cult

      Description

      In MARCcat browsing "Subject: All: "Atti persecutori", the system will display the heading with one authority record, ten bibliographic records and two cross reference. Clicking on that heading to see the authority and bibliographic record in the third panel, the system doesn't display the authority record (I see message "Non associated Authority record"), but only the bibliographic records.

      It seems that it the index SK used to find authority record for subject is not working.

      Follow the SQL produced by the BE during the search:

      CCL => "SK 95691" became "select res.aut_nbr from (select distinct smtc.aut_nbr from ((select distinct aut.aut_nbr from aut where (aut.hdg_nbr IN 95691 AND aut.hdg_typ_cde='SH'))) smtc order by smtc.aut_nbr desc ) res limit 30 offset 0"
      org.postgresql.util.PSQLException: ERROR: syntax error at or near "95691"
      Position: 122

      To find the wrong query on DB do the following select in table S_BIB1_SMNTC:

      select sql_whr from S_BIB1_SMNTC where ATRBT_USE_NBR = 21 and qry_nbr = 427

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                mirko.fonzo@atcult.it Mirko Fonzo
                Reporter:
                annadis Annalisa Di Sabato
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases