Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. List Voyager Prepackaged Access Reports queries added or modified since a specific date

    List Voyager Prepackaged Access Reports queries added or modified since a specific date

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Question

    How might I get a list of custom SQL queries in my Prepackaged Access Reports Reports.MDB file?

    Answer

    The following query will prompt you for a date.  It will then list the queries that have been added or modified since that date.

    SELECT MSysObjects.Name, MSysObjects.DateCreate, MSysObjects.DateUpdate
    FROM MSysObjects
    WHERE (((MSysObjects.DateUpdate)>[Date after you last linked database or
    added queries]) 
    AND ((Left$([Name],1))<>"~") AND ((MSysObjects.Type)=5)) 
    OR (((MSysObjects.DateCreate)>[Date after you last linked database or
    added queries]) 
    AND ((Left$([Name],1))<>"~") AND ((MSysObjects.Type)=5))
    ORDER BY MSysObjects.Name;

    Additional Information

    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.

     

    See also: How to find specific Prepackaged Access Reports queries in Voyager based on certain strings

     


    • Article last edited: 18-Sept-2020
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Link to series from 8XX field in OPAC record
      • List Voyager Prepackaged Access Reports reports added or modified since a specific date
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved