Uses of Interface
net.pricefx.formulaengine.scripting.queryapi.Expression

Packages that use Expression

Package	Description
net.pricefx.formulaengine.scripting.queryapi

Uses of Expression in net.pricefx.formulaengine.scripting.queryapi

Subinterfaces of Expression in net.pricefx.formulaengine.scripting.queryapi

Modifier and Type	Interface	Description
interface	SelectableExpression	An object which represents a QueryApi Expression and which can be part of the output or input of a PipelineStage as it is also Selectable

Methods in net.pricefx.formulaengine.scripting.queryapi that return Expression

Modifier and Type	Method	Description
Expression	Exprs.abs(Long e)	Builds an expression computing the absolute value of the given value.
Expression	Exprs.abs(BigDecimal e)	Builds an expression computing the absolute value of the given value.
Expression	Exprs.abs(Expression e)	Builds an expression computing the absolute value of the given value.
Expression	Exprs.and(Expression... exprs)	Builds the logical conjunction of the given expressions.
Expression	Exprs.avg(Expression e)	Builds an expression computing the value of the aggregated average of a given expression.
Expression	WindowFunction.avg(Expression expression)	Builds a window function computing the average of the given expression over the frame.
Expression	Exprs.bool(Boolean value)	Builds a literal boolean expression.
Expression	Exprs.caseWhen(Expression condition, Expression thenExpr, Expression elseExpr)	Builds a conditional CASE WHEN expression.
Expression	Expression.castAsBoolean()	Builds an expression that cast this expression to a boolean value.
Expression	Expression.castAsDateOnly()	Builds an expression that cast this expression to a date only value.
Expression	Expression.castAsDateTime()	Builds an expression that cast this expression to a datetime value.
Expression	Expression.castAsInteger()	Builds an expression that cast this expression to an integer value.
Expression	Expression.castAsReal()	Builds an expression that cast this expression to a real number value.
Expression	Expression.castAsString()	Builds an expression that cast this expression to a string value.
Expression	Exprs.coalesce(Expression... exprs)	Builds an expression that will return the value of the first non-null resulting given expression.
Expression	Expression.concat(String e)	Builds an expression that concatenates this expression to a given value.
Expression	Expression.concat(Expression e)	Builds an expression that concatenates this expression to a given value.
Expression	Exprs.count()	Deprecated. use Exprs.countAll() instead
Expression	Exprs.count(Expression e)	Deprecated. use Exprs.countNonNull(Expression) or Exprs.countDistinctNonNull(Expression) instead
Expression	Exprs.countAll()	Builds an expression computing the number of aggregated rows.
Expression	WindowFunction.countAll()	Builds a window function computing the number of rows into the frame.
Expression	Exprs.countDistinctNonNull(Expression expr)	Builds an expression computing the number of distinct non-null value for the given expression.
Expression	Exprs.countNonNull(Expression e)	Builds an expression computing the number of rows having a non-null value for the given expression.
Expression	WindowFunction.countNonNull(Expression expression)	Builds a window function computing the number of non-null expression value over the frame.
Expression	WindowFunction.cumeDist()	Builds a window function computing the cumulative distribution, that is (number of partition rows preceding or peers with current row) / (total partition rows).
Expression	Exprs.dateOnly(LocalDate dateOnly)	Builds a literal date expression from a LocalDate object.
Expression	Exprs.dateOnly(Date dateOnly)	Builds a literal date expression from a Date object ignoring all time related values.
Expression	Exprs.dateTime(Date dateTime)	Builds a literal datetime expression from a Date object.
Expression	Exprs.dateTime(DateTime dateTime)	Builds a literal datetime expression from a DateTime object.
Expression	WindowFunction.denseRank()	Builds a window function computing the rank of the current row, without gaps; this function effectively counts peer groups.
Expression	Expression.div(Number e)	Builds an expression that computes the value of this expression divided by the given value.
Expression	Expression.div(Expression e)	Builds an expression that computes the value of this expression divided by the given value.
Expression	Expression.equal(Boolean e)	Builds an expression evaluating if this expression is equal to the given boolean.
Expression	Expression.equal(Number e)	Builds an expression evaluating if this expression is equal to the given number.
Expression	Expression.equal(String e)	Builds an expression evaluating if this expression is equal to the given String.
Expression	Expression.equal(LocalDate dateWithoutTime)	Builds an expression evaluating if this expression is equal to the given date object.
Expression	Expression.equal(Date datetime)	Deprecated. Date object is too ambiguous, instead use equal(Expression) with Exprs.dateOnly(Date) or Exprs.dateTime(Date) as argument.
Expression	Expression.equal(Expression e)	Builds an expression evaluating if this expression is equal to the given expression.
Expression	Expression.equal(DateTime datetime)	Builds an expression evaluating if this expression is equal to the given datetime object.
<T extends Enum<T>> Expression	Expression.equal(T e)	Builds an expression evaluating if this expression is equal to the given enum.
Expression	Expression.equalNullAware(Boolean e)	Builds an expression evaluating if this expression is equal to the given boolean.
Expression	Expression.equalNullAware(Number e)	Builds an expression evaluating if this expression is equal to the given number.
Expression	Expression.equalNullAware(String e)	Builds an expression evaluating if this expression is equal to the given String.
Expression	Expression.equalNullAware(LocalDate dateWithoutTime)	Builds an expression evaluating if this expression is equal to the given date object.
Expression	Expression.equalNullAware(Date datetime)	Deprecated. Date object is too ambiguous, instead use equalNullAware(Expression) with Exprs.dateOnly(Date) or Exprs.dateTime(Date) as argument.
Expression	Expression.equalNullAware(Expression e)	Builds an expression evaluating if this expression is equal to the given expression.
Expression	Expression.equalNullAware(DateTime datetime)	Builds an expression evaluating if this expression is equal to the given datetime object.
<T extends Enum<T>> Expression	Expression.equalNullAware(T e)	Builds an expression evaluating if this expression is equal to the given enum object.
Expression	Exprs.exp(Long e)	Builds an expression computing the value of the exponential function applied to the given value.
Expression	Exprs.exp(BigDecimal e)	Builds an expression computing the value of the exponential function applied to the given value.
Expression	Exprs.exp(Expression e)	Builds an expression computing the value of the exponential function applied to the given value.
Expression	WindowFunction.firstValue(Expression expression)	Builds a window function computing the value evaluated at the row that is the first row of the window frame.
Expression	Exprs.fromDataSlice(Tables.Columns columns, DatamartContext.DataSlice dataSlice)	Translates a PA DatamartContext.DataSlice into a query api Expression.
Expression	Expression.greaterOrEqual(Number e)	Builds an expression evaluating if this expression is greater than or equal to the given number.
Expression	Expression.greaterOrEqual(LocalDate dateWithoutTime)	Builds an expression evaluating if this expression is greater than or equal to the given date object.
Expression	Expression.greaterOrEqual(Date datetime)	Deprecated. Date object is too ambiguous, instead use greaterOrEqual(Expression) with Exprs.dateOnly(Date) or Exprs.dateTime(Date) as argument.
Expression	Expression.greaterOrEqual(Expression e)	Builds an expression evaluating if this expression is greater than or equal to the given expression.
Expression	Expression.greaterOrEqual(DateTime datetime)	Builds an expression evaluating if this expression is greater than or equal to the given datetime object.
Expression	Expression.greaterThan(Number e)	Builds an expression evaluating if this expression is strictly greater than the given number.
Expression	Expression.greaterThan(LocalDate dateWithoutTime)	Builds an expression evaluating if this expression is strictly greater than the given date object.
Expression	Expression.greaterThan(Date datetime)	Deprecated. Date object is too ambiguous, instead use greaterThan(Expression) with Exprs.dateOnly(Date) or Exprs.dateTime(Date) as argument.
Expression	Expression.greaterThan(Expression e)	Builds an expression evaluating if this expression is strictly greater than the given expression.
Expression	Expression.greaterThan(DateTime datetime)	Builds an expression evaluating if this expression is strictly greater than the given datetime object.
Expression	Expression.ilike(String e)	Builds an expression evaluating if this expression is matching the standard SQL LIKE pattern provided by the given value.
Expression	Expression.ilike(Expression e)	Builds an expression evaluating if this expression is matching the standard SQL LIKE pattern provided by the given value.
Expression	Expression.in(List<?> e)	Builds an expression evaluating if this expression is equal to any of the element of the given list.
Expression	Exprs.integer(Long value)	Builds a literal integer expression.
Expression	Expression.isFalse()	Builds an expression evaluating if this expression is false.
Expression	Expression.isNotNull()	Builds an expression evaluating if this expression is not null.
Expression	Expression.isNull()	Builds an expression evaluating if this expression is null.
Expression	Expression.isTrue()	Builds an expression evaluating if this expression is true.
Expression	WindowFunction.lag(Expression expression, Expression offset, Expression defaultValue)	Builds a window function computing value evaluated at the row that is offset rows before the current row within the partition; if there is no such row, instead returns default (which must be of a type compatible with value).
Expression	WindowFunction.lastValue(Expression expression)	Builds a window function computing the value evaluated at the row that is the last row of the window frame.
Expression	WindowFunction.lead(Expression expression, Expression offset, Expression defaultValue)	Builds a window function computing value evaluated at the row that is offset rows after the current row within the partition; if there is no such row, instead returns default (which must be of a type compatible with value).
Expression	Expression.length()	Builds an expression that computes the lenght of this expression as a String.
Expression	Expression.lessOrEqual(Number e)	Builds an expression evaluating if this expression is lower than or equal to the given number.
Expression	Expression.lessOrEqual(LocalDate dateWithoutTime)	Builds an expression evaluating if this expression is lower than or equal to the given date object.
Expression	Expression.lessOrEqual(Date datetime)	Deprecated. Date object is too ambiguous, instead use lessOrEqual(Expression) with Exprs.dateOnly(Date) or Exprs.dateTime(Date) as argument.
Expression	Expression.lessOrEqual(Expression e)	Builds an expression evaluating if this expression is lower than or equal to the given expression.
Expression	Expression.lessOrEqual(DateTime datetime)	Builds an expression evaluating if this expression is lower than or equal to the given datetime object.
Expression	Expression.lessThan(Number e)	Builds an expression evaluating if this expression is strictly lower than the given number.
Expression	Expression.lessThan(LocalDate dateWithoutTime)	Builds an expression evaluating if this expression is strictly lower than the given date object.
Expression	Expression.lessThan(Date datetime)	Deprecated. Date object is too ambiguous, instead use lessThan(Expression) with Exprs.dateOnly(Date) or Exprs.dateTime(Date) as argument.
Expression	Expression.lessThan(Expression e)	Builds an expression evaluating if this expression is strictly lower than the given expression.
Expression	Expression.lessThan(DateTime datetime)	Builds an expression evaluating if this expression is strictly lower than the given datetime object.
Expression	Expression.like(String e)	Builds an expression evaluating if this expression is matching the standard SQL LIKE pattern provided by the given value.
Expression	Expression.like(Expression e)	Builds an expression evaluating if this expression is matching the standard SQL LIKE pattern provided by the given value.
Expression	Expression.locate(String needle)	Builds an expression that computes the first position (1-based index) of the given String in this expression.
Expression	Expression.locate(Expression needle)	Builds an expression that computes the first position (1-based index) of the given String in this expression.
Expression	Expression.lower()	Builds an expression that computes a lower case version of this expression.
Expression	Exprs.max(Expression e)	Builds an expression computing the value of the aggregated maximum of a given expression.
Expression	WindowFunction.max(Expression expression)	Builds a window function computing the maximum of the given expression over the frame.
Expression	Exprs.min(Expression e)	Builds an expression computing the value of the aggregated minimum of a given expression.
Expression	WindowFunction.min(Expression expression)	Builds a window function computing the minimum of the given expression over the frame.
Expression	Expression.minus(Number e)	Builds an expression that computes the value of this expression minus the given value.
Expression	Expression.minus(Expression e)	Builds an expression that computes the value of this expression minus the given value.
Expression	Expression.mod(Number e)	Builds an expression that computes the value of the remainder of the Euclidean division of this expression by the given value.
Expression	Expression.mod(Expression e)	Builds an expression that computes the value of the remainder of the Euclidean division of this expression by the given value.
Expression	Expression.multiply(Number e)	Builds an expression that computes the value of this expression multiplied by the given value.
Expression	Expression.multiply(Expression e)	Builds an expression that computes the value of this expression multiplied by the given value.
Expression	Exprs.not(Expression e)	Builds the logical negation of the given expression
Expression	Expression.notEqual(Boolean e)	Builds an expression evaluating if this expression is not equal to the given boolean.
Expression	Expression.notEqual(Number e)	Builds an expression evaluating if this expression is not equal to the given number.
Expression	Expression.notEqual(String e)	Builds an expression evaluating if this expression is not equal to the given String.
Expression	Expression.notEqual(LocalDate dateWithoutTime)	Builds an expression evaluating if this expression is not equal to the given date object.
Expression	Expression.notEqual(Date datetime)	Deprecated. Date object is too ambiguous, instead use notEqual(Expression) with Exprs.dateOnly(Date) or Exprs.dateTime(Date) as argument.
Expression	Expression.notEqual(Expression e)	Builds an expression evaluating if this expression is not equal to the given expression.
Expression	Expression.notEqual(DateTime datetime)	Builds an expression evaluating if this expression is not equal to the given datetime object.
<T extends Enum<T>> Expression	Expression.notEqual(T e)	Builds an expression evaluating if this expression is not equal to the given enum.
Expression	Expression.notEqualNullAware(Boolean e)	Builds an expression evaluating if this expression is not equal to the given boolean.
Expression	Expression.notEqualNullAware(Number e)	Builds an expression evaluating if this expression is not equal to the given number.
Expression	Expression.notEqualNullAware(String e)	Builds an expression evaluating if this expression is not equal to the given String.
Expression	Expression.notEqualNullAware(LocalDate dateWithoutTime)	Builds an expression evaluating if this expression is not equal to the given date object.
Expression	Expression.notEqualNullAware(Date datetime)	Deprecated. Date object is too ambiguous, instead use notEqualNullAware(Expression) with Exprs.dateOnly(Date) or Exprs.dateTime(Date) as argument.
Expression	Expression.notEqualNullAware(Expression e)	Builds an expression evaluating if this expression is not equal to the given expression.
Expression	Expression.notEqualNullAware(DateTime datetime)	Builds an expression evaluating if this expression is not equal to the given datetime object.
<T extends Enum<T>> Expression	Expression.notEqualNullAware(T e)	Builds an expression evaluating if this expression is not equal to the given enum.
Expression	Expression.notIlike(String e)	Builds an expression evaluating if this expression is not matching the standard SQL LIKE pattern provided by the given value.
Expression	Expression.notIlike(Expression e)	Builds an expression evaluating if this expression is not matching the standard SQL LIKE pattern provided by the given value.
Expression	Expression.notIn(List<?> e)	Builds an expression evaluating if this expression not equal to all the element of the given list.
Expression	Expression.notLike(String e)	Builds an expression evaluating if this expression is not matching the standard SQL LIKE pattern provided by the given value.
Expression	Expression.notLike(Expression e)	Builds an expression evaluating if this expression is not matching the standard SQL LIKE pattern provided by the given value.
Expression	WindowFunction.nthValue(Expression expression, Expression offset)	Builds a window function computing the value evaluated at the row that is the n'th row of the window frame (counting from 1); returns NULL if there is no such row.
Expression	WindowFunction.ntile(Expression expression)	Builds a window function computing an integer ranging from 1 to the argument value, dividing the partition as equally as possible.
Expression	Exprs.nullIf(Expression e1, Expression e2)	Builds an expression that will return NULL if both arguments are equal, otherwise return the first one.
Expression	Exprs.or(Expression... exprs)	Builds the logical disjunction of the given expressions.
Expression	WindowFunction.percentRank()	Builds a window function computing the relative rank of the current row, that is (rank - 1) / (total partition rows - 1).
Expression	Expression.plus(Number e)	Builds an expression that computes the value of this expression plus the given value.
Expression	Expression.plus(Expression e)	Builds an expression that computes the value of this expression plus the given value.
Expression	WindowFunction.rank()	Builds a window function computing the rank of the current row, with gaps; that is, the row_number of the first row in its peer group.
Expression	Exprs.real(BigDecimal value)	Builds a literal real expression.
Expression	WindowFunction.rowNumber()	Builds a window function computing the number of the current row within its partition, counting from 1
Expression	Exprs.string(String value)	Builds a literal string expression.
Expression	Expression.substring(int fromIndex, int length)	Builds an expression that computes a substring of this expression value.
Expression	Expression.substring(Expression fromIndex, Expression length)	Builds an expression that computes a substring of this expression value.
Expression	Exprs.sum(Expression e)	Builds an expression computing the value of the aggregated sum of a given expression.
Expression	WindowFunction.sum(Expression expression)	Builds a window function computing the sum of the given expression over the frame.
Expression	Expression.trim()	Builds an expression that computes this expression without any starting or ending white space characters.
Expression	Expression.upper()	Builds an expression that computes an upper case version of this expression.

Methods in net.pricefx.formulaengine.scripting.queryapi with parameters of type Expression

Modifier and Type	Method	Description
Expression	Exprs.abs(Expression e)	Builds an expression computing the absolute value of the given value.
Expression	Exprs.and(Expression... exprs)	Builds the logical conjunction of the given expressions.
Orders.Order	Orders.ascNullsFirst(Expression e)	Builds an ascending order with nulls values evaluated as the lowest value.
Orders.Order	Orders.ascNullsLast(Expression e)	Builds an ascending order with nulls values evaluated as the highest value.
Expression	Exprs.avg(Expression e)	Builds an expression computing the value of the aggregated average of a given expression.
Expression	WindowFunction.avg(Expression expression)	Builds a window function computing the average of the given expression over the frame.
Expression	Exprs.caseWhen(Expression condition, Expression thenExpr, Expression elseExpr)	Builds a conditional CASE WHEN expression.
Expression	Exprs.coalesce(Expression... exprs)	Builds an expression that will return the value of the first non-null resulting given expression.
Expression	Expression.concat(Expression e)	Builds an expression that concatenates this expression to a given value.
Expression	Exprs.count(Expression e)	Deprecated. use Exprs.countNonNull(Expression) or Exprs.countDistinctNonNull(Expression) instead
Expression	Exprs.countDistinctNonNull(Expression expr)	Builds an expression computing the number of distinct non-null value for the given expression.
Expression	Exprs.countNonNull(Expression e)	Builds an expression computing the number of rows having a non-null value for the given expression.
Expression	WindowFunction.countNonNull(Expression expression)	Builds a window function computing the number of non-null expression value over the frame.
Orders.Order	Orders.descNullsFirst(Expression e)	Builds a descending order with nulls values evaluated as the lowest value.
Orders.Order	Orders.descNullsLast(Expression e)	Builds a descending order with nulls values evaluated as the highest value.
Expression	Expression.div(Expression e)	Builds an expression that computes the value of this expression divided by the given value.
Expression	Expression.equal(Expression e)	Builds an expression evaluating if this expression is equal to the given expression.
Expression	Expression.equalNullAware(Expression e)	Builds an expression evaluating if this expression is equal to the given expression.
Expression	Exprs.exp(Expression e)	Builds an expression computing the value of the exponential function applied to the given value.
WindowFunction	WindowFunction.filter(Expression filter)	Defines a filter to be applied only on the window function.
Expression	WindowFunction.firstValue(Expression expression)	Builds a window function computing the value evaluated at the row that is the first row of the window frame.
Expression	Expression.greaterOrEqual(Expression e)	Builds an expression evaluating if this expression is greater than or equal to the given expression.
Expression	Expression.greaterThan(Expression e)	Builds an expression evaluating if this expression is strictly greater than the given expression.
Expression	Expression.ilike(Expression e)	Builds an expression evaluating if this expression is matching the standard SQL LIKE pattern provided by the given value.
Expression	WindowFunction.lag(Expression expression, Expression offset, Expression defaultValue)	Builds a window function computing value evaluated at the row that is offset rows before the current row within the partition; if there is no such row, instead returns default (which must be of a type compatible with value).
Expression	WindowFunction.lastValue(Expression expression)	Builds a window function computing the value evaluated at the row that is the last row of the window frame.
Expression	WindowFunction.lead(Expression expression, Expression offset, Expression defaultValue)	Builds a window function computing value evaluated at the row that is offset rows after the current row within the partition; if there is no such row, instead returns default (which must be of a type compatible with value).
Expression	Expression.lessOrEqual(Expression e)	Builds an expression evaluating if this expression is lower than or equal to the given expression.
Expression	Expression.lessThan(Expression e)	Builds an expression evaluating if this expression is strictly lower than the given expression.
Expression	Expression.like(Expression e)	Builds an expression evaluating if this expression is matching the standard SQL LIKE pattern provided by the given value.
Expression	Expression.locate(Expression needle)	Builds an expression that computes the first position (1-based index) of the given String in this expression.
Expression	Exprs.max(Expression e)	Builds an expression computing the value of the aggregated maximum of a given expression.
Expression	WindowFunction.max(Expression expression)	Builds a window function computing the maximum of the given expression over the frame.
Expression	Exprs.min(Expression e)	Builds an expression computing the value of the aggregated minimum of a given expression.
Expression	WindowFunction.min(Expression expression)	Builds a window function computing the minimum of the given expression over the frame.
Expression	Expression.minus(Expression e)	Builds an expression that computes the value of this expression minus the given value.
Expression	Expression.mod(Expression e)	Builds an expression that computes the value of the remainder of the Euclidean division of this expression by the given value.
Expression	Expression.multiply(Expression e)	Builds an expression that computes the value of this expression multiplied by the given value.
Expression	Exprs.not(Expression e)	Builds the logical negation of the given expression
Expression	Expression.notEqual(Expression e)	Builds an expression evaluating if this expression is not equal to the given expression.
Expression	Expression.notEqualNullAware(Expression e)	Builds an expression evaluating if this expression is not equal to the given expression.
Expression	Expression.notIlike(Expression e)	Builds an expression evaluating if this expression is not matching the standard SQL LIKE pattern provided by the given value.
Expression	Expression.notLike(Expression e)	Builds an expression evaluating if this expression is not matching the standard SQL LIKE pattern provided by the given value.
Expression	WindowFunction.nthValue(Expression expression, Expression offset)	Builds a window function computing the value evaluated at the row that is the n'th row of the window frame (counting from 1); returns NULL if there is no such row.
Expression	WindowFunction.ntile(Expression expression)	Builds a window function computing an integer ranging from 1 to the argument value, dividing the partition as equally as possible.
Expression	Exprs.nullIf(Expression e1, Expression e2)	Builds an expression that will return NULL if both arguments are equal, otherwise return the first one.
Expression	Exprs.or(Expression... exprs)	Builds the logical disjunction of the given expressions.
Expression	Expression.plus(Expression e)	Builds an expression that computes the value of this expression plus the given value.
PipelineStage	QueryApi.source(Tables.Table table, List<? extends Selectable> selectables, Expression filter)	Main entry point to start writing a query.
PipelineStage	QueryApi.source(Tables.Table table, Expression filter)	Main entry point to start writing a query.
Expression	Expression.substring(Expression fromIndex, Expression length)	Builds an expression that computes a substring of this expression value.
Expression	Exprs.sum(Expression e)	Builds an expression computing the value of the aggregated sum of a given expression.
Expression	WindowFunction.sum(Expression expression)	Builds a window function computing the sum of the given expression over the frame.

Method parameters in net.pricefx.formulaengine.scripting.queryapi with type arguments of type Expression

Modifier and Type	Method	Description
PipelineStage	PipelineStage.aggregateBy(Function<Tables.Columns,List<? extends Expression>> by, Function<Tables.Columns,List<? extends Selectable>> selectables)	Adds a stage that aggregates the outputs of this stage by a given set of expressions.
PipelineStage	PipelineStage.filter(Function<Tables.Columns,Expression> condition)	Adds a stage that only keeps this stage output rows which verify the given expression.
WindowFunction	WindowFunction.partitionBy(List<Expression> partitions)	Defines the group of rows to be processed separately.