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. Import a SQL query into Voyager Prepackaged Access Reports

    Import a SQL query into Voyager Prepackaged Access Reports

    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 do I import a SQL query into Voyager Prepackaged Access Reports?

    Answer

    This workflow can also be used to copy SQL from one Reports.MDB file to a different Reports.MDB file1. 

    1. Open your Reports.MDB file and open the Queries Category in the left-hand pane.
    2. Click on "Create"

      addsql1.jpg
       
    3. Click on Query Design.

      addsql2.jpg
       
    4. You will see the Show Table pane.
    5. Click on the "x" in the upper right corner to close the pane.

      addsql3.png

       
    6. Right-click at the top of the Query pane where you see "Query1"
    7. In the drop-down select "SQL View"

      addsql5.jpg
       
    8. Copy and paste your SQL code into the Query1 pane.
    9. Make sure you paste the code over what you see in the Query1 pane so that you do not duplicate the "SELECT;" command.

      addsql4.jpg
       
    10. Right-click again at the top of the pane where you see "Query1", click on "Save" and provide a Query Name.
    11. Navigate in the left-hand pane to the Query Name you provided and run your new query.

     

    1Note that a similar workflow using "SQL VIew" can be used to "copy" and "paste" custom queries from one Reports.MDB file to a different Reports.MDB file (you can also use the MS Access export and import functions to do this).  

    Additional Information

    • If you import a query and there's already a query of the same name present, the Import will not replace one with the other. Instead, it will keep both. The imported query will have a "1" appended to the end of the name.
    • Sometimes a query has a "subquery."  Typically you don't run the subquery - but you do need to save it with the name specified.  For an example of a query/subquery see: "Bad E-Mail Addresses" pop-up when attempting to send email notices using Voyager Reporter
    • Be aware that Support does not assist with the creation or debugging of custom SQL queries.  For more information see the Support policy for writing and troubleshooting custom SQL queries.

     

    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: 23-Sep-2019
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Implementing RFID with Voyager
      • Import an External Table using an Excel File into Voyager Prepackaged Access Reports
    • 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