PA Query (SQL) Aggregate Functions

Here is an overview of available options when working with PriceAnalyzer queries:

• Here are all the functions which can be used for DatamartContext.executeQuery​().

• Other related objects and functions for DatamartContext are described in API documentation. 

• You can also use DatamartContext.executeSqlQuery() where you typically have to provide the full SQL command which starts with "SELECT", as shown in Datamart/PriceAnalyzer Functions.

  • When you write your own SQL query, you need to know that the backend stores the data in a PostgreSQL database where the following functions are supported: https://www.postgresql.org/docs/9.4/functions-aggregate.html.

Note also the changes in how Integer in PriceAnalyzer is treated since Vesper 6.0.