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

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

    • 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
    • Was this article helpful?