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

Packages that use DatamartContext.SqlQuery

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

Uses of DatamartContext.SqlQuery in net.pricefx.formulaengine

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

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.
DatamartContext.SqlQuery	DatamartContext.SqlQuery.addSource(DatamartContext.Table table)	Adds a DatamartContext.Table as a source for this SQL query.
DatamartContext.SqlQuery	DatamartContext.SqlQuery.addSource(DatamartContext.Table table, String alias)	Adds a DatamartContext.Table as a source for this SQL query.
DatamartContext.SqlQuery	DatamartContext.SqlQuery.addWith(String withClause, Object... bindings)	Adds a with clause to the SQL query, where every "?"
DatamartContext.SqlQuery	DatamartContext.SqlQuery.addWith(String withClause, String alias, Object... bindings)	Adds a with clause to the SQL query, where every "?"
DatamartContext.SqlQuery	DatamartContext.newJoinFromQueryBuilder(Map<String,Object> builderState)	Gets the join query defined in Query Builder source series.
DatamartContext.SqlQuery	DatamartContext.newJoinFromQueryFilterBuilder(Map<String,Object> queryBuilderState, Map<String,Object> filterBuilderState)	When combining a Query Builder and a Query Filter this method returns the join query with the filter already applied in the SQL query.
DatamartContext.SqlQuery	DatamartContext.newSqlQuery()	Instantiates a query object for building SQL statements from source queries, with clauses and parameter bindings.
DatamartContext.SqlQuery	DatamartContext.SqlQuery.setAllowUnknownFunctions(boolean allowUnknownFunctions)	Allow to use SQL functions that are not recognized by the validation.
DatamartContext.SqlQuery	DatamartContext.SqlQuery.setMaxRows(Integer maxRows)	Sets the max rows to be returned when executing the SQL query.
DatamartContext.SqlQuery	DatamartContext.SqlQuery.setQuery(String sql, Object... bindings)	Sets the main SQL SELECT clause of this query, where every "?"

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

Modifier and Type	Method	Description
Matrix2D	DatamartContext.executeSqlQuery(DatamartContext.SqlQuery sqlQuery)	Executes an ANSI compliant SQL SELECT statement in the PA DB.
StreamResults	DatamartContext.streamSqlQuery(DatamartContext.SqlQuery query)	Executes the given DatamartContext.SqlQuery and returns a result, so that one row at the time can be examined.

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

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

Modifier and Type	Method	Description
long	ModelFormulaContextReadWrite.loadTable(DatamartContext.Table table, DatamartContext.SqlQuery query, boolean truncate)	Sample code:
long	ModelParallelCalculationFormulaItemContext.loadTable(DatamartContext.Table table, DatamartContext.SqlQuery query)	Sample code: