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 Description DatamartContext.Query
DatamartContext.Query. having(Filter... filters)
Adds genericFilter
s 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(Filter... filters)
Adds genericFilter
s 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)
Methods in net.pricefx.formulaengine with parameters of type DatamartContext.Query Modifier and Type Method 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 givenDatamartContext.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)
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 givenDatamartContext.Query
and return so that it can be examined one row at the time.
-