Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ISSN searching not working on Direct index

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    Going from version 15.5 to version 18, we get the message: "No matching records found" when searching for BIB-ISSN, such as, "1350-0775" in the Acquisitions search, and using util F/4 on the z11 table and were not able to retrieve it directly. It seems to "choke" on the hyphen. If we search BIB-ISSN using truncation we get the ISSNs starting with 1350.

    Our tab_filing for ISSN entries is as follows. Does it need to be adjusted, or is the "issn" filing_rule not functioning correctly for IND indexes? Our libraries that have ISSN ACC indexes that use the same filing rule retrieve correctly when pc_tab_exp_field.eng is set to "BIB-ISSN".

    Our ISSN filing rule:

    36 F del_subfield
    36 F to_lower
    36 F issn
    36 F pack_spaces


    Util F/4 behavior, attempting to retrieve on a full number.

    enter start z11 key (CCCCCAXXXXXXXXX) <-- Entering ISSN L1350 gets me the entry, as it's the first ISSN that starts with 1350.
    ISSN L1350

    01 z11_index \
    02 z11_rec_key \
    03 ind_code .......ISSN
    03 filing_text ....1350-0775
    03 sequence_1 .....000703202
    02 z11_doc_number ...000703202
    02 z11_alpha ........L
    02 z11_text .........$$a1350-0775
    new key = K, exit = Q, continue = RETURN
    k

    enter start z11 key (CCCCCAXXXXXXXXX)
    ISSN L1350-0775 <--- Entering "ISSN L1350-0775" jumps past the ISSNs starting with 1350, as does "ISSN L13500775"

    01 z11_index \
    02 z11_rec_key \
    03 ind_code .......ISSN
    03 filing_text ....1351-0126
    03 sequence_1 .....000709568
    02 z11_doc_number ...000709568
    02 z11_alpha ........L
    02 z11_text .........$$y1351-0126
    new key = K, exit = Q, continue = RETURN

    enter start z11 key (CCCCCAXXXXXXXXX)
    ISSN L13500775

    01 z11_index \
    02 z11_rec_key \
    03 ind_code .......ISSN
    03 filing_text ....1351-0126
    03 sequence_1 .....000709568
    02 z11_doc_number ...000709568
    02 z11_alpha ........L
    02 z11_text .........$$y1351-0126

    Resolution:
    The filing routine "issn" strips out the hyphen. Since the abc01 tab_filing includes the "issn" routine and since the tab00.eng line for the ISSN index specifies "36" as the filing routine to be used, the Z11 ISSN records should have been built without any hyphen.

    util f/1/3 for abc01 shows this:

    Enter Filing Procedure (Q to quit)
    Enter values as defined in Col. 1 of tab_filing: 36
    Enter values D/N/F or Space:
    Enter text (Q to quit) : $$a1350-0775
    IN -$$a1350-0775 -
    OUT -13500775 -

    If you resend a bib record to the server, you should find that its Z11 ISSN entry is generated without the hyphen.

    It seems that either this Z11 was copied from 15.5 or, if it was generated in version 18, that it was generated at a time when fiing routine 36 was not being specified for the ISSN.


    • Article last edited: 10/8/2013
    • Was this article helpful?