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