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 tables added or modified since a specific date

    List Voyager Prepackaged Access Reports tables 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 tables in my Prepackaged Access Reports Reports.MDB file?

    Answer

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

    SELECT MSysObjects.Name AS table_name, MSysObjects.DateCreate,
    MSysObjects.DateUpdate
    FROM MSysObjects
    WHERE (((MSysObjects.DateUpdate)>[Date after you last linked or added
    tables]) 
    AND ((Left([Name],1))<>"~") AND ((Left([Name],4))<>"MSys") 
    AND ((MSysObjects.Type) In (1,4,6))) OR
    (((MSysObjects.DateCreate)>[Date after you last linked or added tables]) 
    AND ((Left([Name],1))<>"~") AND ((Left([Name],4))<>"MSys") AND
    ((MSysObjects.Type) In (1,4,6)))
    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.

     

     

     


    • Article last edited: 18-Sept-2020
    View article in the Exlibris Knowledge Center
    1. Back to top
      • List Voyager Prepackaged Access Reports reports added or modified since a specific date
      • Loading EDI invoices changes PO status to Received Complete
    • 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