Find the number of our authority records in Voyager?
- Product: Voyager
- Relevant for Installation Type: Total Care; Dedicated-Direct; Direct; Local
How to find the total number of authority records in Voyager?
For each authority record in the database, there is one row in the table AUTH_MASTER. Query for total number of rows in this table to retrieve the number of authority records.
- Open Prepackaged Reports
- Create new query in SQL view.
- Enter query for number of rows in table (see Additional Information)
Query for number of rows in AUTH_MASTER:
select count(*) from AUTH_MASTER;
Note that a similar query can be run on BIB_MASTER to retrieve number of bibliographic records in database.
The following can be copied/pasted into your Prepackaged Access Reports:
SELECT Count(AUTH_MASTER.AUTH_ID) AS CountOfAUTH_ID FROM AUTH_MASTER;
Article last edited: 06-Sep-2017