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.