Uses of Interface
net.pricefx.formulaengine.DatamartContext.Query

Packages that use DatamartContext.Query

Package	Description
net.pricefx.formulaengine

Uses of DatamartContext.Query in net.pricefx.formulaengine

Methods in net.pricefx.formulaengine that return DatamartContext.Query

Modifier and Type	Method and Description
DatamartContext.Query	DatamartContext.Query.having(Filter... filters) Adds generic Filters 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) Create 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(Table table)
DatamartContext.Query	DatamartContext.newQuery(Table table, boolean rollup) Build a new query on the given table.
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()
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.setMaxRows(Integer maxRows) Limits the number of rows returned in the query result.
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(DatamartContext.DataSlice slice)
DatamartContext.Query	DatamartContext.Query.where(Filter... filters) Adds generic Filters to the query's WHERE clause.
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(String... whereClauses) Parses and ANDs one or more SQL-like conditions to the query's WHERE clause.

Methods in net.pricefx.formulaengine with parameters of type DatamartContext.Query

Modifier and Type	Method and Description
ResultPAQuery	DatamartContext.buildQuery(DatamartContext.Query query) EXPERIMENTAL: not all aspects, properties of a query or supported! For ex: currently not supported are dim filters, row limit, join queries....
Table	DatamartContext.createDWTableFromQuery(String tableName, DatamartContext.Query query)
void	TableContext.createTableFromQuery(String tableName, DatamartContext.Query query) Creates a new in-memory table - eventually dropping an already existing table with same name - based on the query definition fields.
DatamartQueryResult	DatamartContext.executeQuery(DatamartContext.Query query) Executes the given DatamartContext.Query.
Matrix2D	DatamartContext.executeSqlQuery(String sql, DatamartContext.Query... views) Executes an ANSI compliant SQL SELECT statement in the PA DB. Important note: a non-compliant statement that does not fail at the present time, may well fail in future releases. The DB schema that can be queried is constructed on the fly by means of view definitions.
DatamartContext.Query	DatamartContext.newQuery(DatamartContext.Query otherQuery) Create 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.DataProfilerResult	DatamartContext.profileData(DatamartContext.Query query) Calculates "Min", "Max", "#", "#Nulls", "#Distinct", "Sample" for dimension projections, and "Min", "Max", "Mean", "Std", "#", "#Nulls" for numeric projections.
StreamResults	DatamartContext.streamQuery(DatamartContext.Query query) Executes the given DatamartContext.Query and return so that it can be examined one row at the time.