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?