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