Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. Considerations when using the BIB_INDEX table in Voyager Prepackaged Access Reports

    Considerations when using the BIB_INDEX table in Voyager Prepackaged Access Reports

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
      1. Example Query Using BIB_INDEX
    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Question

    Some considerations when using the BIB_INDEX table in Voyager Prepackaged Access Reports.

    Answer

    The BIB_INDEX table is one of the major cataloging tables used in Voyager Prepackaged Access Reports, along with the BIB_TEXT, MFHD_MASTER, ITEM, ITEM_BARCODE, ITEM_TYPE, and ITEM_STATUS tables.

    The BIB_INDEX table references the Indexes area of Voyager SysAdmin:

    clipboard_efcc34ebef957e6cf556bcdb9f765c8f4.png

     

    Use BIB_INDEX for left-anchored indexes in normalized and display forms, including:

    •OCLC control numbers (035$a, 035$9, 035$z)

    •1XX, 6XX, 7XX, and 8XX headings

    •Title (245 0^ & 1^)

    •Preceding and succeeding titles for serials (780 0^ and 785 0^)

    Example Query Using BIB_INDEX

    clipboard_e473b2a32ba83577f27a74811ff4138c3.png

    This query will return the BIB IDs and (if present) topical subject headings of every record in your database, sorted alphabetically by the subject heading.

    Constructing custom SQL queries by request and troubleshooting unexpected results from customer-created SQL queries falls outside the scope of Support. The above has been posted for informational purposes.  Voyager-L and Developer Network are useful resources for finding helpful custom SQL or obtaining assistance from peers in troubleshooting custom queries.


    • Article last edited: 21-Jun-2021
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Considerations when using date fields in Voyager Prepackaged Access Reports
      • Considerations when using the BIB_TEXT table in Voyager Prepackaged Access Reports
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    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