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. Vendor Searching omits certain vendors

    Vendor Searching omits certain vendors

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

    Description:
    When we are searching for a vendor to assign to an order in the Acquisitions module and we use the Vendor Filter to search under the letter 'B', the first vendor that comes up is Biblio.com.

    Why don't the vendors Backhuys and Bagchee appear at the top of the list for this search?

    Resolution:
    These SQLs show that the z70_name_key (used for building this display) is sometimes uppercase and sometimes lower:

    SQL-xxx50> select Z70_NAME_KEY from z70 where Z70_NAME_KEY like 'B%';

    Z70_NAME_KEY
    ----------------------------------------
    BIBLIO COM
    BIBLIOMANIA = SLC UTAH BRECK BARTHOLOMEW
    BILL ESCHMEYER
    <etc.>

    SQL-xxx50> select Z70_NAME_KEY from z70 where Z70_NAME_KEY like 'b%';

    Z70_NAME_KEY
    ----------------------------------------
    backhuys publishers
    bagchee
    balaban publishers
    <etc.>

    To correct this, you need to run p_manage_64 to rebuild the z70_name_key field (p_manage_64 is included in the Acquisitions client's services).

    (keywords: p-manage-64 manage_64 vendor filter order)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Vendor record containing comma can't be deleted
      • Vendor update date is not updated
    • 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