Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Only 2 or 3 Browse List Entries for Certain Searches

    Only 2 or 3 Browse List Entries for Certain Searches

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    We have a problem with certain "Title begins with..." searches:
    "the old man and the sea" produces only 2 Browse list entries!
    We have some issues with catalogued records and initial articles, but regardless of that problem, shouldn't #2 still give a list of 10 items, second in the list being our hit and previous and next pages further to other records?

    Resolution:
    Browsing on the title "The " and doing Next Page to see all of them, the OPAC gives us 12 titles. But when I do the following SQL I get a result of 2987:
    SQL-xxx01> select count(*) from z01 where z01_rec_key like 'TIT LTHE %';

    This means that there are 2,975 Headings (Z01) beginning with "THE " which have no title (Z02) associated with them. Such titles are suppressed from display, but in building this display the large number of suppressed headings is causing these skewed results.

    You should run p_manage_15.
    manage_15 deletes Z01s which have no Z02 for them and no link to an authority record. This will result in a more normal display.

    Note: These headings must have previously had titles associated with them and either a batch or online update has made them obsolete.

    p_manage_02 does not generate headings which have no associated title and no connected authority record. The only way this can occur is when the heading is updated/deleted.

    {When a heading is deleted, the old Z01 remains (--suppressed from display). It is only p-manage-15 or p-manage-02 which actually, physically delete such headings.}

    Additional Information

    p_manage_15,headings, browse titles


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Only "English" displays as GUI language option
      • Only First 10 Entries in tab_delivery_locations.eng Appear in Circulation Cilent
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 16.02
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved