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

Packages that use Expression

Package	Description
net.pricefx.formulaengine.scripting.queryapi	The Query API, the unified Groovy API for reading data from Pricefx.

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.acos(Expression radians)	Builds an expression computing the value of the acos function applied to the given value.
Expression	Exprs.and(Expression... exprs)	Builds the logical conjunction of the given expressions.
Expression	Exprs.asin(Expression radians)	Builds an expression computing the value of the asin function applied to the given value.
Expression	Exprs.atan(Expression radians)	Builds an expression computing the value of the atan function applied to the given value.
Expression	Exprs.atan2(Expression y, Expression x)	Builds an expression computing the value of the atan2 function applied to the given y and x values.
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.cbrt(Expression e)	Builds an expression computing the value of the cube root function applied to the given value.
Expression	Expression.ceil()	Builds an expression that will apply the ceil function to this expression.
Expression	Exprs.ceil(Expression e)	Builds an expression computing the value of the ceil function applied to the given 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.cos(Expression radians)	Builds an expression computing the value of the cos function applied to the 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 values 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.dateOnlyToday()	Builds an expression that will return the current date.
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	Exprs.dateTimeNow()	Builds an expression that will return the current date and time.
Expression	Expression.degrees()	Builds an expression that computes the degrees value of this expression.
Expression	Exprs.degrees(Expression e)	Builds an expression computing the value of the degrees function applied to the given value.
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	Exprs.duration(Duration duration)	Builds a duration literal expression from a Duration object.
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	Exprs.factorial(Expression e)	Builds an expression computing the value of the factorial 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	Expression.floor()	Builds an expression that will apply the floor function to this expression.
Expression	Exprs.floor(Expression e)	Builds an expression computing the value of the floor function applied to the given value.
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	Exprs.greatest(Expression... exprs)	Builds an expression computing the largest value from a list of any number of expressions
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)	Builds a window function computing value evaluated at the row before the current row within the partition; if there is no such row, instead returns NULL.
Expression	WindowFunction.lag(Expression expression, Expression offset)	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 NULL.
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)	Builds a window function computing value evaluated at the row after the current row within the partition; if there is no such row, instead returns NULL.
Expression	WindowFunction.lead(Expression expression, Expression offset)	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 NULL.
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	Exprs.least(Expression... exprs)	Builds an expression computing the smallest value from a list of any number of expressions
Expression	Expression.length()	Builds an expression that computes the length 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	Exprs.ln(Expression e)	Builds an expression computing the value of the ln (natural logarithm) function applied to 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	Exprs.log(Number base, Expression e)	Builds an expression computing the value of the log function applied to the given value.
Expression	Exprs.log(Expression e)	Builds an expression computing the value of the log (base 10) function applied to the given value.
Expression	Exprs.log(Expression base, Expression e)	Builds an expression computing the value of the log function applied to the given value.
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(Duration d)	Builds an expression that computes the value of this expression minus the given duration.
Expression	Expression.minus(Period p)	Builds an expression that computes the value of this expression minus the given Period.
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	Exprs.percentileCont(Number fraction, Expression sortBy)	Builds an expression computing the value of the continuous percentile corresponding to the specified fraction, interpolating between adjacent input items if needed.
Expression	Exprs.percentileDisc(Number fraction, Expression sortBy)	Builds an expression computing the value of the discrete percentile: the first input value whose position in the ordering equals or exceeds the specified fraction.
Expression	Exprs.percentRank(Expression expression, Expression sortBy)	Builds an expression computing the relative rank of a value
Expression	WindowFunction.percentRank()	Builds a window function computing the relative rank of the current row, that is (rank - 1) / (total partition rows - 1).
Expression	Exprs.period(Period period)	Builds a period literal expression from a Period object.
Expression	Exprs.pi()	Builds an expression computing the value of pi.
Expression	Expression.plus(Number e)	Builds an expression that computes the value of this expression plus the given value.
Expression	Expression.plus(Duration d)	Builds an expression that computes the value of this expression plus the given duration.
Expression	Expression.plus(Period p)	Builds an expression that computes the value of this expression plus the given period.
Expression	Expression.plus(Expression e)	Builds an expression that computes the value of this expression plus the given value.
Expression	Expression.power(Number exponent)	Builds an expression that will compute the value of this expression to the power exponent.
Expression	Expression.power(Expression exponent)	Builds an expression that will compute the value of this expression to the power exponent.
Expression	Exprs.power(Expression base, Number exponent)	Builds an expression computing the value of the power function applied to the given base and exponent.
Expression	Exprs.power(Expression base, Expression exponent)	Builds an expression computing the value of the power function applied to the given base and exponent.
Expression	Expression.radians()	Builds an expression that computes the radians value of this expression.
Expression	Exprs.radians(Expression e)	Builds an expression computing the value of the radians function applied to the given value.
Expression	Exprs.random()	Builds an expression computing a random 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	Expression.round()	Builds an expression that will apply the round function to this expression.
Expression	Expression.round(Long precision)	Builds an expression that will apply the round function to this expression with the given precision.
Expression	Expression.round(Expression precision)	Builds an expression that will apply the round function to this expression with the given precision.
Expression	Exprs.round(Expression e)	Builds an expression computing the value of the round function applied to the given value (will round to the nearest integer).
Expression	Exprs.round(Expression e, Long s)	Builds an expression computing the value of the round function applied to the given value with a specified scale.
Expression	Exprs.round(Expression e, Expression s)	Builds an expression computing the value of the round function applied to the given value with a specified scale.
Expression	WindowFunction.rowNumber()	Builds a window function computing the number of the current row within its partition, counting from 1.
Expression	Expression.sign()	Builds an expression that will compute the sign of this expression.
Expression	Exprs.sign(Expression e)	Builds an expression computing the value of the sign function applied to the given value.
Expression	Exprs.sin(Expression radians)	Builds an expression computing the value of the sin function applied to the given value.
Expression	Exprs.sqrt(Expression e)	Builds an expression computing the value of the square root function applied to the given value.
Expression	Exprs.standardDeviation(Expression expression)	Builds an expression computing the biased variance (division by n) of a set of numbers.
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	Exprs.tan(Expression radians)	Builds an expression computing the value of the tan function applied to the given value.
Expression	Expression.trim()	Builds an expression that computes this expression without any starting or ending white space characters.
Expression	Expression.trunc()	Builds an expression that will apply the trunc function to this expression.
Expression	Exprs.trunc(Expression e)	Builds an expression computing the value of the truncate function applied to the given value (will truncate towards zero).
Expression	Exprs.trunc(Expression value, Long scale)	Builds an expression computing the value of the truncate function applied to the given value with a specified scale.
Expression	Exprs.trunc(Expression value, Expression scale)	Builds an expression computing the value of the truncate function applied to the given value with a specified scale.
Expression	Expression.upper()	Builds an expression that computes an upper case version of this expression.
Expression	Exprs.variance(Expression expression)	Builds an expression computing the value of the population variance of the input values (square of the population standard deviation).
Expression	Exprs.width_bucket(Expression operand, Number b1, Number b2, Long count)	Builds an expression that will return the bucket number to which operand would be assigned in a histogram having count equal-width buckets spanning the range b1 to b2
Expression	Exprs.width_bucket(Expression operand, Expression b1, Expression b2, Expression count)	Builds an expression that will return the bucket number to which operand would be assigned in a histogram having count equal-width buckets spanning the range b1 to b2

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.acos(Expression radians)	Builds an expression computing the value of the acos function applied to 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 null values evaluated as the lowest value.
Orders.Order	Orders.ascNullsLast(Expression e)	Builds an ascending order with null values evaluated as the highest value.
Expression	Exprs.asin(Expression radians)	Builds an expression computing the value of the asin function applied to the given value.
Expression	Exprs.atan(Expression radians)	Builds an expression computing the value of the atan function applied to the given value.
Expression	Exprs.atan2(Expression y, Expression x)	Builds an expression computing the value of the atan2 function applied to the given y and x values.
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.cbrt(Expression e)	Builds an expression computing the value of the cube root function applied to the given value.
Expression	Exprs.ceil(Expression e)	Builds an expression computing the value of the ceil function applied to the given 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(Expression e)	Builds an expression that concatenates this expression to a given value.
Expression	Exprs.cos(Expression radians)	Builds an expression computing the value of the cos function applied to the 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 values 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	Exprs.degrees(Expression e)	Builds an expression computing the value of the degrees function applied to the given value.
Orders.Order	Orders.descNullsFirst(Expression e)	Builds a descending order with null values evaluated as the lowest value.
Orders.Order	Orders.descNullsLast(Expression e)	Builds a descending order with null 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	Exprs.factorial(Expression e)	Builds an expression computing the value of the factorial 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	Exprs.floor(Expression e)	Builds an expression computing the value of the floor 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	Exprs.greatest(Expression... exprs)	Builds an expression computing the largest value from a list of any number of expressions
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)	Builds a window function computing value evaluated at the row before the current row within the partition; if there is no such row, instead returns NULL.
Expression	WindowFunction.lag(Expression expression, Expression offset)	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 NULL.
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)	Builds a window function computing value evaluated at the row after the current row within the partition; if there is no such row, instead returns NULL.
Expression	WindowFunction.lead(Expression expression, Expression offset)	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 NULL.
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	Exprs.least(Expression... exprs)	Builds an expression computing the smallest value from a list of any number of expressions
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	Exprs.ln(Expression e)	Builds an expression computing the value of the ln (natural logarithm) function applied to 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.log(Number base, Expression e)	Builds an expression computing the value of the log function applied to the given value.
Expression	Exprs.log(Expression e)	Builds an expression computing the value of the log (base 10) function applied to the given value.
Expression	Exprs.log(Expression base, Expression e)	Builds an expression computing the value of the log function applied to the given value.
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	Exprs.percentileCont(Number fraction, Expression sortBy)	Builds an expression computing the value of the continuous percentile corresponding to the specified fraction, interpolating between adjacent input items if needed.
Expression	Exprs.percentileDisc(Number fraction, Expression sortBy)	Builds an expression computing the value of the discrete percentile: the first input value whose position in the ordering equals or exceeds the specified fraction.
Expression	Exprs.percentRank(Expression expression, Expression sortBy)	Builds an expression computing the relative rank of a value
Expression	Expression.plus(Expression e)	Builds an expression that computes the value of this expression plus the given value.
Expression	Expression.power(Expression exponent)	Builds an expression that will compute the value of this expression to the power exponent.
Expression	Exprs.power(Expression base, Number exponent)	Builds an expression computing the value of the power function applied to the given base and exponent.
Expression	Exprs.power(Expression base, Expression exponent)	Builds an expression computing the value of the power function applied to the given base and exponent.
Expression	Exprs.radians(Expression e)	Builds an expression computing the value of the radians function applied to the given value.
Expression	Expression.round(Expression precision)	Builds an expression that will apply the round function to this expression with the given precision.
Expression	Exprs.round(Expression e)	Builds an expression computing the value of the round function applied to the given value (will round to the nearest integer).
Expression	Exprs.round(Expression e, Long s)	Builds an expression computing the value of the round function applied to the given value with a specified scale.
Expression	Exprs.round(Expression e, Expression s)	Builds an expression computing the value of the round function applied to the given value with a specified scale.
Expression	Exprs.sign(Expression e)	Builds an expression computing the value of the sign function applied to the given value.
Expression	Exprs.sin(Expression radians)	Builds an expression computing the value of the sin function applied to 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	Exprs.sqrt(Expression e)	Builds an expression computing the value of the square root function applied to the given value.
Expression	Exprs.standardDeviation(Expression expression)	Builds an expression computing the biased variance (division by n) of a set of numbers.
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	Exprs.tan(Expression radians)	Builds an expression computing the value of the tan function applied to the given value.
Expression	Exprs.trunc(Expression e)	Builds an expression computing the value of the truncate function applied to the given value (will truncate towards zero).
Expression	Exprs.trunc(Expression value, Long scale)	Builds an expression computing the value of the truncate function applied to the given value with a specified scale.
Expression	Exprs.trunc(Expression value, Expression scale)	Builds an expression computing the value of the truncate function applied to the given value with a specified scale.
Expression	Exprs.variance(Expression expression)	Builds an expression computing the value of the population variance of the input values (square of the population standard deviation).
Expression	Exprs.width_bucket(Expression operand, Number b1, Number b2, Long count)	Builds an expression that will return the bucket number to which operand would be assigned in a histogram having count equal-width buckets spanning the range b1 to b2
Expression	Exprs.width_bucket(Expression operand, Expression b1, Expression b2, Expression count)	Builds an expression that will return the bucket number to which operand would be assigned in a histogram having count equal-width buckets spanning the range b1 to b2

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,Collection<? extends Expression>> by, Function<Tables.Columns,Collection<? 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.