Expressions (Esper API Documentation)

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.espertech.esper.client.soda
Class Expressions

java.lang.Object
  com.espertech.esper.client.soda.Expressions

All Implemented Interfaces:: java.io.Serializable

public class Expressions
extends java.lang.Object
implements java.io.Serializable
extends java.lang.Object
implements java.io.Serializable

Convenience factory for creating Expression instances.

Provides quick-access methods to create all possible expressions and provides typical parameter lists to each.

Note that only the typical parameter lists are provided and expressions can allow adding additional parameters.

Many expressions, for example logical AND and OR (conjunction and disjunction), allow adding an unlimited number of additional sub-expressions to an expression. For those expressions there are additional add methods provided.

See Also:: Serialized Form

Constructor Summary
`Expressions()`

Method Summary
`static Conjunction`	`and()` Logical AND conjunction.
`static Conjunction`	`and(Expression first, Expression second, Expression... expressions)` Logical AND conjunction.
`static ArrayExpression`	`array()` Array expression, representing the syntax of "{1, 2, 3}" returning an integer array of 3 elements valued 1, 2, 3.
`static AvedevProjectionExpression`	`avedev(Expression expression)` Mean deviation aggregation function.
`static AvedevProjectionExpression`	`avedev(java.lang.String propertyName)` Mean deviation aggregation function.
`static AvedevProjectionExpression`	`avedevDistinct(Expression expression)` Mean deviation function considering distinct values only.
`static AvedevProjectionExpression`	`avedevDistinct(java.lang.String propertyName)` Mean deviation function considering distinct values only.
`static AvgProjectionExpression`	`avg(Expression expression)` Average aggregation function.
`static AvgProjectionExpression`	`avg(java.lang.String propertyName)` Average aggregation function.
`static AvgProjectionExpression`	`avgDistinct(Expression expression)` Average aggregation function considering distinct values only.
`static AvgProjectionExpression`	`avgDistinct(java.lang.String propertyName)` Average aggregation function considering distinct values only.
`static BetweenExpression`	`between(Expression datapoint, Expression lowBoundary, Expression highBoundary)` Between.
`static BetweenExpression`	`between(java.lang.String property, java.lang.Object lowBoundary, java.lang.Object highBoundary)` Between.
`static BetweenExpression`	`betweenProperty(java.lang.String property, java.lang.String lowBoundaryProperty, java.lang.String highBoundaryProperty)` Between.
`static BitwiseOpExpression`	`binaryAnd()` Bitwise (binary) AND.
`static BitwiseOpExpression`	`binaryOr()` Bitwise (binary) OR.
`static BitwiseOpExpression`	`binaryXor()` Bitwise (binary) XOR.
`static CaseSwitchExpression`	`caseSwitch(Expression valueToSwitchOn)` Case-switch expresssion.
`static CaseSwitchExpression`	`caseSwitch(java.lang.String propertyName)` Case-switch expresssion.
`static CaseWhenThenExpression`	`caseWhenThen()` Case-when-then expression.
`static CastExpression`	`cast(Expression expression, java.lang.String typeName)` Cast function, casts the result on an expression to the desired type, or returns null if the type cannot be casted to the type.
`static CastExpression`	`cast(java.lang.String propertyName, java.lang.String typeName)` Cast function, casts the result on an expression to the desired type, or returns null if the type cannot be casted to the type.
`static CoalesceExpression`	`coalesce(Expression exprOne, Expression exprTwo, Expression... moreExpressions)` Coalesce.
`static CoalesceExpression`	`coalesce(java.lang.String propertyOne, java.lang.String propertyTwo, java.lang.String... moreProperties)` Coalesce.
`static ConcatExpression`	`concat(java.lang.String property, java.lang.String... properties)` Concatenation.
`static ConstantExpression`	`constant(java.lang.Object value)` Constant.
`static ConstantExpression`	`constant(java.lang.Object value, java.lang.Class constantType)` Constant, use when the value is null.
`static CountProjectionExpression`	`count(Expression expression)` Count aggregation function.
`static CountProjectionExpression`	`count(java.lang.String propertyName)` Count aggregation function.
`static CountProjectionExpression`	`countDistinct(Expression expression)` Count aggregation function considering distinct values only.
`static CountProjectionExpression`	`countDistinct(java.lang.String propertyName)` Count aggregation function considering distinct values only.
`static CountStarProjectionExpression`	`countStar()` Count aggregation function not counting values, equivalent to "count(*)".
`static CrontabFrequencyExpression`	`crontabScheduleFrequency(int frequency)` Creates a frequency cron parameter.
`static CrontabParameterExpression`	`crontabScheduleItem(java.lang.Integer parameter, ScheduleItemType type)` Creates a parameter of the given type and parameterized by a number.
`static CrontabRangeExpression`	`crontabScheduleRange(int lowerBounds, int upperBounds)` Creates a range cron parameter.
`static CrontabParameterExpression`	`crontabScheduleWildcard()` Creates a wildcard parameter.
`static CurrentTimestampExpression`	`currentTimestamp()` Current system time supplies internal-timer provided time or the time provided by external timer events.
`static ArithmaticExpression`	`divide(Expression left, Expression right)` Division.
`static ArithmaticExpression`	`divide(java.lang.String propertyLeft, java.lang.String propertyRight)` Division.
`static RelationalOpExpression`	`eq(Expression left, Expression right)` Equals between expression results.
`static RelationalOpExpression`	`eq(java.lang.String propertyName, java.lang.Object value)` Equals between a property and a constant.
`static RelationalOpExpression`	`eqProperty(java.lang.String propertyLeft, java.lang.String propertyRight)` Equals between properties.
`static PropertyExistsExpression`	`existsProperty(java.lang.String propertyName)` Exists-function for use with dynamic properties to test property existence.
`static FirstProjectionExpression`	`first(Expression expression)` First-value (in window) aggregation function.
`static FirstProjectionExpression`	`first(java.lang.String propertyName)` First-value (windowed) aggregation function.
`static FirstEverProjectionExpression`	`firstEver(Expression expression)` First-value (ever) aggregation function.
`static FirstEverProjectionExpression`	`firstEver(java.lang.String propertyName)` First-value (ever) aggregation function.
`static RelationalOpExpression`	`ge(Expression left, Expression right)` Greater-or-equals between expression results.
`static RelationalOpExpression`	`ge(java.lang.String propertyName, java.lang.Object value)` Greater-or-equal between a property and a constant.
`static RelationalOpExpression`	`geProperty(java.lang.String propertyLeft, java.lang.String propertyRight)` Greater-or-equal between properties.
`protected static PropertyValueExpression`	`getPropExpr(java.lang.String propertyName)` Returns an expression returning the propertyName value for the propertyName name passed in.
`static RelationalOpExpression`	`gt(Expression left, Expression right)` Greater-then between expression results.
`static RelationalOpExpression`	`gt(java.lang.String propertyName, java.lang.Object value)` Greater-then between a property and a constant.
`static RelationalOpExpression`	`gtProperty(java.lang.String propertyLeft, java.lang.String propertyRight)` Greater-then between properties.
`static InExpression`	`in(Expression value, Expression... set)` In-expression that is equivalent to the syntax of "property in (value, value, ...
`static InExpression`	`in(java.lang.String property, java.lang.Object... values)` In-expression that is equivalent to the syntax of "property in (value, value, ...
`static InstanceOfExpression`	`instanceOf(Expression expression, java.lang.String typeName, java.lang.String... typeNames)` Instance-of function, tests if the type of the return value of an expression is in a list of types.
`static InstanceOfExpression`	`instanceOf(java.lang.String propertyName, java.lang.String typeName, java.lang.String... typeNames)` Instance-of function, tests if the type of the return value of a property is in a list of types.
`static RelationalOpExpression`	`isNotNull(Expression expression)` Not-null test.
`static RelationalOpExpression`	`isNotNull(java.lang.String property)` Not-null test.
`static RelationalOpExpression`	`isNull(Expression expression)` Is-null test.
`static RelationalOpExpression`	`isNull(java.lang.String property)` Is-null test.
`static LastProjectionExpression`	`last(Expression expression)` Lastever-value aggregation function.
`static LastProjectionExpression`	`last(java.lang.String propertyName)` Lastever-value aggregation function.
`static LastEverProjectionExpression`	`lastEver(Expression expression)` Lastever-value aggregation function.
`static LastEverProjectionExpression`	`lastEver(java.lang.String propertyName)` Lastever-value aggregation function.
`static RelationalOpExpression`	`le(Expression left, Expression right)` Less-or-equal between expression results.
`static RelationalOpExpression`	`le(java.lang.String propertyName, java.lang.Object value)` Less-or-equals between a property and a constant.
`static RelationalOpExpression`	`leProperty(java.lang.String propertyLeft, java.lang.String propertyRight)` Less-or-equal between properties.
`static LikeExpression`	`like(Expression left, Expression right)` SQL-Like.
`static LikeExpression`	`like(Expression left, Expression right, Expression escape)` SQL-Like.
`static LikeExpression`	`like(java.lang.String propertyName, java.lang.Object value, java.lang.String escape)` SQL-Like.
`static LikeExpression`	`like(java.lang.String propertyName, java.lang.String value)` SQL-Like.
`static RelationalOpExpression`	`lt(Expression left, Expression right)` Less-then between expression results.
`static RelationalOpExpression`	`lt(java.lang.String propertyName, java.lang.Object value)` Less-then between a property and a constant.
`static RelationalOpExpression`	`ltProperty(java.lang.String propertyLeft, java.lang.String propertyRight)` Less-then between properties.
`static MaxProjectionExpression`	`max(Expression expression)` Maximum aggregation function.
`static MaxRowExpression`	`max(Expression exprOne, Expression exprTwo, Expression... moreExpressions)` Maximum value per-row function (not aggregating).
`static MaxProjectionExpression`	`max(java.lang.String propertyName)` Maximum aggregation function.
`static MaxRowExpression`	`max(java.lang.String propertyOne, java.lang.String propertyTwo, java.lang.String... moreProperties)` Maximum value per-row function (not aggregating).
`static MaxProjectionExpression`	`maxDistinct(Expression expression)` Maximum aggregation function considering distinct values only.
`static MaxProjectionExpression`	`maxDistinct(java.lang.String propertyName)` Maximum aggregation function considering distinct values only.
`static MedianProjectionExpression`	`median(Expression expression)` Median aggregation function.
`static MedianProjectionExpression`	`median(java.lang.String propertyName)` Median aggregation function.
`static MedianProjectionExpression`	`medianDistinct(Expression expression)` Median aggregation function considering distinct values only.
`static MedianProjectionExpression`	`medianDistinct(java.lang.String propertyName)` Median aggregation function considering distinct values only.
`static MinProjectionExpression`	`min(Expression expression)` Minimum aggregation function.
`static MinRowExpression`	`min(Expression exprOne, Expression exprTwo, Expression... moreExpressions)` Minimum value per-row function (not aggregating).
`static MinProjectionExpression`	`min(java.lang.String propertyName)` Minimum aggregation function.
`static MinRowExpression`	`min(java.lang.String propertyOne, java.lang.String propertyTwo, java.lang.String... moreProperties)` Minimum value per-row function (not aggregating).
`static MinProjectionExpression`	`minDistinct(Expression expression)` Minimum aggregation function considering distinct values only.
`static MinProjectionExpression`	`minDistinct(java.lang.String propertyName)` Minimum aggregation function considering distinct values only.
`static ArithmaticExpression`	`minus(Expression left, Expression right)` Subtraction.
`static ArithmaticExpression`	`minus(java.lang.String propertyLeft, java.lang.String propertyRight)` Subtraction.
`static ArithmaticExpression`	`modulo(Expression left, Expression right)` Modulo.
`static ArithmaticExpression`	`modulo(java.lang.String propertyLeft, java.lang.String propertyRight)` Modulo.
`static ArithmaticExpression`	`multiply(Expression left, Expression right)` Multiplication.
`static ArithmaticExpression`	`multiply(java.lang.String propertyLeft, java.lang.String propertyRight)` Multiplication.
`static RelationalOpExpression`	`neq(Expression left, Expression right)` Not-Equals between expression results.
`static RelationalOpExpression`	`neq(java.lang.String propertyName, java.lang.Object value)` Not-Equals between a property and a constant.
`static RelationalOpExpression`	`neqProperty(java.lang.String propertyLeft, java.lang.String propertyRight)` Not-Equals between properties.
`static NotExpression`	`not(Expression inner)` Not expression negates the sub-expression to the not which is expected to return boolean-typed values.
`static InExpression`	`notIn(Expression value, Expression... set)` Not-In-expression that is equivalent to the syntax of "property not in (value, value, ...
`static InExpression`	`notIn(java.lang.String property, java.lang.Object... values)` Not-In-expression that is equivalent to the syntax of "property not in (value, value, ...
`static LikeExpression`	`notLike(Expression left, Expression right)` SQL-Like negated (not like).
`static LikeExpression`	`notLike(Expression left, Expression right, Expression escape)` SQL-Like negated (not like).
`static LikeExpression`	`notLike(java.lang.String propertyName, java.lang.Object value, java.lang.String escape)` SQL-Like negated (not like).
`static LikeExpression`	`notLike(java.lang.String propertyName, java.lang.String value)` SQL-Like negated (not like).
`static RegExpExpression`	`notRegexp(Expression left, Expression right)` Regular expression negated (not regexp).
`static RegExpExpression`	`notRegexp(Expression left, Expression right, java.lang.String escape)` Regular expression negated (not regexp).
`static RegExpExpression`	`notRegexp(java.lang.String property, java.lang.String regExExpression)` Regular expression negated (not regexp).
`static RegExpExpression`	`notRegexp(java.lang.String property, java.lang.String regExExpression, java.lang.String escape)` Regular expression negated (not regexp).
`static Disjunction`	`or()` Logical OR disjunction.
`static Disjunction`	`or(Expression first, Expression second, Expression... expressions)` Logical OR disjunction.
`static PlugInProjectionExpression`	`plugInAggregation(java.lang.String functionName, Expression... moreExpressions)` Plug-in aggregation function.
`static ArithmaticExpression`	`plus(Expression left, Expression right)` Addition.
`static ArithmaticExpression`	`plus(java.lang.String propertyLeft, java.lang.String propertyRight)` Addition.
`static PreviousExpression`	`previous(Expression expression, java.lang.String property)` Previous function.
`static PreviousExpression`	`previous(int index, java.lang.String property)` Previous function.
`static PreviousExpression`	`previousCount(java.lang.String property)` Previous count function.
`static PreviousExpression`	`previousTail(Expression expression, java.lang.String property)` Previous tail function.
`static PreviousExpression`	`previousTail(int index, java.lang.String property)` Previous tail function.
`static PreviousExpression`	`previousWindow(java.lang.String property)` Previous window function.
`static PriorExpression`	`prior(int index, java.lang.String property)` Prior function.
`static PropertyValueExpression`	`property(java.lang.String propertyName)` Property value.
`static BetweenExpression`	`range(Expression datapoint, Expression lowBoundary, Expression highBoundary, boolean isLowIncluded, boolean isHighIncluded)` Between (or range).
`static RegExpExpression`	`regexp(Expression left, Expression right)` Regular expression.
`static RegExpExpression`	`regexp(Expression left, Expression right, java.lang.String escape)` Regular expression.
`static RegExpExpression`	`regexp(java.lang.String property, java.lang.String regExExpression)` Regular expression.
`static RegExpExpression`	`regexp(java.lang.String property, java.lang.String regExExpression, java.lang.String escape)` Regular expression.
`static StaticMethodExpression`	`staticMethod(java.lang.String className, java.lang.String method, Expression... parameters)` Static method invocation.
`static StaticMethodExpression`	`staticMethod(java.lang.String className, java.lang.String method, java.lang.Object... parameters)` Static method invocation.
`static StddevProjectionExpression`	`stddev(Expression expression)` Standard deviation aggregation function.
`static StddevProjectionExpression`	`stddev(java.lang.String propertyName)` Standard deviation aggregation function.
`static StddevProjectionExpression`	`stddevDistinct(Expression expression)` Standard deviation function considering distinct values only.
`static StddevProjectionExpression`	`stddevDistinct(java.lang.String propertyName)` Standard deviation function considering distinct values only.
`static SubqueryExpression`	`subquery(EPStatementObjectModel model)` Subquery.
`static SubqueryExistsExpression`	`subqueryExists(EPStatementObjectModel model)` Subquery with exists-clause, represents the syntax of "select * from ...
`static SubqueryInExpression`	`subqueryIn(Expression expression, EPStatementObjectModel model)` Subquery with in-clause, represents the syntax of "value in (select ...
`static SubqueryInExpression`	`subqueryIn(java.lang.String property, EPStatementObjectModel model)` Subquery with in-clause, represents the syntax of "value in (select ...
`static SubqueryInExpression`	`subqueryNotIn(Expression expression, EPStatementObjectModel model)` Subquery with not-in-clause, represents the syntax of "value not in (select ...
`static SubqueryInExpression`	`subqueryNotIn(java.lang.String property, EPStatementObjectModel model)` Subquery with not-in-clause, represents the syntax of "value not in (select ...
`static SumProjectionExpression`	`sum(Expression expression)` Sum aggregation function.
`static SumProjectionExpression`	`sum(java.lang.String propertyName)` Sum aggregation function.
`static SumProjectionExpression`	`sumDistinct(Expression expression)` Sum aggregation function considering distinct values only.
`static SumProjectionExpression`	`sumDistinct(java.lang.String propertyName)` Sum aggregation function considering distinct values only.
`static TimePeriodExpression`	`timePeriod(java.lang.Double days, java.lang.Double hours, java.lang.Double minutes, java.lang.Double seconds, java.lang.Double milliseconds)` Returns a time period expression for the specified parts.
`static TimePeriodExpression`	`timePeriod(java.lang.Object days, java.lang.Object hours, java.lang.Object minutes, java.lang.Object seconds, java.lang.Object milliseconds)` Returns a time period expression for the specified parts.
`protected static java.util.List<PropertyValueExpression>`	`toPropertyExpressions(java.lang.String... properties)` Returns a list of expressions returning property values for the property names passed in.
`static TypeOfExpression`	`typeOf(Expression expression)` Type-of function, returns the event type name or result type as a string of a stream name, property or expression.
`static TypeOfExpression`	`typeOf(java.lang.String propertyName)` Type-of function, returns the event type name or result type as a string of a stream name, property or expression.

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Constructor Detail

Expressions

public Expressions()

Method Detail

currentTimestamp

public static CurrentTimestampExpression currentTimestamp()

Current system time supplies internal-timer provided time or the time provided by external timer events.

Returns:: expression

existsProperty

public static PropertyExistsExpression existsProperty(java.lang.String propertyName)

Exists-function for use with dynamic properties to test property existence.

Parameters:: propertyName - name of the property to test whether it exists or not
Returns:: expression

cast

public static CastExpression cast(Expression expression,
                                  java.lang.String typeName)

Cast function, casts the result on an expression to the desired type, or returns null if the type cannot be casted to the type.

The list of types can include fully-qualified class names plus any of the Java primitive type names: byte, char, short, int, long, float, double, boolean. Alternatively to "java.lang.String" the simple "string" is also permitted.

Type checks include all superclasses and interfaces of the value returned by the expression.

Parameters:: expression - returns the value to cast; typeName - is type to cast to
Returns:: expression

cast

public static CastExpression cast(java.lang.String propertyName,
                                  java.lang.String typeName)

Cast function, casts the result on an expression to the desired type, or returns null if the type cannot be casted to the type.

Type checks include all superclasses and interfaces of the value returned by the expression.

Parameters:: propertyName - name of the property supplying the value to cast; typeName - is type to cast to
Returns:: expression

instanceOf

public static InstanceOfExpression instanceOf(Expression expression,
                                              java.lang.String typeName,
                                              java.lang.String... typeNames)

Instance-of function, tests if the type of the return value of an expression is in a list of types.

Type checks include all superclasses and interfaces of the value returned by the expression.

Parameters:: expression - returns the value to test whether the type returned is any of the is the function name; typeName - is one type to check for; typeNames - is optional additional types to check for in a list
Returns:: expression

instanceOf

public static InstanceOfExpression instanceOf(java.lang.String propertyName,
                                              java.lang.String typeName,
                                              java.lang.String... typeNames)

Instance-of function, tests if the type of the return value of a property is in a list of types.

Useful with dynamic (unchecked) properties to check the type of property returned.

Type checks include all superclasses and interfaces of the value returned by the expression.

Parameters:: propertyName - name of the property supplying the value to test; typeName - is one type to check for; typeNames - is optional additional types to check for in a list
Returns:: expression

typeOf

public static TypeOfExpression typeOf(Expression expression)

Type-of function, returns the event type name or result type as a string of a stream name, property or expression.

Parameters:: expression - to evaluate and return it's result type as a string
Returns:: expression

typeOf

public static TypeOfExpression typeOf(java.lang.String propertyName)

Type-of function, returns the event type name or result type as a string of a stream name, property or expression.

Parameters:: propertyName - returns the property to evaluate and return its event type name or property class type
Returns:: expression

plugInAggregation

public static PlugInProjectionExpression plugInAggregation(java.lang.String functionName,
                                                           Expression... moreExpressions)

Plug-in aggregation function.

Parameters:: functionName - is the function name; moreExpressions - provides the values to aggregate
Returns:: expression

regexp

public static RegExpExpression regexp(Expression left,
                                      Expression right)

Regular expression.

Parameters:: left - returns the values to match; right - returns the value to match against
Returns:: expression

regexp

public static RegExpExpression regexp(Expression left,
                                      Expression right,
                                      java.lang.String escape)

Regular expression.

Parameters:: left - returns the values to match; right - returns the value to match against; escape - is the escape character
Returns:: expression

regexp

public static RegExpExpression regexp(java.lang.String property,
                                      java.lang.String regExExpression)

Regular expression.

Parameters:: property - the name of the property returning values to match; regExExpression - a regular expression to match against
Returns:: expression

regexp

public static RegExpExpression regexp(java.lang.String property,
                                      java.lang.String regExExpression,
                                      java.lang.String escape)

Regular expression.

Parameters:: property - the name of the property returning values to match; regExExpression - a regular expression to match against; escape - is the escape character
Returns:: expression

notRegexp

public static RegExpExpression notRegexp(Expression left,
                                         Expression right)

Regular expression negated (not regexp).

Parameters:: left - returns the values to match; right - returns the value to match against
Returns:: expression

notRegexp

public static RegExpExpression notRegexp(Expression left,
                                         Expression right,
                                         java.lang.String escape)

Regular expression negated (not regexp).

Parameters:: left - returns the values to match; right - returns the value to match against; escape - is the escape character
Returns:: expression

notRegexp

public static RegExpExpression notRegexp(java.lang.String property,
                                         java.lang.String regExExpression)

Regular expression negated (not regexp).

Parameters:: property - the name of the property returning values to match; regExExpression - a regular expression to match against
Returns:: expression

notRegexp

public static RegExpExpression notRegexp(java.lang.String property,
                                         java.lang.String regExExpression,
                                         java.lang.String escape)

Regular expression negated (not regexp).

Parameters:: property - the name of the property returning values to match; regExExpression - a regular expression to match against; escape - is the escape character
Returns:: expression

array

public static ArrayExpression array()

Array expression, representing the syntax of "{1, 2, 3}" returning an integer array of 3 elements valued 1, 2, 3.

Returns:: expression

binaryAnd

public static BitwiseOpExpression binaryAnd()

Bitwise (binary) AND.

Returns:: expression

binaryOr

public static BitwiseOpExpression binaryOr()

Bitwise (binary) OR.

Returns:: expression

binaryXor

public static BitwiseOpExpression binaryXor()

Bitwise (binary) XOR.

Returns:: expression

min

public static MinRowExpression min(java.lang.String propertyOne,
                                   java.lang.String propertyTwo,
                                   java.lang.String... moreProperties)

Minimum value per-row function (not aggregating).

Parameters:: propertyOne - the name of a first property to compare; propertyTwo - the name of a second property to compare; moreProperties - optional additional properties to compare
Returns:: expression

min

public static MinRowExpression min(Expression exprOne,
                                   Expression exprTwo,
                                   Expression... moreExpressions)

Minimum value per-row function (not aggregating).

Parameters:: exprOne - returns the first value to compare; exprTwo - returns the second value to compare; moreExpressions - optional additional values to compare
Returns:: expression

max

public static MaxRowExpression max(java.lang.String propertyOne,
                                   java.lang.String propertyTwo,
                                   java.lang.String... moreProperties)

Maximum value per-row function (not aggregating).

Parameters:: propertyOne - the name of a first property to compare; propertyTwo - the name of a second property to compare; moreProperties - optional additional properties to compare
Returns:: expression

max

public static MaxRowExpression max(Expression exprOne,
                                   Expression exprTwo,
                                   Expression... moreExpressions)

Maximum value per-row function (not aggregating).

Parameters:: exprOne - returns the first value to compare; exprTwo - returns the second value to compare; moreExpressions - optional additional values to compare
Returns:: expression

coalesce

public static CoalesceExpression coalesce(java.lang.String propertyOne,
                                          java.lang.String propertyTwo,
                                          java.lang.String... moreProperties)

Coalesce.

Parameters:: propertyOne - name of the first property returning value to coealesce; propertyTwo - name of the second property returning value to coealesce; moreProperties - name of the optional additional properties returning values to coealesce
Returns:: expression

coalesce

public static CoalesceExpression coalesce(Expression exprOne,
                                          Expression exprTwo,
                                          Expression... moreExpressions)

Coalesce.

Parameters:: exprOne - returns value to coalesce; exprTwo - returns value to coalesce; moreExpressions - returning optional additional values to coalesce
Returns:: expression

constant

public static ConstantExpression constant(java.lang.Object value)

Constant.

Parameters:: value - is the constant value
Returns:: expression

constant

public static ConstantExpression constant(java.lang.Object value,
                                          java.lang.Class constantType)

Constant, use when the value is null.

Parameters:: value - is the constant value; constantType - is the type of the constant
Returns:: expression

caseWhenThen

public static CaseWhenThenExpression caseWhenThen()

Case-when-then expression.

Returns:: expression

caseSwitch

public static CaseSwitchExpression caseSwitch(Expression valueToSwitchOn)

Case-switch expresssion.

Parameters:: valueToSwitchOn - provides the switch value
Returns:: expression

caseSwitch

public static CaseSwitchExpression caseSwitch(java.lang.String propertyName)

Case-switch expresssion.

Parameters:: propertyName - the name of the property that provides the switch value
Returns:: expression

in

public static InExpression in(java.lang.String property,
                              java.lang.Object... values)

In-expression that is equivalent to the syntax of "property in (value, value, ... value)".

Parameters:: property - is the name of the property; values - are the constants to check against
Returns:: expression

notIn

public static InExpression notIn(java.lang.String property,
                                 java.lang.Object... values)

Not-In-expression that is equivalent to the syntax of "property not in (value, value, ... value)".

Parameters:: property - is the name of the property; values - are the constants to check against
Returns:: expression

in

public static InExpression in(Expression value,
                              Expression... set)

In-expression that is equivalent to the syntax of "property in (value, value, ... value)".

Parameters:: value - provides values to match; set - are expressons that provide match-against values
Returns:: expression

notIn

public static InExpression notIn(Expression value,
                                 Expression... set)

Not-In-expression that is equivalent to the syntax of "property not in (value, value, ... value)".

Parameters:: value - provides values to match; set - are expressons that provide match-against values
Returns:: expression

not

public static NotExpression not(Expression inner)

Not expression negates the sub-expression to the not which is expected to return boolean-typed values.

Parameters:: inner - is the sub-expression
Returns:: expression

staticMethod

public static StaticMethodExpression staticMethod(java.lang.String className,
                                                  java.lang.String method,
                                                  java.lang.Object... parameters)

Static method invocation.

Parameters:: className - the name of the class to invoke a method on; method - the name of the method to invoke; parameters - zero, one or more constants that are the parameters to the static method
Returns:: expression

staticMethod

public static StaticMethodExpression staticMethod(java.lang.String className,
                                                  java.lang.String method,
                                                  Expression... parameters)

Static method invocation.

Parameters:: className - the name of the class to invoke a method on; method - the name of the method to invoke; parameters - zero, one or more expressions that provide parameters to the static method
Returns:: expression

prior

public static PriorExpression prior(int index,
                                    java.lang.String property)

Prior function.

Parameters:: index - the numeric index of the prior event; property - the name of the property to obtain the value for
Returns:: expression

public static PreviousExpression previous(Expression expression,
                                          java.lang.String property)

Previous function.

Parameters:: expression - provides the numeric index of the previous event; property - the name of the property to obtain the value for
Returns:: expression

public static PreviousExpression previous(int index,
                                          java.lang.String property)

Previous function.

Parameters:: index - the numeric index of the previous event; property - the name of the property to obtain the value for
Returns:: expression

previousTail

public static PreviousExpression previousTail(Expression expression,
                                              java.lang.String property)

Previous tail function.

Parameters:: expression - provides the numeric index of the previous event; property - the name of the property to obtain the value for
Returns:: expression

previousTail

public static PreviousExpression previousTail(int index,
                                              java.lang.String property)

Previous tail function.

Parameters:: index - the numeric index of the previous event; property - the name of the property to obtain the value for
Returns:: expression

previousCount

public static PreviousExpression previousCount(java.lang.String property)

Previous count function.

Parameters:: property - provides the properties or stream name to select for the previous event
Returns:: expression

previousWindow

public static PreviousExpression previousWindow(java.lang.String property)

Previous window function.

Parameters:: property - provides the properties or stream name to select for the previous event
Returns:: expression

betweenProperty

public static BetweenExpression betweenProperty(java.lang.String property,
                                                java.lang.String lowBoundaryProperty,
                                                java.lang.String highBoundaryProperty)

Between.

Parameters:: property - the name of the property supplying data points.; lowBoundaryProperty - the name of the property supplying lower boundary.; highBoundaryProperty - the name of the property supplying upper boundary.
Returns:: expression

between

public static BetweenExpression between(java.lang.String property,
                                        java.lang.Object lowBoundary,
                                        java.lang.Object highBoundary)

Between.

Parameters:: property - the name of the property that returns the datapoint to check range; lowBoundary - constant indicating the lower boundary; highBoundary - constant indicating the upper boundary
Returns:: expression

between

public static BetweenExpression between(Expression datapoint,
                                        Expression lowBoundary,
                                        Expression highBoundary)

Between.

Parameters:: datapoint - returns the datapoint to check range; lowBoundary - returns values for the lower boundary; highBoundary - returns values for the upper boundary
Returns:: expression

range

public static BetweenExpression range(Expression datapoint,
                                      Expression lowBoundary,
                                      Expression highBoundary,
                                      boolean isLowIncluded,
                                      boolean isHighIncluded)

Between (or range).

Parameters:: datapoint - returns the datapoint to check range; lowBoundary - returns values for the lower boundary; highBoundary - returns values for the upper boundary; isLowIncluded - true to indicate lower boundary itself is included in the range; isHighIncluded - true to indicate upper boundary itself is included in the range
Returns:: expression

or

public static Disjunction or()

Logical OR disjunction. Use add methods to add expressions.

Returns:: expression

or

public static Disjunction or(Expression first,
                             Expression second,
                             Expression... expressions)

Logical OR disjunction.

Parameters:: first - an expression returning values to junction; second - an expression returning values to junction; expressions - an optional list of expressions returning values to junction
Returns:: expression

and

public static Conjunction and()

Logical AND conjunction. Use add methods to add expressions.

Returns:: expression

and

public static Conjunction and(Expression first,
                              Expression second,
                              Expression... expressions)

Logical AND conjunction.

Parameters:: first - an expression returning values to junction; second - an expression returning values to junction; expressions - an optional list of expressions returning values to junction
Returns:: expression

ge

public static RelationalOpExpression ge(java.lang.String propertyName,
                                        java.lang.Object value)

Greater-or-equal between a property and a constant.

Parameters:: propertyName - the name of the property providing left hand side values; value - is the constant to compare
Returns:: expression

ge

public static RelationalOpExpression ge(Expression left,
                                        Expression right)

Greater-or-equals between expression results.

Parameters:: left - the expression providing left hand side values; right - the expression providing right hand side values
Returns:: expression

geProperty

public static RelationalOpExpression geProperty(java.lang.String propertyLeft,
                                                java.lang.String propertyRight)

Greater-or-equal between properties.

Parameters:: propertyLeft - the name of the property providing left hand side values; propertyRight - the name of the property providing right hand side values
Returns:: expression

gt

public static RelationalOpExpression gt(java.lang.String propertyName,
                                        java.lang.Object value)

Greater-then between a property and a constant.

Parameters:: propertyName - the name of the property providing left hand side values; value - is the constant to compare
Returns:: expression

gt

public static RelationalOpExpression gt(Expression left,
                                        Expression right)

Greater-then between expression results.

Parameters:: left - the expression providing left hand side values; right - the expression providing right hand side values
Returns:: expression

gtProperty

public static RelationalOpExpression gtProperty(java.lang.String propertyLeft,
                                                java.lang.String propertyRight)

Greater-then between properties.

Parameters:: propertyLeft - the name of the property providing left hand side values; propertyRight - the name of the property providing right hand side values
Returns:: expression

le

public static RelationalOpExpression le(java.lang.String propertyName,
                                        java.lang.Object value)

Less-or-equals between a property and a constant.

Parameters:: propertyName - the name of the property providing left hand side values; value - is the constant to compare
Returns:: expression

leProperty

public static RelationalOpExpression leProperty(java.lang.String propertyLeft,
                                                java.lang.String propertyRight)

Less-or-equal between properties.

Parameters:: propertyLeft - the name of the property providing left hand side values; propertyRight - the name of the property providing right hand side values
Returns:: expression

le

public static RelationalOpExpression le(Expression left,
                                        Expression right)

Less-or-equal between expression results.

Parameters:: left - the expression providing left hand side values; right - the expression providing right hand side values
Returns:: expression

lt

public static RelationalOpExpression lt(java.lang.String propertyName,
                                        java.lang.Object value)

Less-then between a property and a constant.

Parameters:: propertyName - the name of the property providing left hand side values; value - is the constant to compare
Returns:: expression

ltProperty

public static RelationalOpExpression ltProperty(java.lang.String propertyLeft,
                                                java.lang.String propertyRight)

Less-then between properties.

Parameters:: propertyLeft - the name of the property providing left hand side values; propertyRight - the name of the property providing right hand side values
Returns:: expression

lt

public static RelationalOpExpression lt(Expression left,
                                        Expression right)

Less-then between expression results.

Parameters:: left - the expression providing left hand side values; right - the expression providing right hand side values
Returns:: expression

eq

public static RelationalOpExpression eq(java.lang.String propertyName,
                                        java.lang.Object value)

Equals between a property and a constant.

Parameters:: propertyName - the name of the property providing left hand side values; value - is the constant to compare
Returns:: expression

neq

public static RelationalOpExpression neq(java.lang.String propertyName,
                                         java.lang.Object value)

Not-Equals between a property and a constant.

Parameters:: propertyName - the name of the property providing left hand side values; value - is the constant to compare
Returns:: expression

eqProperty

public static RelationalOpExpression eqProperty(java.lang.String propertyLeft,
                                                java.lang.String propertyRight)

Equals between properties.

Parameters:: propertyLeft - the name of the property providing left hand side values; propertyRight - the name of the property providing right hand side values
Returns:: expression

neqProperty

public static RelationalOpExpression neqProperty(java.lang.String propertyLeft,
                                                 java.lang.String propertyRight)

Not-Equals between properties.

Parameters:: propertyLeft - the name of the property providing left hand side values; propertyRight - the name of the property providing right hand side values
Returns:: expression

eq

public static RelationalOpExpression eq(Expression left,
                                        Expression right)

Equals between expression results.

Parameters:: left - the expression providing left hand side values; right - the expression providing right hand side values
Returns:: expression

neq

public static RelationalOpExpression neq(Expression left,
                                         Expression right)

Not-Equals between expression results.

Parameters:: left - the expression providing left hand side values; right - the expression providing right hand side values
Returns:: expression

isNotNull

public static RelationalOpExpression isNotNull(java.lang.String property)

Not-null test.

Parameters:: property - the name of the property supplying the value to check for null
Returns:: expression

isNotNull

public static RelationalOpExpression isNotNull(Expression expression)

Not-null test.

Parameters:: expression - supplies the value to check for null
Returns:: expression

isNull

public static RelationalOpExpression isNull(java.lang.String property)

Is-null test.

Parameters:: property - the name of the property supplying the value to check for null
Returns:: expression

isNull

public static RelationalOpExpression isNull(Expression expression)

Is-null test.

Parameters:: expression - supplies the value to check for null
Returns:: expression

property

public static PropertyValueExpression property(java.lang.String propertyName)

Property value.

An expression that returns the value of the named property.

Nested, indexed or mapped properties follow the documented sytnax.

Parameters:: propertyName - is the name of the property to return the value for.
Returns:: expression

like

public static LikeExpression like(java.lang.String propertyName,
                                  java.lang.String value)

SQL-Like.

Parameters:: propertyName - the name of the property providing values to match; value - is the string to match against
Returns:: expression

like

public static LikeExpression like(Expression left,
                                  Expression right)

SQL-Like.

Parameters:: left - provides value to match; right - provides string to match against
Returns:: expression

like

public static LikeExpression like(java.lang.String propertyName,
                                  java.lang.Object value,
                                  java.lang.String escape)

SQL-Like.

Parameters:: propertyName - the name of the property providing values to match; value - is the string to match against; escape - the escape character(s)
Returns:: expression

like

public static LikeExpression like(Expression left,
                                  Expression right,
                                  Expression escape)

SQL-Like.

Parameters:: left - provides value to match; right - provides string to match against; escape - the escape character(s)
Returns:: expression

notLike

public static LikeExpression notLike(java.lang.String propertyName,
                                     java.lang.String value)

SQL-Like negated (not like).

Parameters:: propertyName - the name of the property providing values to match; value - is the string to match against
Returns:: expression

notLike

public static LikeExpression notLike(Expression left,
                                     Expression right)

SQL-Like negated (not like).

Parameters:: left - provides value to match; right - provides string to match against
Returns:: expression

notLike

public static LikeExpression notLike(java.lang.String propertyName,
                                     java.lang.Object value,
                                     java.lang.String escape)

SQL-Like negated (not like).

Parameters:: propertyName - the name of the property providing values to match; value - is the string to match against; escape - the escape character(s)
Returns:: expression

notLike

public static LikeExpression notLike(Expression left,
                                     Expression right,
                                     Expression escape)

SQL-Like negated (not like).

Parameters:: left - provides value to match; right - provides string to match against; escape - the escape character(s)
Returns:: expression

avg

public static AvgProjectionExpression avg(java.lang.String propertyName)

Average aggregation function.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

avg

public static AvgProjectionExpression avg(Expression expression)

Average aggregation function.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

avgDistinct

public static AvgProjectionExpression avgDistinct(java.lang.String propertyName)

Average aggregation function considering distinct values only.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

avgDistinct

public static AvgProjectionExpression avgDistinct(Expression expression)

Average aggregation function considering distinct values only.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

median

public static MedianProjectionExpression median(java.lang.String propertyName)

Median aggregation function.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

median

public static MedianProjectionExpression median(Expression expression)

Median aggregation function.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

medianDistinct

public static MedianProjectionExpression medianDistinct(java.lang.String propertyName)

Median aggregation function considering distinct values only.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

medianDistinct

public static MedianProjectionExpression medianDistinct(Expression expression)

Median aggregation function considering distinct values only.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

stddev

public static StddevProjectionExpression stddev(java.lang.String propertyName)

Standard deviation aggregation function.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

stddev

public static StddevProjectionExpression stddev(Expression expression)

Standard deviation aggregation function.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

stddevDistinct

public static StddevProjectionExpression stddevDistinct(java.lang.String propertyName)

Standard deviation function considering distinct values only.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

stddevDistinct

public static StddevProjectionExpression stddevDistinct(Expression expression)

Standard deviation function considering distinct values only.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

avedev

public static AvedevProjectionExpression avedev(java.lang.String propertyName)

Mean deviation aggregation function.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

lastEver

public static LastEverProjectionExpression lastEver(java.lang.String propertyName)

Lastever-value aggregation function.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

last

public static LastProjectionExpression last(java.lang.String propertyName)

Lastever-value aggregation function.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

lastEver

public static LastEverProjectionExpression lastEver(Expression expression)

Lastever-value aggregation function.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

last

public static LastProjectionExpression last(Expression expression)

Lastever-value aggregation function.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

first

public static FirstProjectionExpression first(java.lang.String propertyName)

First-value (windowed) aggregation function.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

firstEver

public static FirstEverProjectionExpression firstEver(java.lang.String propertyName)

First-value (ever) aggregation function.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

first

public static FirstProjectionExpression first(Expression expression)

First-value (in window) aggregation function.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

firstEver

public static FirstEverProjectionExpression firstEver(Expression expression)

First-value (ever) aggregation function.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

avedev

public static AvedevProjectionExpression avedev(Expression expression)

Mean deviation aggregation function.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

avedevDistinct

public static AvedevProjectionExpression avedevDistinct(java.lang.String propertyName)

Mean deviation function considering distinct values only.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

avedevDistinct

public static AvedevProjectionExpression avedevDistinct(Expression expression)

Mean deviation function considering distinct values only.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

sum

public static SumProjectionExpression sum(java.lang.String propertyName)

Sum aggregation function.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

sum

public static SumProjectionExpression sum(Expression expression)

Sum aggregation function.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

sumDistinct

public static SumProjectionExpression sumDistinct(java.lang.String propertyName)

Sum aggregation function considering distinct values only.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

sumDistinct

public static SumProjectionExpression sumDistinct(Expression expression)

Sum aggregation function considering distinct values only.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

countStar

public static CountStarProjectionExpression countStar()

Count aggregation function not counting values, equivalent to "count(*)".

Returns:: expression

count

public static CountProjectionExpression count(java.lang.String propertyName)

Count aggregation function.

Parameters:: propertyName - name of the property providing the values to count.
Returns:: expression

count

public static CountProjectionExpression count(Expression expression)

Count aggregation function.

Parameters:: expression - provides the values to count.
Returns:: expression

countDistinct

public static CountProjectionExpression countDistinct(java.lang.String propertyName)

Count aggregation function considering distinct values only.

Parameters:: propertyName - name of the property providing the values to count.
Returns:: expression

countDistinct

public static CountProjectionExpression countDistinct(Expression expression)

Count aggregation function considering distinct values only.

Parameters:: expression - provides the values to count.
Returns:: expression

min

public static MinProjectionExpression min(java.lang.String propertyName)

Minimum aggregation function.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

min

public static MinProjectionExpression min(Expression expression)

Minimum aggregation function.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

minDistinct

public static MinProjectionExpression minDistinct(java.lang.String propertyName)

Minimum aggregation function considering distinct values only.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

minDistinct

public static MinProjectionExpression minDistinct(Expression expression)

Minimum aggregation function considering distinct values only.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

max

public static MaxProjectionExpression max(java.lang.String propertyName)

Maximum aggregation function.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

max

public static MaxProjectionExpression max(Expression expression)

Maximum aggregation function.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

maxDistinct

public static MaxProjectionExpression maxDistinct(java.lang.String propertyName)

Maximum aggregation function considering distinct values only.

Parameters:: propertyName - name of the property providing the values to aggregate.
Returns:: expression

maxDistinct

public static MaxProjectionExpression maxDistinct(Expression expression)

Maximum aggregation function considering distinct values only.

Parameters:: expression - provides the values to aggregate.
Returns:: expression

modulo

public static ArithmaticExpression modulo(Expression left,
                                          Expression right)

Modulo.

Parameters:: left - the expression providing left hand values; right - the expression providing right hand values
Returns:: expression

modulo

public static ArithmaticExpression modulo(java.lang.String propertyLeft,
                                          java.lang.String propertyRight)

Modulo.

Parameters:: propertyLeft - the name of the property providing left hand values; propertyRight - the name of the property providing right hand values
Returns:: expression

minus

public static ArithmaticExpression minus(Expression left,
                                         Expression right)

Subtraction.

Parameters:: left - the expression providing left hand values; right - the expression providing right hand values
Returns:: expression

minus

public static ArithmaticExpression minus(java.lang.String propertyLeft,
                                         java.lang.String propertyRight)

Subtraction.

Parameters:: propertyLeft - the name of the property providing left hand values; propertyRight - the name of the property providing right hand values
Returns:: expression

plus

public static ArithmaticExpression plus(Expression left,
                                        Expression right)

Addition.

Parameters:: left - the expression providing left hand values; right - the expression providing right hand values
Returns:: expression

plus

public static ArithmaticExpression plus(java.lang.String propertyLeft,
                                        java.lang.String propertyRight)

Addition.

Parameters:: propertyLeft - the name of the property providing left hand values; propertyRight - the name of the property providing right hand values
Returns:: expression

multiply

public static ArithmaticExpression multiply(Expression left,
                                            Expression right)

Multiplication.

Parameters:: left - the expression providing left hand values; right - the expression providing right hand values
Returns:: expression

multiply

public static ArithmaticExpression multiply(java.lang.String propertyLeft,
                                            java.lang.String propertyRight)

Multiplication.

Parameters:: propertyLeft - the name of the property providing left hand values; propertyRight - the name of the property providing right hand values
Returns:: expression

divide

public static ArithmaticExpression divide(Expression left,
                                          Expression right)

Division.

Parameters:: left - the expression providing left hand values; right - the expression providing right hand values
Returns:: expression

divide

public static ArithmaticExpression divide(java.lang.String propertyLeft,
                                          java.lang.String propertyRight)

Division.

Parameters:: propertyLeft - the name of the property providing left hand values; propertyRight - the name of the property providing right hand values
Returns:: expression

concat

public static ConcatExpression concat(java.lang.String property,
                                      java.lang.String... properties)

Concatenation.

Parameters:: property - the name of property returning values to concatenate; properties - the names of additional properties returning values to concatenate
Returns:: expression

subquery

public static SubqueryExpression subquery(EPStatementObjectModel model)

Subquery.

Parameters:: model - is the object model of the lookup
Returns:: expression

subqueryIn

public static SubqueryInExpression subqueryIn(java.lang.String property,
                                              EPStatementObjectModel model)

Subquery with in-clause, represents the syntax of "value in (select ... from ...)".

Parameters:: property - is the name of the property that returns the value to match against the values returned by the lookup; model - is the object model of the lookup
Returns:: expression

subqueryNotIn

public static SubqueryInExpression subqueryNotIn(java.lang.String property,
                                                 EPStatementObjectModel model)

Subquery with not-in-clause, represents the syntax of "value not in (select ... from ...)".

Parameters:: property - is the name of the property that returns the value to match against the values returned by the lookup; model - is the object model of the lookup
Returns:: expression

subqueryExists

public static SubqueryExistsExpression subqueryExists(EPStatementObjectModel model)

Subquery with exists-clause, represents the syntax of "select * from ... where exists (select ... from ...)".

Parameters:: model - is the object model of the lookup
Returns:: expression

subqueryIn

public static SubqueryInExpression subqueryIn(Expression expression,
                                              EPStatementObjectModel model)

Subquery with in-clause, represents the syntax of "value in (select ... from ...)".

Parameters:: expression - returns the value to match against the values returned by the lookup; model - is the object model of the lookup
Returns:: expression

subqueryNotIn

public static SubqueryInExpression subqueryNotIn(Expression expression,
                                                 EPStatementObjectModel model)

Subquery with not-in-clause, represents the syntax of "value not in (select ... from ...)".

Parameters:: expression - returns the value to match against the values returned by the lookup; model - is the object model of the lookup
Returns:: expression

timePeriod

public static TimePeriodExpression timePeriod(java.lang.Double days,
                                              java.lang.Double hours,
                                              java.lang.Double minutes,
                                              java.lang.Double seconds,
                                              java.lang.Double milliseconds)

Returns a time period expression for the specified parts.

Each part can be a null value in which case the part is left out.

Parameters:: days - day part; hours - hour part; minutes - minute part; seconds - seconds part; milliseconds - milliseconds part
Returns:: time period expression

timePeriod

public static TimePeriodExpression timePeriod(java.lang.Object days,
                                              java.lang.Object hours,
                                              java.lang.Object minutes,
                                              java.lang.Object seconds,
                                              java.lang.Object milliseconds)

Returns a time period expression for the specified parts.

Each part can be a null value in which case the part is left out.

Each object value may be a String value for an event property, or a number for a constant.

Parameters:: days - day part; hours - hour part; minutes - minute part; seconds - seconds part; milliseconds - milliseconds part
Returns:: time period expression

crontabScheduleWildcard

public static CrontabParameterExpression crontabScheduleWildcard()

Creates a wildcard parameter.

Returns:: parameter

crontabScheduleItem

public static CrontabParameterExpression crontabScheduleItem(java.lang.Integer parameter,
                                                             ScheduleItemType type)

Creates a parameter of the given type and parameterized by a number.

Parameters:: parameter - the constant parameter for the type; type - the type of crontab parameter
Returns:: crontab parameter

crontabScheduleFrequency

public static CrontabFrequencyExpression crontabScheduleFrequency(int frequency)

Creates a frequency cron parameter.

Parameters:: frequency - the constant for the frequency
Returns:: cron parameter

crontabScheduleRange

public static CrontabRangeExpression crontabScheduleRange(int lowerBounds,
                                                          int upperBounds)

Creates a range cron parameter.

Parameters:: lowerBounds - the lower bounds; upperBounds - the upper bounds
Returns:: crontab parameter

toPropertyExpressions

protected static java.util.List<PropertyValueExpression> toPropertyExpressions(java.lang.String... properties)

Returns a list of expressions returning property values for the property names passed in.

Parameters:: properties - is a list of property names
Returns:: list of property value expressions

getPropExpr

protected static PropertyValueExpression getPropExpr(java.lang.String propertyName)

Returns an expression returning the propertyName value for the propertyName name passed in.

Parameters:: propertyName - the name of the property returning property values
Returns:: expression

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.espertech.esper.client.soda Class Expressions

Expressions

currentTimestamp

existsProperty

cast

cast

instanceOf

instanceOf

typeOf

typeOf

plugInAggregation

regexp

regexp

regexp

regexp

notRegexp

notRegexp

notRegexp

notRegexp

array

binaryAnd

binaryOr

binaryXor

min

min

max

max

coalesce

coalesce

constant

constant

caseWhenThen

caseSwitch

caseSwitch

in

notIn

in

notIn

not

staticMethod

staticMethod

prior

previous

previous

previousTail

previousTail

previousCount

previousWindow

betweenProperty

between

between

range

or

or

and

and

ge

ge

geProperty

gt

gt

gtProperty

le

leProperty

le

lt

ltProperty

lt

eq

neq

eqProperty

neqProperty

eq

neq

isNotNull

isNotNull

isNull

isNull

property

like

com.espertech.esper.client.soda
Class Expressions