Voyager to Alma Migration Query: Identify Duplicate Reserve List Titles

When migrating from Voyager to Alma, you may need to identify and resolve any duplicate (non-unique) Reserve List Titles. See the Voyager To Alma Migration Guide for additional help on how non-unique Reserve List Titles are migrated.

This query, which you can run using Voyager Prepackaged Access Reports, can help you identify duplicate Reserve List Titles

SELECT RESERVE_LIST.LIST_TITLE, Count(RESERVE_LIST.RESERVE_LIST_ID) AS CountOfLIST_ID
FROM RESERVE_LIST
WHERE (((RESERVE_LIST.LIST_TITLE) Is Not Null))
GROUP BY RESERVE_LIST.LIST_TITLE
HAVING (((Count(RESERVE_LIST.RESERVE_LIST_ID))>1));

For other queries that may be useful, see my "Surviving Almanado: tips for a successful pre-implementation" presentation's Accompanying Materials.

If you need assistance in running custom SQL queries in Prepackaged Access Reports, consult the Voyager Customer Listserv.