DatamartContext.Query |
ModelFormulaContext.getSourceQuery() |
|
DatamartContext.Query |
DatamartContext.Query.having(Filter... filters) |
Adds generic Filter s to the query's HAVING clause.
|
DatamartContext.Query |
DatamartContext.Query.having(String... havingClauses) |
Parses and ANDs one or more SQL-like conditions to the query's HAVING clause.
|
DatamartContext.Query |
DatamartContext.newQuery(DatamartContext.Query otherQuery) |
Creates a new query from an existing one.
|
DatamartContext.Query |
DatamartContext.newQuery(DatamartContext.Query query1,
DatamartContext.Query query2,
LinkedHashMap<String,String> joinFieldsMap) |
Deprecated.
|
DatamartContext.Query |
DatamartContext.newQuery(DatamartContext.Query query1,
DatamartContext.Query query2,
LinkedHashMap<String,String> joinFieldsMap,
boolean rollup) |
Deprecated.
|
DatamartContext.Query |
DatamartContext.newQuery(DatamartContext.Query query1,
DatamartContext.Query query2,
LinkedHashMap<String,String> joinFieldsMap,
String joinMode,
boolean rollup) |
Deprecated.
|
DatamartContext.Query |
DatamartContext.newQuery(DatamartContext.Table table) |
Builds a new query on the given table.
|
DatamartContext.Query |
DatamartContext.newQuery(DatamartContext.Table table,
boolean rollup) |
Builds a new query on the given table allowing you to disable a rollup aggregation.
|
DatamartContext.Query |
DatamartContext.Query.orderBy(String... orderClauses) |
Parses and adds one or more SQL-like conditions to the query's ORDER BY clause.
|
DatamartContext.Query |
DatamartContext.Query.select(String expr,
String alias) |
Adds a projection to the query.
|
DatamartContext.Query |
DatamartContext.Query.select(String expr,
String alias,
String... statistics) |
|
DatamartContext.Query |
DatamartContext.Query.selectAll() |
Returns all columns.
Note: If the rollup is set to true (see the DatamartContext.newQuery(Table) ), then only columns matching the rollup aggregation will be returned.
|
DatamartContext.Query |
DatamartContext.Query.selectAll(boolean fieldNameAsAlias) |
|
DatamartContext.Query |
DatamartContext.Query.selectCount() |
Adds a COUNT(*) projection to the query.
|
DatamartContext.Query |
DatamartContext.Query.selectDistinct() |
Equivalent to the DISTINCT option in an SQL select statement.
|
DatamartContext.Query |
DatamartContext.Query.selectId(String alias) |
Projects the internal id of a row.
|
DatamartContext.Query |
DatamartContext.Query.setMaxRows(Integer maxRows) |
Limits the number of rows returned in the query result.
|
DatamartContext.Query |
DatamartContext.Query.setOptions(Map<String,Object> options) |
Allows for a number of query tweaking options, such as setting the target currency to convert to (if applicable) and requesting
additional statistics to be calculated.
|
DatamartContext.Query |
DatamartContext.Query.setUseCache(Boolean useCache) |
Allows to disable node level PA query caching just for this query.
|
DatamartContext.Query |
DatamartContext.Query.where(Filter... filters) |
Adds generic Filter s to the query's WHERE clause.
|
DatamartContext.Query |
DatamartContext.Query.where(String... whereClauses) |
Parses and ANDs one or more SQL-like conditions to the query's WHERE clause.
|
DatamartContext.Query |
DatamartContext.Query.where(CustomerGroup customerGroup) |
Adds a CustomerGroup condition to the query's WHERE clause, for example a customer group from an InputEntry("CustomerGroup") parameter.
|
DatamartContext.Query |
DatamartContext.Query.where(ProductGroup productGroup) |
Adds a ProductGroup filter condition to the query's WHERE clause, for example a product group from an InputEntry("ProductGroup") parameter.
|
DatamartContext.Query |
DatamartContext.Query.where(DatamartContext.DataSlice slice) |
|