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. Find the highest (maximum) record ID (BIB, MFHD, etc.) in Voyager database

    Find the highest (maximum) record ID (BIB, MFHD, etc.) in Voyager database

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

     

    Question

    How can we determine what the highest BIB_ID is in our Voyager database?

    Answer

    The following Access query can be run in Prepackaged Access Reports to find your highest BIB_ID. 

    Remember the highest BIB_ID does not reflect the number of records in your database.  To find the number of records in your database please see: Find the number of bibliographic records (BIB, MFHD, etc.) in Voyager

    SELECT Max(BIB_MASTER.BIB_ID) AS MaxOfBIB_ID
    FROM BIB_MASTER;

    This query can be modified to find highest MFHD, AUTH record IDs.

     

    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: 26-Apr-2022
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Find patron's group ID and DB key for OvP calls
      • Find the number of bibliographic records (BIB, MFHD, etc.) in Voyager
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      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