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

    Location of Saved Records and Saved Searches in Voyager Prepackaged Reports

    • Product: Voyager
    • Product Version: 8
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Question

    In preparation for our migration from Voyager to Alma we would like to contact users who have saved records and saved searches in WebVoyage.  How can I find those data in Voyager's Prepackaged Access Reports?

    Answer

    There are two tables of interest to you:

    • SAVED_RECORDS_RESULTS which is where the BIB_ID of saved titles is stored (note the patron is identified by their patron_id) 
    • SAVED_SEARCHES which also is identified by patron_id and has the search string stored in one of the columns.

    Additional Information

    The following SQL (provided by a customer) will show you how many patrons have saved records list:

    select count(distinct patron_id) as patrons
    from saved_records_results
    ;

     

    For more information about the tables and fields, see the Class Diagrams found here: https://knowledge.exlibrisgroup.com/Voyager/Product_Documentation/Voyager_Data_Dictionaries_and_ER_Diagrams

     

    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: 01-Aug-2019
    • Was this article helpful?