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

Packages that use DatamartContext.Query

Package	Description
net.pricefx.formulaengine	Provides Formula Engine API classes.
net.pricefx.formulaengine.optimization

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)	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.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)	Adds a DatamartContext.Query as a source for this SQL query.
DatamartContext.SqlQuery	DatamartContext.SqlQuery.addSource(DatamartContext.Query sourceQuery, String alias)	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)	Executes the given DatamartContext.Query.
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.DataProfilerResult	DatamartContext.profileData(DatamartContext.Query query)	Calculates "Min", "Max", "#", "#Nulls", "#Distinct", "Sample" for dimension projections, and "Min", "Max", "Mean", "Std", "#", "#Nulls" for numeric projections.
void	ModelFormulaContext.setSourceQuery(DatamartContext.Query query)
StreamResults	DatamartContext.streamQuery(DatamartContext.Query query)	Executes the given DatamartContext.Query and returns a result, so that one row at the time can be examined.

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)	Sample code:
long	ModelParallelCalculationFormulaItemContext.loadTable(DatamartContext.Table table, DatamartContext.Query query)	Sample code: