Queries Overview

Any one in your organization that is familiar with SQL and writing database queries can write a query to retrieve data from the Accolade database. However, only Administrators and Process Designers can add those queries to Accolade for use in metrics, charts and reports.

Note:   Although a working knowledge of SQL is required to formulate complex queries, you may be able to gather the information needed with a basic query, or by using the available reporting features with Accolade.

Queries select data from reporting views, which map data into logical groupings by concept, such as projects or classes. For information about the reporting types, see Reporting Views Overview. Each reporting view and its contents is listed in Project Reporting Views (RVP_) Reference and Non-Project Reporting Views (RV_) Reference. You can also create and preview the following query:

SELECT * from RV_ReportingViews

See the following to get started:

• Writing Successful Database Queries
• Query Examples
• Adding Database Queries