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	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()	Builds an expression computing the number of aggregated rows.
Expression	Exprs.count(Expression e)	Builds an expression computing the number of aggregated non-null values of the given expression.
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	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)	Builds an expression evaluating if this expression is equal to the given datetime object.
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.
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)	Builds an expression evaluating if this expression is equal to the given datetime object.
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.
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	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)	Builds an expression evaluating if this expression is greater than or equal to the given datetime object.
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)	Builds an expression evaluating if this expression is strictly greater than the given datetime object.
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	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)	Builds an expression evaluating if this expression is lower than or equal to the given datetime object.
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)	Builds an expression evaluating if this expression is strictly lower than the given datetime object.
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	Exprs.min(Expression e)	Builds an expression computing the value of the aggregated minimum of a given expression.
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)	Builds an expression evaluating if this expression is not equal to the given datetime object.
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.
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)	Builds an expression evaluating if this expression is not equal to the given datetime object.
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.
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	Exprs.nullIf(Expression... exprs)	Builds an expression that will computes the standard SQL function NULLIF applied to the given expressions.
Expression	Exprs.or(Expression... exprs)	Builds the logical disjunction of the given expressions.
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	Exprs.real(BigDecimal value)	Builds a literal real expression.
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	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	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)	Builds an expression computing the number of aggregated non-null values of the given expression.
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.
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	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	Exprs.min(Expression e)	Builds an expression computing the value of the aggregated minimum of a given expression.
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	Exprs.nullIf(Expression... exprs)	Builds an expression that will computes the standard SQL function NULLIF applied to the given expressions.
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.
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.

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.