Skip to main content
  • 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



    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?


    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:


    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?