Session Description
In the “Advanced Query,” participants delve into complex queries and gain and understanding of Aeries Table Relations. This session is designed to provide valuable tips for crafting complex queries and utilizing the Database Table Information Report or Tables and Fields Descriptions effectively.
Session Content
In this session, participants will:
Acquire an understanding of the process for building complex query statements and applying math operations
Discover the concepts of using dates and distinguishing between null and blank values in a query
Comprehend how to compare the Change Button and Change Command in Aeries, and learn how to export data from Aeries to a file
Master advanced query skills to retrieve and analyze data efficiently in Aeries
Troubleshoot and apply strategies to address query errors effectively
Related Documentation
Database Table Information Report
Database Definitions
Extended Fields
Advanced Query - Secondary Examples
Query Envelopes
Sample Queries/Query Banks
Aeries Query Expansion Through SQL Views