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

    Voyager to Alma Migration Query: Identify Duplicate Reserve List Titles

    Created By: Laura Guy (contact)
    Created on: 10/12/2020



    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.




    • Was this article helpful?