AccuCampus Ad Hoc Queries FAQ

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 language is required to create an Ad Hoq Query. 



How do I learn SQL?: 

The AccuCampus team is not able to provide an in-depth tutorial on SQL language for Ad Hoq Queries, but tokens are provided on the query building screen to assist with the process. For further information, we recommend the following resources:



Who should manage this feature?:
We recommend choosing an individual to manage both Ad Hoq Queries and Reports (or one person for Reports and several for Queries) who is familiar with AccuCampus and has a high enough security clearance at the institution to be able to handle sensitive data. The user or users should have training in SQL and Quicksight.



Can I save a query and return to it later?: 

Yes.



How do I see the results of a query?: 

Once the query is written, click on the “Execute” button to see the results. Queries can be saved and re-run at any time.



When should I use a query?

Ad Hoc Queries are useful when you just need raw data, or when there is not a canned report already available. The information available to be queried is limited in this function. 





    • Related Articles

    • 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 ...
    • 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 ...
    • 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. ...