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 



Other Data Tools:

  • Using the Custom Report Builder is a far easier way to output program involvement and other sub groups.
  • Analytics is another friendlier way to dig in to data. You can drill down by any other sub group far easier than having to be adept at a query language.
  • SQL queries & SQL views used to depict a lot of relational data on one line:

Aeries Query Expansion through SQL views:

https://support.aeries.com/solution/articles/14000092446-aeries-query-expansion-through-sql-views

Link to SQL Query:  https://support.aeries.com/solution/articles/14000082583-dynamic-sql-queries-to-provide-a-rich-one-line-result-of-whatever-unique-programs-and-or-authorizatio



Related Documentation

Aeries Table Relations

Database Table Information Report

Tables and Fields Icon

Database Definitions
Extended Fields

Advanced Query

Advanced Query - Secondary Examples

Query SKIP or KEEP

Query Change

Query Letter

Query Labels

Query Envelopes
Sample Queries/Query Banks

Aeries Query Expansion Through SQL Views


Related Videos

Query Math Functions Video

Query Change Button Video