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

Packages that use DatamartContext.Query

Package	Description
net.pricefx.formulaengine	Formula engine interfaces exposed to Groovy logics.
net.pricefx.formulaengine.optimization	Model contexts of the price optimization module.

Uses of DatamartContext.Query in net.pricefx.formulaengine

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

Modifier and Type	Method	Description
DatamartContext.Query	ModelFormulaContext.getSourceQuery()
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)	Deprecated. Use PublicGroovyAPI.queryApi() to query PA data instead
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)	Deprecated. Use PublicGroovyAPI.queryApi() to query PA data instead
DatamartContext.Query	DatamartContext.newQuery(DatamartContext.Table table, boolean rollup)	Deprecated. Use PublicGroovyAPI.queryApi() to query PA data instead
DatamartContext.Query	DatamartContext.newQueryFromQueryFilterBuilder(Map<String,Object> queryBuilderState, Map<String,Object> filterBuilderState)	When combining a Query Builder and a Query Filter this method returns the selected source query with the filter already applied in the where(Filter...) clause.
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 expression)	Adds a projection to the query.
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.setAlias(String alias)
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 Filters to the query's WHERE clause.
DatamartContext.Query	DatamartContext.Query.where(Object parts)	Adds a condition 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)	Adds a condition to the query's WHERE clause.

Methods in net.pricefx.formulaengine that return types with arguments of type DatamartContext.Query

Modifier and Type	Method	Description
LinkedHashMap<String,DatamartContext.Query>	DatamartContext.newQueriesFromQueryBuilder(Map<String,Object> builderState)	Gets all Query Builder source series, ordered as configured in the UI (i.e., ordered as in the provided builderState).

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

Modifier and Type	Method	Description
DatamartContext.SqlQuery	DatamartContext.SqlQuery.addSource(DatamartContext.Query sourceQuery)	Deprecated. Adds a DatamartContext.Query as a source for this SQL query.
DatamartContext.SqlQuery	DatamartContext.SqlQuery.addSource(DatamartContext.Query sourceQuery, String alias)	Deprecated. Adds a DatamartContext.Query as a source for this SQL query.
ResultPAQuery	DatamartContext.buildQuery(DatamartContext.Query query)	EXPERIMENTAL: Not all aspects and properties of a query are supported.
void	DatamartContext.consumeData(DatamartContext.Query query, Closure<?> consumer)	Deprecated. Use DatamartContext.streamQuery(Query) instead because of the limitation described above.
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)	Deprecated. Use PublicGroovyAPI.queryApi() to query PA data instead
DatamartContext.Query	DatamartContext.newQuery(DatamartContext.Query otherQuery)	Deprecated. Use PublicGroovyAPI.queryApi() to query PA data instead
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)	Deprecated. use PublicGroovyAPI.queryApi() with Exprs.max(Expression), Exprs.min(Expression), Exprs.countAll(), Exprs.countNonNull(Expression), etc. to compute profile data.
void	ModelFormulaContext.setSourceQuery(DatamartContext.Query query)
StreamResults	DatamartContext.streamQuery(DatamartContext.Query query)	Deprecated. Use PublicGroovyAPI.queryApi() to query PA data instead

Uses of DatamartContext.Query in net.pricefx.formulaengine.optimization

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

Modifier and Type	Method	Description
long	ModelFormulaContextReadWrite.loadTable(DatamartContext.Table table, DatamartContext.Query query, boolean truncate)	Deprecated. use ModelFormulaContextReadWrite.loadTable(DatamartContext.Table, PipelineStage, boolean) instead
long	ModelParallelCalculationFormulaItemContext.loadTable(DatamartContext.Table table, DatamartContext.Query query)	Deprecated. use ModelParallelCalculationFormulaItemContext.loadTable(DatamartContext.Table, PipelineStage, boolean) instead