SQL Views allow users to retrieve data directly from the relational database that powers ACE. A view combines data from one or more underlying database tables and presents it as a single, queryable structure.
Views provide a stable interface for reporting and are commonly used when creating SQL Reports in ACE.
How to Locate SQL Views:
To locate ACE SQL views, follow these steps:
Go to Help → Layout → SQL Views
Download the file
Each sheet in the downloaded file represents a SQL view and lists the available columns and data types for that view.
Image Displays Menu Navigation
For more information about writing SQL queries in ACE, see Common Syntax: SQL.