Working with the SQL Template Designer > Steps to Create SQL Templates
  
Version 10.2.01P10
Steps to Create SQL Templates
Use the SQL Template Designer to create custom reports by developing SQL (Structured Query Language) queries to tap into the APTARE IT Analytics database. See SQL Template Designer Overview. Also, visit the Report Library for additional report template examples:
http://reportlibrary.aptare.com/
This section includes details for the following SQL Template Designer options and features:
Create a SQL Template
Configure SQL Template Scope Selector Components
Construct the SQL Query
Help for Database Views
Accessing the Published Database Views from the CLI
Special Characters in SQL Queries
Sample SQL Queries
Use Functions in Queries
Format the SQL Template Output
Use Functions in Queries
Save and Share Report Templates
Advanced SQL Report Template Options
Creating Mouse-over Hovers
Exporting/Importing SQL Templates