Standard Queries

A Standard Query is the foundation of a Digital Process Logic package. It directly retrieves and works with data from a configured connection. Standard Queries can also serve as data sources for Aggregate Queries and Transform Queries.

note

For optimal performance, it is recommended to perform filtering and built-in function operations within Standard Queries, especially when working with large datasets. Processing at the Standard Query level is handled by the underlying data source, resulting in more efficient query execution.An Aggregate Query is used to combine data from multiple queries or tables into a single result set.