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

    Voyager to Alma Migration Query: Reading (Reserve) Lists Linked to Multiple Courses

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



    When migrating from Voyager to Alma, you may want to identify those Reading Lists that are attached to multiple Courses.  When migrating to Alma, such Reading Lists may be migrated in a way that is not desirable. See the Voyager To Alma Migration Guide for additional help.

    This query, which you can run using Voyager Prepackaged Reports, shows those Reading Lists (expired or not) that are linked to multiple Courses. 

    The output shows the number of Courses attached to each Reserve List, which can be 0 or greater.

    SELECT RESERVE_LIST.LIST_TITLE, RESERVE_LIST.RESERVE_LIST_ID, Count(RESERVE_LIST_COURSES.COURSE_ID) AS CountOfCOURSE_ID
    FROM RESERVE_LIST LEFT JOIN RESERVE_LIST_COURSES ON RESERVE_LIST.RESERVE_LIST_ID = RESERVE_LIST_COURSES.RESERVE_LIST_ID
    GROUP BY RESERVE_LIST.LIST_TITLE, RESERVE_LIST.RESERVE_LIST_ID
    ORDER BY RESERVE_LIST.LIST_TITLE;

     

    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.