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)
DatamartContext.Query	DatamartContext.newQuery(DatamartContext.Query query1, DatamartContext.Query query2, LinkedHashMap<String,String> joinFieldsMap, boolean rollup)
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.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) Adds a condition to the query's WHERE clause.
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
Table	DatamartContext.createDWTableFromQuery(String tableName, DatamartContext.Query query)
DatamartQueryResult	DatamartContext.executeQuery(DatamartContext.Query query) Executes the given DatamartContext.Query.
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)
DatamartContext.Query	DatamartContext.newQuery(DatamartContext.Query query1, DatamartContext.Query query2, LinkedHashMap<String,String> joinFieldsMap, boolean rollup)
StreamResults	DatamartContext.streamQuery(DatamartContext.Query query) Executes the given DatamartContext.Query and return so that it can be examined one row at the time.