How do I create an Ad Hoc Query in AccuCampus?

How do I create an Ad Hoc Query in AccuCampus?

NOTE: This article explains how to navigate to and use the features of Ad Hoc Queries within AccuCampus; however, it does not explain how to write an Ad Hoc Query. A basic knowledge of the SQL language is needed to create queries. This feature is only available to those roles with permission. 

1. On the Main Sidebar, hover over Institutional Research.




2. Click on Ad Hoc Queries.




3. To create a new Ad Hoc Query, click on New Query.




4. A pop up box will appear with several options. Either select one of the three canned queries, which can be modified, or select New Blank Query to create a query from scratch.




5. Use the SQL language to modify or design a new query.




6. A list of database tables is available on the right side of the screen to assist with your query. Click on the table needed to see the individual tokens available for that table.




7. If the query will be run again, enter a name for the query.




8. To run the query, click Execute. To save and run the query, click Save and Execute. To save the query to run later, click Save.




9. Once the query is run, the results can be downloaded as a CSV.




10. From the main page, the following options are available for all saved queries.



10a. To view a chronological record of the executions of all saved queries, click View Executions.




10b. To execute a specific saved query, click Execute.



10c. To view a chronological record of all executions for a specific saved query, click View Executions.



10d. To delete a specific saved query, click Delete.




    • Related Articles

    • AccuCampus Ad Hoc Queries FAQ

      AccuCampus Ad Hoq Queries FAQ What is an Ad Hoc Query?:  Ad Hoq Queries allow you to design your own reports using data within AccuCampus. The Ad Hoc Query only pull data from AccuCampus, and produce the results as a CSV file. Basic knowledge of SQL ...

    • AccuCampus Ad Hoc Reports FAQ

      AccuCampus Ad Hoq Reports FAQ What is an Ad Hoc Report?:  Ad Hoq Reports allow for customizable graphical interfaces, and can connect AccuCampus data with data from other silos, such as an Oracle database. Basic knowledge of Amazon Quicksight is ...

    • Module 14 - Reports in AccuCampus

      Module 14: Reports in AccuCampus Topic: Reports Canned Reports  Memorizing Reports Scheduling Reports Using Reports to Add/Remove Tags Using Reports to Create User Groups Ad Hoc Queries Ad Hoc Reports Reports AccuCampus offers over 30 canned reports ...

    • AccuCampus Reports Guide

      AccuCampus Reports Guide Event Reports To get to the reports related to events, from the Main Sidebar navigate to General > Reports.  Event Registration and Attendance This report shows the registration and attendance information for a specific event ...

    • Permissions Table for AccuCampus

      Permissions Table API Name Name Description General This category gives users the ability to import and/or export data into AccuCampus. Generally, only account administrators. These settings are global settings and are not governed by scope. ...