Package | Description |
---|---|
com.couchbase.client.java.bucket | |
com.couchbase.client.java.query | |
com.couchbase.client.java.query.dsl | |
com.couchbase.client.java.query.dsl.clause |
Clauses are mini-DSL that can help you produce a well-formed
Expression for specific parts of some N1QL statement, aka clauses. |
com.couchbase.client.java.query.dsl.element | |
com.couchbase.client.java.query.dsl.functions |
Functions are
Expressions that represent predefined utility functions in N1QL. |
com.couchbase.client.java.query.dsl.path | |
com.couchbase.client.java.query.dsl.path.index |
Modifier and Type | Method and Description |
---|---|
rx.Observable<Boolean> |
AsyncBucketManager.createN1qlIndex(String indexName,
List<Object> fields,
Expression whereClause,
boolean ignoreIfExist,
boolean defer)
Create a secondary index for the current bucket, with a WHERE clause.
|
boolean |
BucketManager.createN1qlIndex(String indexName,
List<Object> fields,
Expression whereClause,
boolean ignoreIfExist,
boolean defer)
Create a secondary index for the current bucket, with the default management timeout.
|
boolean |
BucketManager.createN1qlIndex(String indexName,
List<Object> fields,
Expression whereClause,
boolean ignoreIfExist,
boolean defer,
long timeout,
TimeUnit timeUnit)
Create a secondary index for the current bucket, with a custom timeout.
|
rx.Observable<Boolean> |
DefaultAsyncBucketManager.createN1qlIndex(String indexName,
List<Object> fields,
Expression whereClause,
boolean ignoreIfExist,
boolean defer) |
boolean |
DefaultBucketManager.createN1qlIndex(String indexName,
List<Object> fields,
Expression whereClause,
boolean ignoreIfExist,
boolean defer) |
boolean |
DefaultBucketManager.createN1qlIndex(String indexName,
List<Object> fields,
Expression whereClause,
boolean ignoreIfExist,
boolean defer,
long timeout,
TimeUnit timeUnit) |
Modifier and Type | Method and Description |
---|---|
static DeleteUsePath |
Delete.deleteFrom(Expression bucket) |
static InitialInsertPath |
Insert.insertInto(Expression bucket) |
static MergeSourcePath |
Merge.mergeInto(Expression bucket) |
static FromPath |
Select.select(Expression... expressions) |
static FromPath |
Select.selectAll(Expression... expressions) |
static FromPath |
Select.selectDistinct(Expression... expressions) |
static FromPath |
Select.selectRaw(Expression expression) |
static UpdateUsePath |
Update.update(Expression bucket) |
static InitialInsertPath |
Upsert.upsertInto(Expression bucket) |
Modifier and Type | Method and Description |
---|---|
Expression |
Expression.add(Expression expression)
Arithmetic addition between current and given expression.
|
Expression |
Expression.add(Number b)
Arithmetic addition between current expression and a given number.
|
Expression |
Expression.add(String expression)
Arithmetic addition between current and given expression.
|
Expression |
Expression.and(boolean right)
AND-combines two expressions.
|
Expression |
Expression.and(double right)
AND-combines two expressions.
|
Expression |
Expression.and(float right)
AND-combines two expressions.
|
Expression |
Expression.and(int right)
AND-combines two expressions.
|
Expression |
Expression.and(long right)
AND-combines two expressions.
|
Expression |
Expression.and(JsonArray right)
AND-combines two expressions.
|
Expression |
Expression.and(JsonObject right)
AND-combines two expressions.
|
Expression |
Expression.and(Expression right)
AND-combines two expressions.
|
Expression |
Expression.and(String right)
AND-combines two expressions.
|
Expression |
Expression.as(Expression alias)
Adds a AS clause between the current and the given expression.
|
Expression |
Expression.as(String alias)
Adds a AS clause between the current and the given expression.
|
Expression |
Expression.between(boolean right)
Adds a BETWEEN clause between the current and the given expression.
|
Expression |
Expression.between(double right)
Adds a BETWEEN clause between the current and the given expression.
|
Expression |
Expression.between(float right)
Adds a BETWEEN clause between the current and the given expression.
|
Expression |
Expression.between(int right)
Adds a BETWEEN clause between the current and the given expression.
|
Expression |
Expression.between(long right)
Adds a BETWEEN clause between the current and the given expression.
|
Expression |
Expression.between(JsonArray right)
Adds a BETWEEN clause between the current and the given expression.
|
Expression |
Expression.between(JsonObject right)
Adds a BETWEEN clause between the current and the given expression.
|
Expression |
Expression.between(Expression right)
Adds a BETWEEN clause between the current and the given expression.
|
Expression |
Expression.between(String right)
Adds a BETWEEN clause between the current and the given expression.
|
Expression |
Expression.concat(boolean right)
Combines two expressions with the concatenation operator (“||”).
|
Expression |
Expression.concat(double right)
Combines two expressions with the concatenation operator (“||”).
|
Expression |
Expression.concat(float right)
Combines two expressions with the concatenation operator (“||”).
|
Expression |
Expression.concat(int right)
Combines two expressions with the concatenation operator (“||”).
|
Expression |
Expression.concat(long right)
Combines two expressions with the concatenation operator (“||”).
|
Expression |
Expression.concat(JsonArray right)
Combines two expressions with the concatenation operator (“||”).
|
Expression |
Expression.concat(JsonObject right)
Combines two expressions with the concatenation operator (“||”).
|
Expression |
Expression.concat(Expression right)
Combines two expressions with the concatenation operator (“||”).
|
Expression |
Expression.concat(String right)
Combines two expressions with the concatenation operator (“||”).
|
Expression |
Expression.divide(Expression expression)
Arithmetic division between current and given expression.
|
Expression |
Expression.divide(Number b)
Arithmetic division between current expression and a given number.
|
Expression |
Expression.divide(String expression)
Arithmetic division between current and given expression.
|
Expression |
Expression.eq(boolean right)
Combines two expressions with the equals operator (“=”).
|
Expression |
Expression.eq(double right)
Combines two expressions with the equals operator (“=”).
|
Expression |
Expression.eq(float right)
Combines two expressions with the equals operator (“=”).
|
Expression |
Expression.eq(int right)
Combines two expressions with the equals operator (“=”).
|
Expression |
Expression.eq(long right)
Combines two expressions with the equals operator (“=”).
|
Expression |
Expression.eq(JsonArray right)
Combines two expressions with the equals operator (“=”).
|
Expression |
Expression.eq(JsonObject right)
Combines two expressions with the equals operator (“=”).
|
Expression |
Expression.eq(Expression right)
Combines two expressions with the equals operator (“=”).
|
Expression |
Expression.eq(String right)
Combines two expressions with the equals operator (“=”).
|
Expression |
Expression.exists()
Prefixes the current expression with the EXISTS clause.
|
static Expression |
Expression.FALSE()
Returns an expression representing boolean FALSE.
|
Expression |
Expression.get(Expression expression)
Get attribute of an object using the given expression as attribute name.
|
Expression |
Expression.get(String expression)
Get attribute of an object using the given string as attribute name.
|
Expression |
Expression.gt(boolean right)
Combines two expressions with the greater than operator (“>”).
|
Expression |
Expression.gt(double right)
Combines two expressions with the greater than operator (“>”).
|
Expression |
Expression.gt(float right)
Combines two expressions with the greater than operator (“>”).
|
Expression |
Expression.gt(int right)
Combines two expressions with the greater than operator (“>”).
|
Expression |
Expression.gt(long right)
Combines two expressions with the greater than operator (“>”).
|
Expression |
Expression.gt(JsonArray right)
Combines two expressions with the greater than operator (“>”).
|
Expression |
Expression.gt(JsonObject right)
Combines two expressions with the greater than operator (“>”).
|
Expression |
Expression.gt(Expression right)
Combines two expressions with the greater than operator (“>”).
|
Expression |
Expression.gt(String right)
Combines two expressions with the greater than operator (“>”).
|
Expression |
Expression.gte(boolean right)
Combines two expressions with the greater or equals than operator (“>=”).
|
Expression |
Expression.gte(double right)
Combines two expressions with the greater or equals than operator (“>=”).
|
Expression |
Expression.gte(float right)
Combines two expressions with the greater or equals than operator (“>=”).
|
Expression |
Expression.gte(int right)
Combines two expressions with the greater or equals than operator (“>=”).
|
Expression |
Expression.gte(long right)
Combines two expressions with the greater or equals than operator (“>=”).
|
Expression |
Expression.gte(JsonArray right)
Combines two expressions with the greater or equals than operator (“>=”).
|
Expression |
Expression.gte(JsonObject right)
Combines two expressions with the greater or equals than operator (“>=”).
|
Expression |
Expression.gte(Expression right)
Combines two expressions with the greater or equals than operator (“>=”).
|
Expression |
Expression.gte(String right)
Combines two expressions with the greater or equals than operator (“>=”).
|
static Expression |
Expression.i(String... identifiers)
An identifier or list of identifiers escaped using backquotes `.
|
Expression |
Expression.in(boolean right)
Adds a IN clause between the current and the given expression.
|
Expression |
Expression.in(double right)
Adds a IN clause between the current and the given expression.
|
Expression |
Expression.in(float right)
Adds a IN clause between the current and the given expression.
|
Expression |
Expression.in(int right)
Adds a IN clause between the current and the given expression.
|
Expression |
Expression.in(long right)
Adds a IN clause between the current and the given expression.
|
Expression |
Expression.in(JsonArray right)
Adds a IN clause between the current and the given expression.
|
Expression |
Expression.in(JsonObject right)
Adds a IN clause between the current and the given expression.
|
Expression |
Expression.in(Expression right)
Adds a IN clause between the current and the given expression.
|
Expression |
Expression.in(String right)
Adds a IN clause between the current and the given expression.
|
Expression |
Expression.isMissing()
Appends a “IS MISSING” to the expression.
|
Expression |
Expression.isNotMissing()
Appends a “IS NOT MISSING” to the expression.
|
Expression |
Expression.isNotNull()
Appends a “IS NOT NULL” to the expression.
|
Expression |
Expression.isNotValued()
Appends a “IS NOT VALUED” to the expression.
|
Expression |
Expression.isNull()
Appends a “IS NULL” to the expression.
|
Expression |
Expression.isValued()
Appends a “IS VALUED” to the expression.
|
Expression |
Expression.like(boolean right)
Adds a LIKE clause between the current and the given expression.
|
Expression |
Expression.like(double right)
Adds a LIKE clause between the current and the given expression.
|
Expression |
Expression.like(float right)
Adds a LIKE clause between the current and the given expression.
|
Expression |
Expression.like(int right)
Adds a LIKE clause between the current and the given expression.
|
Expression |
Expression.like(long right)
Adds a LIKE clause between the current and the given expression.
|
Expression |
Expression.like(JsonArray right)
Adds a LIKE clause between the current and the given expression.
|
Expression |
Expression.like(JsonObject right)
Adds a LIKE clause between the current and the given expression.
|
Expression |
Expression.like(Expression right)
Adds a LIKE clause between the current and the given expression.
|
Expression |
Expression.like(String right)
Adds a LIKE clause between the current and the given expression.
|
Expression |
Expression.lt(boolean right)
Combines two expressions with the less than operator (“<”).
|
Expression |
Expression.lt(double right)
Combines two expressions with the less than operator (“<”).
|
Expression |
Expression.lt(float right)
Combines two expressions with the less than operator (“<”).
|
Expression |
Expression.lt(int right)
Combines two expressions with the less than operator (“<”).
|
Expression |
Expression.lt(long right)
Combines two expressions with the less than operator (“<”).
|
Expression |
Expression.lt(JsonArray right)
Combines two expressions with the less than operator (“<”).
|
Expression |
Expression.lt(JsonObject right)
Combines two expressions with the less than operator (“<”).
|
Expression |
Expression.lt(Expression right)
Combines two expressions with the less than operator (“<”).
|
Expression |
Expression.lt(String right)
Combines two expressions with the less than operator (“<”).
|
Expression |
Expression.lte(boolean right)
Combines two expressions with the less or equals than operator (“<=”).
|
Expression |
Expression.lte(double right)
Combines two expressions with the less or equals than operator (“<=”).
|
Expression |
Expression.lte(float right)
Combines two expressions with the less or equals than operator (“<=”).
|
Expression |
Expression.lte(int right)
Combines two expressions with the less or equals than operator (“<=”).
|
Expression |
Expression.lte(long right)
Combines two expressions with the less or equals than operator (“<=”).
|
Expression |
Expression.lte(JsonArray right)
Combines two expressions with the less or equals than operator (“<=”).
|
Expression |
Expression.lte(JsonObject right)
Combines two expressions with the less or equals than operator (“<=”).
|
Expression |
Expression.lte(Expression right)
Combines two expressions with the less or equals than operator (“<=”).
|
Expression |
Expression.lte(String right)
Combines two expressions with the less or equals than operator (“<=”).
|
static Expression |
Expression.MISSING()
Returns an expression representing MISSING.
|
Expression |
Expression.multiply(Expression expression)
Arithmetic multiplication between current and given expression.
|
Expression |
Expression.multiply(Number b)
Arithmetic multiplication between current expression and a given number.
|
Expression |
Expression.multiply(String expression)
Arithmetic multiplication between current and given expression.
|
Expression |
Expression.ne(double right)
Combines two expressions with the not equals operator (“!=”).
|
Expression |
Expression.ne(float right)
Combines two expressions with the not equals operator (“!=”).
|
Expression |
Expression.ne(int right)
Combines two expressions with the not equals operator (“!=”).
|
Expression |
Expression.ne(long right)
Combines two expressions with the not equals operator (“!=”).
|
Expression |
Expression.ne(JsonArray right)
Combines two expressions with the not equals operator (“!=”).
|
Expression |
Expression.ne(JsonObject right)
Combines two expressions with the not equals operator (“!=”).
|
Expression |
Expression.ne(Expression right)
Combines two expressions with the not equals operator (“!=”).
|
Expression |
Expression.ne(String right)
Combines two expressions with the not equals operator (“!=”).
|
Expression |
Expression.not()
Negates the given expression by prefixing a NOT.
|
Expression |
Expression.notBetween(boolean right)
Adds a NOT BETWEEN clause between the current and the given expression.
|
Expression |
Expression.notBetween(double right)
Adds a NOT BETWEEN clause between the current and the given expression.
|
Expression |
Expression.notBetween(float right)
Adds a NOT BETWEEN clause between the current and the given expression.
|
Expression |
Expression.notBetween(int right)
Adds a NOT BETWEEN clause between the current and the given expression.
|
Expression |
Expression.notBetween(long right)
Adds a NOT BETWEEN clause between the current and the given expression.
|
Expression |
Expression.notBetween(JsonArray right)
Adds a NOT BETWEEN clause between the current and the given expression.
|
Expression |
Expression.notBetween(JsonObject right)
Adds a NOT BETWEEN clause between the current and the given expression.
|
Expression |
Expression.notBetween(Expression right)
Adds a NOT BETWEEN clause between the current and the given expression.
|
Expression |
Expression.notBetween(String right)
Adds a NOT BETWEEN clause between the current and the given expression.
|
Expression |
Expression.notIn(boolean right)
Adds a NOT IN clause between the current and the given expression.
|
Expression |
Expression.notIn(double right)
Adds a NOT IN clause between the current and the given expression.
|
Expression |
Expression.notIn(float right)
Adds a NOT IN clause between the current and the given expression.
|
Expression |
Expression.notIn(int right)
Adds a NOT IN clause between the current and the given expression.
|
Expression |
Expression.notIn(long right)
Adds a NOT IN clause between the current and the given expression.
|
Expression |
Expression.notIn(JsonArray right)
Adds a NOT IN clause between the current and the given expression.
|
Expression |
Expression.notIn(JsonObject right)
Adds a NOT IN clause between the current and the given expression.
|
Expression |
Expression.notIn(Expression right)
Adds a NOT IN clause between the current and the given expression.
|
Expression |
Expression.notIn(String right)
Adds a NOT IN clause between the current and the given expression.
|
Expression |
Expression.notLike(boolean right)
Adds a NOT LIKE clause between the current and the given expression.
|
Expression |
Expression.notLike(double right)
Adds a NOT LIKE clause between the current and the given expression.
|
Expression |
Expression.notLike(float right)
Adds a NOT LIKE clause between the current and the given expression.
|
Expression |
Expression.notLike(int right)
Adds a NOT LIKE clause between the current and the given expression.
|
Expression |
Expression.notLike(long right)
Adds a NOT LIKE clause between the current and the given expression.
|
Expression |
Expression.notLike(JsonArray right)
Adds a NOT LIKE clause between the current and the given expression.
|
Expression |
Expression.notLike(JsonObject right)
Adds a NOT LIKE clause between the current and the given expression.
|
Expression |
Expression.notLike(Expression right)
Adds a NOT LIKE clause between the current and the given expression.
|
Expression |
Expression.notLike(String right)
Adds a NOT LIKE clause between the current and the given expression.
|
static Expression |
Expression.NULL()
Returns an expression representing NULL.
|
Expression |
Expression.or(boolean right)
OR-combines two expressions.
|
Expression |
Expression.or(double right)
OR-combines two expressions.
|
Expression |
Expression.or(float right)
OR-combines two expressions.
|
Expression |
Expression.or(int right)
OR-combines two expressions.
|
Expression |
Expression.or(long right)
OR-combines two expressions.
|
Expression |
Expression.or(JsonArray right)
OR-combines two expressions.
|
Expression |
Expression.or(JsonObject right)
OR-combines two expressions.
|
Expression |
Expression.or(Expression right)
OR-combines two expressions.
|
Expression |
Expression.or(String right)
OR-combines two expressions.
|
static Expression |
Expression.par(Expression expression)
Puts an
Expression in parenthesis. |
static Expression |
Expression.path(Object... pathComponents)
Construct a path (“a.b.c”) from Expressions or values.
|
static Expression |
Expression.s(String... strings)
An identifier or list of identifiers which will be quoted as strings (with "").
|
static Expression |
Expression.sub(Statement statement)
Creates an expression from a given sub-
Statement , wrapping it in parenthesis. |
Expression |
Expression.subtract(Expression expression)
Arithmetic v between current and given expression.
|
Expression |
Expression.subtract(Number b)
Arithmetic subtraction between current expression and a given number.
|
Expression |
Expression.subtract(String expression)
Arithmetic subtraction between current and given expression.
|
static Expression |
Expression.TRUE()
Returns an expression representing boolean TRUE.
|
static Expression |
Expression.x(boolean value)
Creates an arbitrary expression from the given boolean value.
|
static Expression |
Expression.x(double value)
Creates an arbitrary expression from the given double value.
|
static Expression |
Expression.x(float value)
Creates an arbitrary expression from the given float value.
|
static Expression |
Expression.x(int value)
Creates an arbitrary expression from the given integer value.
|
static Expression |
Expression.x(long value)
Creates an arbitrary expression from the given long value.
|
static Expression |
Expression.x(JsonArray value)
Creates an arbitrary expression from the given json array.
|
static Expression |
Expression.x(JsonObject value)
Creates an arbitrary expression from the given json object.
|
static Expression |
Expression.x(Statement statement)
Creates an expression for a given
Statement , as is. |
static Expression |
Expression.x(Number number)
Creates an expression from a
Number , as is. |
static Expression |
Expression.x(String value)
Creates an arbitrary expression from the given string value.
|
Modifier and Type | Method and Description |
---|---|
Expression |
Expression.add(Expression expression)
Arithmetic addition between current and given expression.
|
static Alias |
Alias.alias(String alias,
Expression original) |
Expression |
Expression.and(Expression right)
AND-combines two expressions.
|
Expression |
Expression.as(Expression alias)
Adds a AS clause between the current and the given expression.
|
static Sort |
Sort.asc(Expression expression) |
Expression |
Expression.between(Expression right)
Adds a BETWEEN clause between the current and the given expression.
|
Expression |
Expression.concat(Expression right)
Combines two expressions with the concatenation operator (“||”).
|
static Sort |
Sort.def(Expression expression)
Use default sort, don’t specify an order in the resulting expression.
|
static Sort |
Sort.desc(Expression expression) |
Expression |
Expression.divide(Expression expression)
Arithmetic division between current and given expression.
|
Expression |
Expression.eq(Expression right)
Combines two expressions with the equals operator (“=”).
|
Expression |
Expression.get(Expression expression)
Get attribute of an object using the given expression as attribute name.
|
Expression |
Expression.gt(Expression right)
Combines two expressions with the greater than operator (“>”).
|
Expression |
Expression.gte(Expression right)
Combines two expressions with the greater or equals than operator (“>=”).
|
Expression |
Expression.in(Expression right)
Adds a IN clause between the current and the given expression.
|
Expression |
Expression.like(Expression right)
Adds a LIKE clause between the current and the given expression.
|
Expression |
Expression.lt(Expression right)
Combines two expressions with the less than operator (“<”).
|
Expression |
Expression.lte(Expression right)
Combines two expressions with the less or equals than operator (“<=”).
|
Expression |
Expression.multiply(Expression expression)
Arithmetic multiplication between current and given expression.
|
Expression |
Expression.ne(Expression right)
Combines two expressions with the not equals operator (“!=”).
|
Expression |
Expression.notBetween(Expression right)
Adds a NOT BETWEEN clause between the current and the given expression.
|
Expression |
Expression.notIn(Expression right)
Adds a NOT IN clause between the current and the given expression.
|
Expression |
Expression.notLike(Expression right)
Adds a NOT LIKE clause between the current and the given expression.
|
Expression |
Expression.or(Expression right)
OR-combines two expressions.
|
static Expression |
Expression.par(Expression expression)
Puts an
Expression in parenthesis. |
Expression |
Expression.subtract(Expression expression)
Arithmetic v between current and given expression.
|
Modifier and Type | Method and Description |
---|---|
Expression |
UpdateForClause.end()
Terminates the clause without a particular WHEN condition (“
END ”) and returns the corresponding Expression . |
Expression |
UpdateForClause.when(Expression condition)
Terminates the clause by adding a condition to it (“
WHEN condition END ”) and returns the corresponding Expression . |
Modifier and Type | Method and Description |
---|---|
Expression |
UpdateForClause.when(Expression condition)
Terminates the clause by adding a condition to it (“
WHEN condition END ”) and returns the corresponding Expression . |
Constructor and Description |
---|
GroupByElement(Expression[] expressions) |
HavingElement(Expression expression) |
InsertSelectElement(Expression key,
Expression value,
Statement select) |
InsertValueElement(InsertValueElement.InsertPosition position,
Expression id,
Expression value) |
KeysElement(KeysElement.ClauseType clauseType,
Expression expression) |
MergeInsertElement(Expression expression) |
OnElement(String namespace,
String keyspace,
Expression expression,
Expression[] additionalExpressions) |
ReturningElement(ReturningElement.ReturningType type,
Expression exp) |
SelectElement(SelectType selectType,
Expression... expressions) |
SetElement(SetElement.SetPosition insert,
Expression path,
Expression value,
Expression setFor) |
UnsetElement(UnsetElement.UnsetPosition insert,
Expression path,
Expression unsetFor) |
WhereElement(Expression expression) |
Modifier and Type | Method and Description |
---|---|
static Expression |
NumberFunctions.abs(Expression expression)
Returned expression results in the absolute value of the number.
|
static Expression |
NumberFunctions.abs(Number value)
Returned expression results in the absolute value of the number.
|
static Expression |
NumberFunctions.acos(Expression expression)
Returned expression results in the arccosine in radians.
|
static Expression |
NumberFunctions.acos(Number value)
Returned expression results in the arccosine in radians.
|
static Expression |
AggregateFunctions.arrayAgg(Expression expression)
Returned expression results in a array of the non-MISSING values in the group, including NULLs.
|
static Expression |
AggregateFunctions.arrayAgg(String expression)
Returned expression results in a array of the non-MISSING values in the group, including NULLs.
|
static Expression |
ArrayFunctions.arrayAppend(JsonArray array,
Expression value)
Returned expression results in new array with value appended.
|
static Expression |
ArrayFunctions.arrayAppend(Expression expression,
Expression value)
Returned expression results in new array with value appended.
|
static Expression |
ArrayFunctions.arrayAppend(String expression,
Expression value)
Returned expression results in new array with value appended.
|
static Expression |
ArrayFunctions.arrayAvg(JsonArray array)
Returned expression results in arithmetic mean (average) of all the non-NULL number values in the array, or NULL if there are no such values.
|
static Expression |
ArrayFunctions.arrayAvg(Expression expression)
Returned expression results in arithmetic mean (average) of all the non-NULL number values in the array, or NULL if there are no such values.
|
static Expression |
ArrayFunctions.arrayAvg(String expression)
Returned expression results in arithmetic mean (average) of all the non-NULL number values in the array, or NULL if there are no such values.
|
static Expression |
ArrayFunctions.arrayConcat(JsonArray array1,
JsonArray array2)
Returned expression results in new array with the concatenation of the input arrays.
|
static Expression |
ArrayFunctions.arrayConcat(Expression expression1,
Expression expression2)
Returned expression results in new array with the concatenation of the input arrays.
|
static Expression |
ArrayFunctions.arrayConcat(String expression1,
String expression2)
Returned expression results in new array with the concatenation of the input arrays.
|
static Expression |
ArrayFunctions.arrayContains(JsonArray array,
Expression value)
Returned expression results in true if the array contains value.
|
static Expression |
ArrayFunctions.arrayContains(Expression expression,
Expression value)
Returned expression results in true if the array contains value.
|
static Expression |
ArrayFunctions.arrayContains(String expression,
Expression value)
Returned expression results in true if the array contains value.
|
static Expression |
ArrayFunctions.arrayCount(JsonArray array)
Returned expression results in count of all the non-NULL values in the array, or zero if there are no such values.
|
static Expression |
ArrayFunctions.arrayCount(Expression expression)
Returned expression results in count of all the non-NULL values in the array, or zero if there are no such values.
|
static Expression |
ArrayFunctions.arrayCount(String expression)
Returned expression results in count of all the non-NULL values in the array, or zero if there are no such values.
|
static Expression |
ArrayFunctions.arrayDistinct(JsonArray array)
Returned expression results in new array with distinct elements of input array.
|
static Expression |
ArrayFunctions.arrayDistinct(Expression expression)
Returned expression results in new array with distinct elements of input array.
|
static Expression |
ArrayFunctions.arrayDistinct(String expression)
Returned expression results in new array with distinct elements of input array.
|
static Expression |
ArrayFunctions.arrayIfNull(JsonArray array)
Returned expression results in the first non-NULL value in the array, or NULL.
|
static Expression |
ArrayFunctions.arrayIfNull(Expression expression)
Returned expression results in the first non-NULL value in the array, or NULL.
|
static Expression |
ArrayFunctions.arrayIfNull(String expression)
Returned expression results in the first non-NULL value in the array, or NULL.
|
static Expression |
ArrayFunctions.arrayLength(JsonArray array)
Returned expression results in the number of elements in the array.
|
static Expression |
ArrayFunctions.arrayLength(Expression expression)
Returned expression results in the number of elements in the array.
|
static Expression |
ArrayFunctions.arrayLength(String expression)
Returned expression results in the number of elements in the array.
|
static Expression |
ArrayFunctions.arrayMax(JsonArray array)
Returned expression results in the largest non-NULL, non-MISSING array element, in N1QL collation order.
|
static Expression |
ArrayFunctions.arrayMax(Expression expression)
Returned expression results in the largest non-NULL, non-MISSING array element, in N1QL collation order.
|
static Expression |
ArrayFunctions.arrayMax(String expression)
Returned expression results in the largest non-NULL, non-MISSING array element, in N1QL collation order.
|
static Expression |
ArrayFunctions.arrayMin(JsonArray array)
Returned expression results in the smallest non-NULL, non-MISSING array element, in N1QL collation order.
|
static Expression |
ArrayFunctions.arrayMin(Expression expression)
Returned expression results in the smallest non-NULL, non-MISSING array element, in N1QL collation order.
|
static Expression |
ArrayFunctions.arrayMin(String expression)
Returned expression results in the smallest non-NULL, non-MISSING array element, in N1QL collation order.
|
static Expression |
ArrayFunctions.arrayPosition(JsonArray array,
Expression value)
Returned expression results in the first position of value within the array, or -1.
|
static Expression |
ArrayFunctions.arrayPosition(Expression expression,
Expression value)
Returned expression results in the first position of value within the array, or -1.
|
static Expression |
ArrayFunctions.arrayPosition(String expression,
Expression value)
Returned expression results in the first position of value within the array, or -1.
|
static Expression |
ArrayFunctions.arrayPrepend(JsonArray array,
Expression value)
Returned expression results in the new array with value pre-pended.
|
static Expression |
ArrayFunctions.arrayPrepend(Expression expression,
Expression value)
Returned expression results in the new array with value pre-pended.
|
static Expression |
ArrayFunctions.arrayPrepend(String expression,
Expression value)
Returned expression results in the new array with value pre-pended.
|
static Expression |
ArrayFunctions.arrayPut(JsonArray array,
Expression value)
Returned expression results in new array with value appended, if value is not already present, otherwise the unmodified input array.
|
static Expression |
ArrayFunctions.arrayPut(Expression expression,
Expression value)
Returned expression results in new array with value appended, if value is not already present, otherwise the unmodified input array.
|
static Expression |
ArrayFunctions.arrayPut(String expression,
Expression value)
Returned expression results in new array with value appended, if value is not already present, otherwise the unmodified input array.
|
static Expression |
ArrayFunctions.arrayRange(long start,
long end)
Returned expression results in new array of numbers, from start until the largest number less than end.
|
static Expression |
ArrayFunctions.arrayRange(long start,
long end,
long step)
Returned expression results in new array of numbers, from start until the largest number less than end.
|
static Expression |
ArrayFunctions.arrayRemove(JsonArray array,
Expression value)
Returned expression results in new array with all occurrences of value removed.
|
static Expression |
ArrayFunctions.arrayRemove(Expression expression,
Expression value)
Returned expression results in new array with all occurrences of value removed.
|
static Expression |
ArrayFunctions.arrayRemove(String expression,
Expression value)
Returned expression results in new array with all occurrences of value removed.
|
static Expression |
ArrayFunctions.arrayRepeat(boolean value,
long n)
Returned expression results in new array with value repeated n times.
|
static Expression |
ArrayFunctions.arrayRepeat(Expression value,
long n)
Returned expression results in new array with value repeated n times.
|
static Expression |
ArrayFunctions.arrayRepeat(Number value,
long n)
Returned expression results in new array with value repeated n times.
|
static Expression |
ArrayFunctions.arrayRepeat(String value,
long n)
Returned expression results in new array with the string “value” repeated n times.
|
static Expression |
ArrayFunctions.arrayReplace(JsonArray array,
Expression value1,
Expression value2)
Returned expression results in new array with all occurrences of value1 replaced by value2.
|
static Expression |
ArrayFunctions.arrayReplace(JsonArray array,
Expression value1,
Expression value2,
long n)
Returned expression results in new array with at most n occurrences of value1 replaced with value2.
|
static Expression |
ArrayFunctions.arrayReplace(Expression expression,
Expression value1,
Expression value2)
Returned expression results in new array with all occurrences of value1 replaced by value2.
|
static Expression |
ArrayFunctions.arrayReplace(Expression expression,
Expression value1,
Expression value2,
long n)
Returned expression results in new array with at most n occurrences of value1 replaced with value2.
|
static Expression |
ArrayFunctions.arrayReplace(String expression,
Expression value1,
Expression value2)
Returned expression results in new array with all occurrences of value1 replaced by value2.
|
static Expression |
ArrayFunctions.arrayReplace(String expression,
Expression value1,
Expression value2,
long n)
Returned expression results in new array with at most n occurrences of value1 replaced with value2.
|
static Expression |
ArrayFunctions.arrayReverse(JsonArray array)
Returned expression results in new array with all elements in reverse order.
|
static Expression |
ArrayFunctions.arrayReverse(Expression expression)
Returned expression results in new array with all elements in reverse order.
|
static Expression |
ArrayFunctions.arrayReverse(String expression)
Returned expression results in new array with all elements in reverse order.
|
static Expression |
ArrayFunctions.arraySort(JsonArray array)
Returned expression results in new array with elements sorted in N1QL collation order.
|
static Expression |
ArrayFunctions.arraySort(Expression expression)
Returned expression results in new array with elements sorted in N1QL collation order.
|
static Expression |
ArrayFunctions.arraySort(String expression)
Returned expression results in new array with elements sorted in N1QL collation order.
|
static Expression |
ArrayFunctions.arraySum(JsonArray array)
Returned expression results in the sum of all the non-NULL number values in the array, or zero if there are no such values.
|
static Expression |
ArrayFunctions.arraySum(Expression expression)
Returned expression results in the sum of all the non-NULL number values in the array, or zero if there are no such values.
|
static Expression |
ArrayFunctions.arraySum(String expression)
Returned expression results in the sum of all the non-NULL number values in the array, or zero if there are no such values.
|
static Expression |
NumberFunctions.asin(Expression expression)
Returned expression results in the arcsine in radians.
|
static Expression |
NumberFunctions.asin(Number value)
Returned expression results in the arcsine in radians.
|
static Expression |
NumberFunctions.atan(Expression expression)
Returned expression results in the arctangent in radians.
|
static Expression |
NumberFunctions.atan(Expression expression1,
Expression expression2)
Returned expression results in the arctangent of expression2/expression1.
|
static Expression |
NumberFunctions.atan(Number value)
Returned expression results in the arctangent in radians.
|
static Expression |
NumberFunctions.atan(String expression1,
String expression2)
Returned expression results in the arctangent of expression2/expression1.
|
static Expression |
AggregateFunctions.avg(Expression expression)
Returned expression results in the arithmetic mean (average) of all the distinct number values in the group.
|
static Expression |
AggregateFunctions.avg(String expression)
Returned expression results in the arithmetic mean (average) of all the distinct number values in the group.
|
static Expression |
MetaFunctions.base64(Expression expression) |
static Expression |
MetaFunctions.base64(String expression) |
protected static Expression |
ConditionalFunctions.build(String operator,
Expression expression1,
Expression expression2,
Expression... others) |
static Expression |
NumberFunctions.ceil(Expression expression)
Returned expression results in the smallest integer not less than the number.
|
static Expression |
NumberFunctions.ceil(Number value)
Returned expression results in the smallest integer not less than the number.
|
static Expression |
DateFunctions.clockMillis()
Returned expression results in system clock at function evaluation time, as UNIX milliseconds.
|
static Expression |
DateFunctions.clockStr(String format)
Returned expression results in system clock at function evaluation time, as a string in a supported format.
|
static Expression |
StringFunctions.contains(Expression expression,
String substring)
Returned expression results in True if the string expression contains the substring.
|
static Expression |
StringFunctions.contains(String expression,
String substring)
Returned expression results in True if the string expression contains the substring.
|
static Expression |
NumberFunctions.cos(Expression expression)
Returned expression results in the cosine.
|
static Expression |
NumberFunctions.cos(Number value)
Returned expression results in the cosine.
|
static Expression |
AggregateFunctions.count(Expression expression)
Returned expression results in count of all the non-NULL and non-MISSING values in the group.
|
static Expression |
AggregateFunctions.count(String expression)
Returned expression results in count of all the non-NULL and non-MISSING values in the group
|
static Expression |
AggregateFunctions.countAll()
Returned expression results in a count of all the input rows for the group, regardless of value (including NULL).
|
static Expression |
DateFunctions.dateAddMillis(Expression expression,
int n,
DateFunctions.DatePart part)
Returned expression performs Date arithmetic, and returns result of computation.
|
static Expression |
DateFunctions.dateAddMillis(String expression,
int n,
DateFunctions.DatePart part)
Returned expression performs Date arithmetic, and returns result of computation.
|
static Expression |
DateFunctions.dateAddStr(Expression expression,
int n,
DateFunctions.DatePart part)
Returned expression results in Performs Date arithmetic.
|
static Expression |
DateFunctions.dateAddStr(String expression,
int n,
DateFunctions.DatePart part)
Returned expression results in Performs Date arithmetic.
|
static Expression |
DateFunctions.dateDiffMillis(Expression expression1,
Expression expression2,
DateFunctions.DatePart part)
Returned expression results in Date arithmetic.
|
static Expression |
DateFunctions.dateDiffMillis(String expression1,
String expression2,
DateFunctions.DatePart part)
Returned expression results in Date arithmetic.
|
static Expression |
DateFunctions.dateDiffStr(Expression expression1,
Expression expression2,
DateFunctions.DatePart part)
Returned expression results in Performs Date arithmetic.
|
static Expression |
DateFunctions.dateDiffStr(String expression1,
String expression2,
DateFunctions.DatePart part)
Returned expression results in Performs Date arithmetic.
|
static Expression |
DateFunctions.datePartMillis(Expression expression,
DateFunctions.DatePartExt part)
Returned expression results in Date part as an integer.
|
static Expression |
DateFunctions.datePartMillis(String expression,
DateFunctions.DatePartExt part)
Returned expression results in Date part as an integer.
|
static Expression |
DateFunctions.datePartStr(Expression expression,
DateFunctions.DatePartExt part)
Returned expression results in Date part as an integer.
|
static Expression |
DateFunctions.datePartStr(String expression,
DateFunctions.DatePartExt part)
Returned expression results in Date part as an integer.
|
static Expression |
DateFunctions.dateTruncMillis(Expression expression,
DateFunctions.DatePart part)
Returned expression results in UNIX timestamp that has been truncated so that the given date part is the least significant.
|
static Expression |
DateFunctions.dateTruncMillis(String expression,
DateFunctions.DatePart part)
Returned expression results in UNIX timestamp that has been truncated so that the given date part is the least significant.
|
static Expression |
DateFunctions.dateTruncStr(Expression expression,
DateFunctions.DatePart part)
Returned expression results in ISO 8601 timestamp that has been truncated so that the given date part is the least significant.
|
static Expression |
DateFunctions.dateTruncStr(String expression,
DateFunctions.DatePart part)
Returned expression results in ISO 8601 timestamp that has been truncated so that the given date part is the least significant.
|
static Expression |
JsonFunctions.decodeJson(JsonObject json)
The returned Expression unmarshals the JSON constant into a N1QL value.
|
static Expression |
JsonFunctions.decodeJson(Expression expression)
The returned Expression unmarshals the expression representing a JSON-encoded string into a N1QL value.
|
static Expression |
JsonFunctions.decodeJson(String jsonString)
The returned Expression unmarshals the JSON-encoded string into a N1QL value.
|
static Expression |
NumberFunctions.degrees(Expression expression)
Returned expression results in the conversion of radians to degrees.
|
static Expression |
NumberFunctions.degrees(Number value)
Returned expression results in the conversion of radians to degrees.
|
static Expression |
AggregateFunctions.distinct(Expression expression)
prefixes an expression with DISTINCT, useful for example for distinct count “COUNT(DISTINCT expression)”.
|
static Expression |
AggregateFunctions.distinct(String expression)
prefixes an expression with DISTINCT, useful for example for distinct count “COUNT(DISTINCT expression)”.
|
static Expression |
NumberFunctions.e()
Returned expression results in the base of natural logarithms.
|
Expression |
Case.CaseClause.elseReturn(Expression elseResult)
ends the CASE, adding a default return expression as an ELSE clause
|
static Expression |
JsonFunctions.encodedSize(Expression expression)
Returned expression results in the number of bytes in an uncompressed JSON encoding of the value.
|
static Expression |
JsonFunctions.encodedSize(String expression)
Returned expression results in the number of bytes in an uncompressed JSON encoding of the value.
|
static Expression |
JsonFunctions.encodeJson(Expression expression)
Returned expression marshals the N1QL value into a JSON-encoded string.
|
static Expression |
JsonFunctions.encodeJson(String expression)
Returned expression marshals the N1QL value into a JSON-encoded string.
|
Expression |
Case.CaseClause.end()
ends the CASE without an ELSE clause
|
static Expression |
NumberFunctions.exp(Expression expression)
Returned expression results in the exponential of expression.
|
static Expression |
NumberFunctions.exp(Number value)
Returned expression results in the exponential of expression.
|
static Expression |
NumberFunctions.floor(Expression expression)
Returned expression results in the largest integer not greater than the number.
|
static Expression |
NumberFunctions.floor(Number value)
Returned expression results in the largest integer not greater than the number.
|
static Expression |
ComparisonFunctions.greatest(Expression e1,
Expression e2,
Expression... otherExpressions)
Returned expression results in the largest non-NULL, non-MISSING value if the values are of the same type, otherwise NULL.
|
static Expression |
ConditionalFunctions.ifInf(Expression expression1,
Expression expression2,
Expression... others)
Returned expression results in first non-MISSING, non-Inf number.
|
static Expression |
ConditionalFunctions.ifMissing(Expression expression1,
Expression expression2,
Expression... others)
Returned expression results in the first non-MISSING value.
|
static Expression |
ConditionalFunctions.ifMissingOrNull(Expression expression1,
Expression expression2,
Expression... others)
Returned expression results in first non-NULL, non-MISSING value.
|
static Expression |
ConditionalFunctions.ifNaN(Expression expression1,
Expression expression2,
Expression... others)
Returned expression results in first non-MISSING, non-NaN number.
|
static Expression |
ConditionalFunctions.ifNaNOrInf(Expression expression1,
Expression expression2,
Expression... others)
Returned expression results in first non-MISSING, non-Inf, or non-NaN number.
|
static Expression |
ConditionalFunctions.ifNull(Expression expression1,
Expression expression2,
Expression... others)
Returned expression results in first non-NULL value.
|
static Expression |
StringFunctions.initCap(Expression expression)
Returned expression results in the conversion of the string so that the first letter of each word is uppercase and every other letter is lowercase.
|
static Expression |
StringFunctions.initCap(String expression)
Returned expression results in the conversion of the string so that the first letter of each word is uppercase and every other letter is lowercase.
|
static Expression |
TypeFunctions.isArray(Expression expression)
Returned expression results in True if expression is an array, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isArray(String expression)
Returned expression results in True if expression is an array, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isAtom(Expression expression)
Returned expression results in True if expression is a Boolean, number, or string, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isAtom(String expression)
Returned expression results in True if expression is a Boolean, number, or string, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isBoolean(Expression expression)
Returned expression results in True if expression is a Boolean, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isBoolean(String expression)
Returned expression results in True if expression is a Boolean, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isNumber(Expression expression)
Returned expression results in True if expression is a number, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isNumber(String expression)
Returned expression results in True if expression is a number, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isObject(Expression expression)
Returned expression results in True if expression is an object, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isObject(String expression)
Returned expression results in True if expression is an object, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isString(Expression expression)
Returned expression results in True if expression is a string, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isString(String expression)
Returned expression results in True if expression is a string, otherwise returns MISSING, NULL or false.
|
static Expression |
ComparisonFunctions.least(Expression e1,
Expression e2,
Expression... otherExpressions)
Returned expression results in the smallest non-NULL, non-MISSING value if the values are of the same type, otherwise NULL.
|
static Expression |
StringFunctions.length(Expression expression)
Returned expression results in the length of the string expression.
|
static Expression |
StringFunctions.length(String expression)
Returned expression results in the length of the string expression.
|
static Expression |
NumberFunctions.ln(Expression expression)
Returned expression results in the log base e.
|
static Expression |
NumberFunctions.ln(Number value)
Returned expression results in the log base e.
|
static Expression |
NumberFunctions.log(Expression expression)
Returned expression results in the log base 10.
|
static Expression |
NumberFunctions.log(Number value)
Returned expression results in the log base 10.
|
static Expression |
StringFunctions.lower(Expression expression)
Returned expression results in the given string expression in lowercase
|
static Expression |
StringFunctions.lower(String identifier)
Returned expression results in the string value for the given identifier, in lowercase
|
static Expression |
StringFunctions.ltrim(Expression expression)
Returned expression results in the string with all leading white spaces removed.
|
static Expression |
StringFunctions.ltrim(Expression expression,
String characters)
Returned expression results in the string with all leading chars removed (any char in the characters string).
|
static Expression |
StringFunctions.ltrim(String expression)
Returned expression results in the string with all leading white spaces removed.
|
static Expression |
StringFunctions.ltrim(String expression,
String characters)
Returned expression results in the string with all leading chars removed (any char in the characters string).
|
static Expression |
AggregateFunctions.max(Expression expression)
Returned expression results in the maximum non-NULL, non-MISSING value in the group in N1QL collation order.
|
static Expression |
AggregateFunctions.max(String expression)
Returned expression results in the maximum non-NULL, non-MISSING value in the group in N1QL collation order.
|
static Expression |
MetaFunctions.meta(Expression expression) |
static Expression |
MetaFunctions.meta(String expression) |
static Expression |
DateFunctions.millis(Expression expression)
Returned expression results in date that has been converted in a supported format to UNIX milliseconds.
|
static Expression |
DateFunctions.millis(String expression)
Returned expression results in date that has been converted in a supported format to UNIX milliseconds.
|
static Expression |
DateFunctions.millisToStr(Expression expression,
String format)
Returned expression results in the string in the supported format to which the UNIX milliseconds has been converted.
|
static Expression |
DateFunctions.millisToStr(String expression,
String format)
Returned expression results in the string in the supported format to which the UNIX milliseconds has been converted.
|
static Expression |
DateFunctions.millisToUtc(Expression expression,
String format)
Returned expression results in the UTC string to which the UNIX time stamp has been converted in the supported format.
|
static Expression |
DateFunctions.millisToUtc(String expression,
String format)
Returned expression results in the UTC string to which the UNIX time stamp has been converted in the supported format.
|
static Expression |
DateFunctions.millisToZone(Expression expression,
String timeZoneName,
String format)
Returned expression results in a convertion of the UNIX time stamp to a string in the named time zone.
|
static Expression |
DateFunctions.millisToZone(String expression,
String timeZoneName,
String format)
Returned expression results in a convertion of the UNIX time stamp to a string in the named time zone.
|
static Expression |
AggregateFunctions.min(Expression expression)
Returned expression results in the minimum non-NULL, non-MISSING value in the group in N1QL collation order.
|
static Expression |
AggregateFunctions.min(String expression)
Returned expression results in the minimum non-NULL, non-MISSING value in the group in N1QL collation order.
|
static Expression |
ConditionalFunctions.missingIf(Expression expression1,
Expression expression2)
Returned expression results in MISSING if expression1 = expression2, otherwise returns expression1.
|
static Expression |
ConditionalFunctions.nanIf(Expression expression1,
Expression expression2)
Returned expression results in NaN if expression1 = expression2, otherwise returns expression1.
|
static Expression |
ConditionalFunctions.negInfIf(Expression expression1,
Expression expression2)
Returned expression results in NegInf if expression1 = expression2, otherwise returns expression1.
|
static Expression |
DateFunctions.nowMillis()
Returned expression results in statement time stamp as UNIX milliseconds; does not vary during a query.
|
static Expression |
DateFunctions.nowStr(String format)
Returned expression results in statement time stamp as a string in a supported format; does not vary during a query.
|
static Expression |
ConditionalFunctions.nullIf(Expression expression1,
Expression expression2)
Returned expression results in NULL if expression1 = expression2, otherwise returns expression1.
|
static Expression |
ObjectFunctions.objectLength(JsonObject value)
Returned expression results in the number of name-value pairs in the object.
|
static Expression |
ObjectFunctions.objectLength(Expression expression)
Returned expression results in the number of name-value pairs in the object.
|
static Expression |
ObjectFunctions.objectLength(String expression)
Returned expression results in the number of name-value pairs in the object.
|
static Expression |
ObjectFunctions.objectNames(JsonObject value)
Returned expression results in an array containing the attribute names of the object, in N1QL collation order.
|
static Expression |
ObjectFunctions.objectNames(Expression expression)
Returned expression results in an array containing the attribute names of the object, in N1QL collation order.
|
static Expression |
ObjectFunctions.objectNames(String expression)
Returned expression results in an array containing the attribute names of the object, in N1QL collation order.
|
static Expression |
ObjectFunctions.objectPairs(JsonObject value)
Returned expression results in an array containing the attribute name and value pairs of the object, in N1QL collation order of the names.
|
static Expression |
ObjectFunctions.objectPairs(Expression expression)
Returned expression results in an array containing the attribute name and value pairs of the object, in N1QL collation order of the names.
|
static Expression |
ObjectFunctions.objectPairs(String expression)
Returned expression results in an array containing the attribute name and value pairs of the object, in N1QL collation order of the names.
|
static Expression |
ObjectFunctions.objectValues(JsonObject value)
Returned expression results in an array containing the attribute values of the object, in N1QL collation order of the corresponding names.
|
static Expression |
ObjectFunctions.objectValues(Expression expression)
Returned expression results in an array containing the attribute values of the object, in N1QL collation order of the corresponding names.
|
static Expression |
ObjectFunctions.objectValues(String expression)
Returned expression results in an array containing the attribute values of the object, in N1QL collation order of the corresponding names.
|
static Expression |
NumberFunctions.pi()
Returned expression results in Pi.
|
static Expression |
JsonFunctions.polyLength(Expression expression)
Returned expression results in length of the value after evaluating the expression.
|
static Expression |
JsonFunctions.polyLength(String expression)
Returned expression results in length of the value after evaluating the expression.
|
static Expression |
ConditionalFunctions.posInfIf(Expression expression1,
Expression expression2)
Returned expression results in PosInf if expression1 = expression2, otherwise returns expression1.
|
static Expression |
StringFunctions.position(Expression expression,
String substring)
Returned expression results in the first position of the substring within the string, or -1.
|
static Expression |
StringFunctions.position(String expression,
String substring)
Returned expression results in the first position of the substring within the string, or -1.
|
static Expression |
NumberFunctions.power(Expression expression1,
Expression expression2)
Returned expression results in expression1 to the power of expression2.
|
static Expression |
NumberFunctions.power(Number value1,
Number value2)
Returned expression results in value1 to the power of value2.
|
static Expression |
NumberFunctions.radians(Expression expression)
Returned expression results in the conversion of degrees to radians.
|
static Expression |
NumberFunctions.radians(Number value)
Returned expression results in the conversion of degrees to radians.
|
static Expression |
NumberFunctions.random()
Returned expression results in a pseudo-random number with default seed.
|
static Expression |
NumberFunctions.random(Expression seed)
Returned expression results in a pseudo-random number with optional seed.
|
static Expression |
NumberFunctions.random(Number seed)
Returned expression results in a pseudo-random number with optional seed.
|
static Expression |
PatternMatchingFunctions.regexpContains(Expression expression,
String pattern)
Returned expression results in True if the string value contains the regular expression pattern.
|
static Expression |
PatternMatchingFunctions.regexpContains(String expression,
String pattern)
Returned expression results in True if the string value contains the regular expression pattern.
|
static Expression |
PatternMatchingFunctions.regexpLike(Expression expression,
String pattern)
Returned expression results in True if the string value matches the regular expression pattern
|
static Expression |
PatternMatchingFunctions.regexpLike(String expression,
String pattern)
Returned expression results in True if the string value matches the regular expression pattern
|
static Expression |
PatternMatchingFunctions.regexpPosition(Expression expression,
String pattern)
Returned expression results in the first position of the regular expression pattern within the string, or -1.
|
static Expression |
PatternMatchingFunctions.regexpPosition(String expression,
String pattern)
Returned expression results in the first position of the regular expression pattern within the string, or -1.
|
static Expression |
PatternMatchingFunctions.regexpReplace(Expression expression,
String pattern,
String repl)
Returned expression results in a new string with all occurrences of pattern replaced with repl.
|
static Expression |
PatternMatchingFunctions.regexpReplace(Expression expression,
String pattern,
String repl,
int n)
Returned expression results in a new string with occurrences of pattern replaced with repl.
|
static Expression |
PatternMatchingFunctions.regexpReplace(String expression,
String pattern,
String repl)
Returned expression results in a new string with all occurrences of pattern replaced with repl.
|
static Expression |
PatternMatchingFunctions.regexpReplace(String expression,
String pattern,
String repl,
int n)
Returned expression results in a new string with occurrences of pattern replaced with repl.
|
static Expression |
StringFunctions.repeat(Expression expression,
int n)
Returned expression results in the string formed by repeating expression n times.
|
static Expression |
StringFunctions.repeat(String expression,
int n)
Returned expression results in the string formed by repeating expression n times.
|
static Expression |
StringFunctions.replace(Expression expression,
String substring,
String repl)
Returned expression results in a string with all occurrences of substr replaced with repl.
|
static Expression |
StringFunctions.replace(Expression expression,
String substring,
String repl,
int n)
Returned expression results in a string with at most n occurrences of substr replaced with repl.
|
static Expression |
StringFunctions.replace(String expression,
String substring,
String repl)
Returned expression results in a string with all occurrences of substr replaced with repl.
|
static Expression |
StringFunctions.replace(String expression,
String substring,
String repl,
int n)
Returned expression results in a string with at most n occurrences of substr replaced with repl.
|
static Expression |
NumberFunctions.round(Expression expression)
Returned expression results in the value rounded to 0 digits to the right of the decimal point.
|
static Expression |
NumberFunctions.round(Expression expression,
int digits)
Returned expression results in the value rounded to the given number of integer digits to the right of the decimal point (left if digits is negative).
|
static Expression |
NumberFunctions.round(Number expression)
Returned expression results in the value rounded to 0 digits to the right of the decimal point.
|
static Expression |
NumberFunctions.round(Number expression,
int digits)
Returned expression results in the value rounded to the given number of integer digits to the right of the decimal point (left if digits is negative).
|
static Expression |
StringFunctions.rtrim(Expression expression)
Returned expression results in the string with all trailing white spaces removed.
|
static Expression |
StringFunctions.rtrim(Expression expression,
String characters)
Returned expression results in the string with all trailing chars removed (any char in the characters string).
|
static Expression |
StringFunctions.rtrim(String expression)
Returned expression results in the string with all trailing white spaces removed.
|
static Expression |
StringFunctions.rtrim(String expression,
String characters)
Returned expression results in the string with all trailing chars removed (any char in the characters string).
|
Expression |
Collections.SatisfiesBuilder.satisfies(Expression condition)
Sometimes the conditions you want to filter need to be applied to the arrays nested inside the document.
|
static Expression |
NumberFunctions.sign(Expression expression)
Returned expression results in the sign of the numerical expression, represented as -1, 0, or 1 for negative, zero, or positive numbers respectively.
|
static Expression |
NumberFunctions.sign(Number value)
Returned expression results in the sign of the numerical expression, represented as -1, 0, or 1 for negative, zero, or positive numbers respectively.
|
static Expression |
NumberFunctions.sin(Expression expression)
Returned expression results in the sine.
|
static Expression |
NumberFunctions.sin(Number value)
Returned expression results in the sine.
|
static Expression |
StringFunctions.split(Expression expression)
Returned expression results in a split of the string into an array of substrings separated by any combination of white space characters.
|
static Expression |
StringFunctions.split(Expression expression,
String sep)
Returned expression results in a split of the string into an array of substrings separated by sep.
|
static Expression |
StringFunctions.split(String expression)
Returned expression results in a split of the string into an array of substrings separated by any combination of white space characters.
|
static Expression |
StringFunctions.split(String expression,
String sep)
Returned expression results in a split of the string into an array of substrings separated by sep.
|
static Expression |
NumberFunctions.squareRoot(Expression expression)
Returned expression results in the square root.
|
static Expression |
NumberFunctions.squareRoot(Number value)
Returned expression results in the square root.
|
static Expression |
DateFunctions.strToMillis(Expression expression)
Returned expression results in date that has been converted in a supported format to UNIX milliseconds.
|
static Expression |
DateFunctions.strToMillis(String expression)
Returned expression results in date that has been converted in a supported format to UNIX milliseconds.
|
static Expression |
DateFunctions.strToUtc(Expression expression)
Returned expression results in a conversion of the ISO 8601 time stamp to UTC.
|
static Expression |
DateFunctions.strToUtc(String expression)
Returned expression results in a conversion of the ISO 8601 time stamp to UTC.
|
static Expression |
DateFunctions.strToZoneName(Expression expression,
String zoneName)
Returned expression results in a conversion of the supported time stamp string to the named time zone.
|
static Expression |
DateFunctions.strToZoneName(String expression,
String zoneName)
Returned expression results in a conversion of the supported time stamp string to the named time zone.
|
static Expression |
StringFunctions.substr(Expression expression,
int position)
Returned expression results in a substring from the integer position to the end of the string.
|
static Expression |
StringFunctions.substr(Expression expression,
int position,
int length)
Returned expression results in a substring from the integer position of the given length.
|
static Expression |
StringFunctions.substr(String expression,
int position)
Returned expression results in a substring from the integer position to the end of the string.
|
static Expression |
StringFunctions.substr(String expression,
int position,
int length)
Returned expression results in a substring from the integer position of the given length.
|
static Expression |
AggregateFunctions.sum(Expression expression)
Returned expression results in the sum of all the number values in the group.
|
static Expression |
AggregateFunctions.sum(String expression) |
static Expression |
NumberFunctions.tan(Expression expression)
Returned expression results in the tangent.
|
static Expression |
NumberFunctions.tan(Number value)
Returned expression results in the tangent.
|
static Expression |
StringFunctions.title(Expression expression)
Returned expression results in the conversion of the string so that the first letter of each word is uppercase and every other letter is lowercase.
|
static Expression |
StringFunctions.title(String expression)
Returned expression results in the conversion of the string so that the first letter of each word is uppercase and every other letter is lowercase.
|
static Expression |
TypeFunctions.toArray(Expression expression)
Returned expression results in an array as follows:
|
static Expression |
TypeFunctions.toArray(String expression)
Returned expression results in an array as follows:
|
static Expression |
TypeFunctions.toAtom(Expression expression)
Returned expression results in an atomic value as follows: - MISSING is MISSING.
|
static Expression |
TypeFunctions.toAtom(String expression)
Returned expression results in an atomic value as follows: - MISSING is MISSING.
|
static Expression |
TypeFunctions.toBoolean(Expression expression)
Returned expression results in a Boolean as follows:
|
static Expression |
TypeFunctions.toBoolean(String expression)
Returned expression results in a Boolean as follows:
|
static Expression |
TypeFunctions.toNumber(Expression expression)
Returned expression results in a number as follows:
|
static Expression |
TypeFunctions.toNumber(String expression)
Returned expression results in a number as follows:
|
static Expression |
TypeFunctions.toObject(Expression expression)
Returned expression results in an object as follows:
|
static Expression |
TypeFunctions.toObject(String expression)
Returned expression results in an object as follows:
|
static Expression |
TypeFunctions.toString(Expression expression)
Returned expression results in a string as follows:
|
static Expression |
TypeFunctions.toString(String expression)
Returned expression results in a string as follows:
|
static Expression |
StringFunctions.trim(Expression expression)
Returned expression results in the string with all leading and trailing white spaces removed.
|
static Expression |
StringFunctions.trim(Expression expression,
String characters)
Returned expression results in the string with all leading and trailing chars removed (any char in the characters string).
|
static Expression |
StringFunctions.trim(String expression)
Returned expression results in the string with all leading and trailing white spaces removed.
|
static Expression |
StringFunctions.trim(String expression,
String characters)
Returned expression results in the string with all leading and trailing chars removed (any char in the characters string).
|
static Expression |
NumberFunctions.trunc(Expression expression)
Returned expression results in a truncation of the number to 0 digits to the right of the decimal point.
|
static Expression |
NumberFunctions.trunc(Expression expression,
int digits)
Returned expression results in a truncation of the number to the given number of integer digits to the right of the decimal point (left if digits is negative).
|
static Expression |
NumberFunctions.trunc(Number value)
Returned expression results in a truncation of the number to 0 digits to the right of the decimal point.
|
static Expression |
NumberFunctions.trunc(Number value,
int digits)
Returned expression results in a truncation of the number to the given number of integer digits to the right of the decimal point (left if digits is negative).
|
static Expression |
TypeFunctions.type(Expression expression)
Returned expression results in one of the following strings, based on the value of expression:
|
static Expression |
TypeFunctions.type(String expression)
Returned expression results in one of the following strings, based on the value of expression:
|
static Expression |
StringFunctions.upper(Expression expression)
Returned expression results in uppercase of the string expression.
|
static Expression |
StringFunctions.upper(String expression)
Returned expression results in uppercase of the string expression.
|
static Expression |
MetaFunctions.uuid() |
Expression |
Collections.WhenBuilder.when(Expression condition)
Set a WHEN clause, a condition that must be satisfied by the array comprehension, and ends the comprehension.
|
Modifier and Type | Method and Description |
---|---|
static Expression |
NumberFunctions.abs(Expression expression)
Returned expression results in the absolute value of the number.
|
static Expression |
NumberFunctions.acos(Expression expression)
Returned expression results in the arccosine in radians.
|
static Collections.SatisfiesBuilder |
Collections.anyAndEveryIn(String variable,
Expression expression)
Create an ANY AND EVERY comprehension with a first IN range.
|
static Collections.SatisfiesBuilder |
Collections.anyIn(String variable,
Expression expression)
Create an ANY comprehension with a first IN range.
|
static Collections.SatisfiesBuilder |
Collections.anyWithin(String variable,
Expression expression)
Create an ANY comprehension with a first WITHIN range.
|
static Expression |
AggregateFunctions.arrayAgg(Expression expression)
Returned expression results in a array of the non-MISSING values in the group, including NULLs.
|
static Expression |
ArrayFunctions.arrayAppend(JsonArray array,
Expression value)
Returned expression results in new array with value appended.
|
static Expression |
ArrayFunctions.arrayAppend(Expression expression,
Expression value)
Returned expression results in new array with value appended.
|
static Expression |
ArrayFunctions.arrayAppend(String expression,
Expression value)
Returned expression results in new array with value appended.
|
static Expression |
ArrayFunctions.arrayAvg(Expression expression)
Returned expression results in arithmetic mean (average) of all the non-NULL number values in the array, or NULL if there are no such values.
|
static Expression |
ArrayFunctions.arrayConcat(Expression expression1,
Expression expression2)
Returned expression results in new array with the concatenation of the input arrays.
|
static Expression |
ArrayFunctions.arrayContains(JsonArray array,
Expression value)
Returned expression results in true if the array contains value.
|
static Expression |
ArrayFunctions.arrayContains(Expression expression,
Expression value)
Returned expression results in true if the array contains value.
|
static Expression |
ArrayFunctions.arrayContains(String expression,
Expression value)
Returned expression results in true if the array contains value.
|
static Expression |
ArrayFunctions.arrayCount(Expression expression)
Returned expression results in count of all the non-NULL values in the array, or zero if there are no such values.
|
static Expression |
ArrayFunctions.arrayDistinct(Expression expression)
Returned expression results in new array with distinct elements of input array.
|
static Expression |
ArrayFunctions.arrayIfNull(Expression expression)
Returned expression results in the first non-NULL value in the array, or NULL.
|
static Collections.WhenBuilder |
Collections.arrayIn(Expression arrayExpression,
String variable,
Expression expression)
Create an ARRAY comprehension with a first IN range.
|
static Expression |
ArrayFunctions.arrayLength(Expression expression)
Returned expression results in the number of elements in the array.
|
static Expression |
ArrayFunctions.arrayMax(Expression expression)
Returned expression results in the largest non-NULL, non-MISSING array element, in N1QL collation order.
|
static Expression |
ArrayFunctions.arrayMin(Expression expression)
Returned expression results in the smallest non-NULL, non-MISSING array element, in N1QL collation order.
|
static Expression |
ArrayFunctions.arrayPosition(JsonArray array,
Expression value)
Returned expression results in the first position of value within the array, or -1.
|
static Expression |
ArrayFunctions.arrayPosition(Expression expression,
Expression value)
Returned expression results in the first position of value within the array, or -1.
|
static Expression |
ArrayFunctions.arrayPosition(String expression,
Expression value)
Returned expression results in the first position of value within the array, or -1.
|
static Expression |
ArrayFunctions.arrayPrepend(JsonArray array,
Expression value)
Returned expression results in the new array with value pre-pended.
|
static Expression |
ArrayFunctions.arrayPrepend(Expression expression,
Expression value)
Returned expression results in the new array with value pre-pended.
|
static Expression |
ArrayFunctions.arrayPrepend(String expression,
Expression value)
Returned expression results in the new array with value pre-pended.
|
static Expression |
ArrayFunctions.arrayPut(JsonArray array,
Expression value)
Returned expression results in new array with value appended, if value is not already present, otherwise the unmodified input array.
|
static Expression |
ArrayFunctions.arrayPut(Expression expression,
Expression value)
Returned expression results in new array with value appended, if value is not already present, otherwise the unmodified input array.
|
static Expression |
ArrayFunctions.arrayPut(String expression,
Expression value)
Returned expression results in new array with value appended, if value is not already present, otherwise the unmodified input array.
|
static Expression |
ArrayFunctions.arrayRemove(JsonArray array,
Expression value)
Returned expression results in new array with all occurrences of value removed.
|
static Expression |
ArrayFunctions.arrayRemove(Expression expression,
Expression value)
Returned expression results in new array with all occurrences of value removed.
|
static Expression |
ArrayFunctions.arrayRemove(String expression,
Expression value)
Returned expression results in new array with all occurrences of value removed.
|
static Expression |
ArrayFunctions.arrayRepeat(Expression value,
long n)
Returned expression results in new array with value repeated n times.
|
static Expression |
ArrayFunctions.arrayReplace(JsonArray array,
Expression value1,
Expression value2)
Returned expression results in new array with all occurrences of value1 replaced by value2.
|
static Expression |
ArrayFunctions.arrayReplace(JsonArray array,
Expression value1,
Expression value2,
long n)
Returned expression results in new array with at most n occurrences of value1 replaced with value2.
|
static Expression |
ArrayFunctions.arrayReplace(Expression expression,
Expression value1,
Expression value2)
Returned expression results in new array with all occurrences of value1 replaced by value2.
|
static Expression |
ArrayFunctions.arrayReplace(Expression expression,
Expression value1,
Expression value2,
long n)
Returned expression results in new array with at most n occurrences of value1 replaced with value2.
|
static Expression |
ArrayFunctions.arrayReplace(String expression,
Expression value1,
Expression value2)
Returned expression results in new array with all occurrences of value1 replaced by value2.
|
static Expression |
ArrayFunctions.arrayReplace(String expression,
Expression value1,
Expression value2,
long n)
Returned expression results in new array with at most n occurrences of value1 replaced with value2.
|
static Expression |
ArrayFunctions.arrayReverse(Expression expression)
Returned expression results in new array with all elements in reverse order.
|
static Expression |
ArrayFunctions.arraySort(Expression expression)
Returned expression results in new array with elements sorted in N1QL collation order.
|
static Expression |
ArrayFunctions.arraySum(Expression expression)
Returned expression results in the sum of all the non-NULL number values in the array, or zero if there are no such values.
|
static Collections.WhenBuilder |
Collections.arrayWithin(Expression arrayExpression,
String variable,
Expression expression)
Create an ARRAY comprehension with a first WITHIN range.
|
static Expression |
NumberFunctions.asin(Expression expression)
Returned expression results in the arcsine in radians.
|
static Expression |
NumberFunctions.atan(Expression expression)
Returned expression results in the arctangent in radians.
|
static Expression |
NumberFunctions.atan(Expression expression1,
Expression expression2)
Returned expression results in the arctangent of expression2/expression1.
|
static Expression |
AggregateFunctions.avg(Expression expression)
Returned expression results in the arithmetic mean (average) of all the distinct number values in the group.
|
static Expression |
MetaFunctions.base64(Expression expression) |
protected static Expression |
ConditionalFunctions.build(String operator,
Expression expression1,
Expression expression2,
Expression... others) |
static Case.WhenClause |
Case.caseSimple(Expression expected)
Constructs a “simple case” expression.
|
static Expression |
NumberFunctions.ceil(Expression expression)
Returned expression results in the smallest integer not less than the number.
|
static Expression |
StringFunctions.contains(Expression expression,
String substring)
Returned expression results in True if the string expression contains the substring.
|
static Expression |
NumberFunctions.cos(Expression expression)
Returned expression results in the cosine.
|
static Expression |
AggregateFunctions.count(Expression expression)
Returned expression results in count of all the non-NULL and non-MISSING values in the group.
|
static Expression |
DateFunctions.dateAddMillis(Expression expression,
int n,
DateFunctions.DatePart part)
Returned expression performs Date arithmetic, and returns result of computation.
|
static Expression |
DateFunctions.dateAddStr(Expression expression,
int n,
DateFunctions.DatePart part)
Returned expression results in Performs Date arithmetic.
|
static Expression |
DateFunctions.dateDiffMillis(Expression expression1,
Expression expression2,
DateFunctions.DatePart part)
Returned expression results in Date arithmetic.
|
static Expression |
DateFunctions.dateDiffStr(Expression expression1,
Expression expression2,
DateFunctions.DatePart part)
Returned expression results in Performs Date arithmetic.
|
static Expression |
DateFunctions.datePartMillis(Expression expression,
DateFunctions.DatePartExt part)
Returned expression results in Date part as an integer.
|
static Expression |
DateFunctions.datePartStr(Expression expression,
DateFunctions.DatePartExt part)
Returned expression results in Date part as an integer.
|
static Expression |
DateFunctions.dateTruncMillis(Expression expression,
DateFunctions.DatePart part)
Returned expression results in UNIX timestamp that has been truncated so that the given date part is the least significant.
|
static Expression |
DateFunctions.dateTruncStr(Expression expression,
DateFunctions.DatePart part)
Returned expression results in ISO 8601 timestamp that has been truncated so that the given date part is the least significant.
|
static Expression |
JsonFunctions.decodeJson(Expression expression)
The returned Expression unmarshals the expression representing a JSON-encoded string into a N1QL value.
|
static Expression |
NumberFunctions.degrees(Expression expression)
Returned expression results in the conversion of radians to degrees.
|
static Expression |
AggregateFunctions.distinct(Expression expression)
prefixes an expression with DISTINCT, useful for example for distinct count “COUNT(DISTINCT expression)”.
|
Expression |
Case.CaseClause.elseReturn(Expression elseResult)
ends the CASE, adding a default return expression as an ELSE clause
|
static Expression |
JsonFunctions.encodedSize(Expression expression)
Returned expression results in the number of bytes in an uncompressed JSON encoding of the value.
|
static Expression |
JsonFunctions.encodeJson(Expression expression)
Returned expression marshals the N1QL value into a JSON-encoded string.
|
static Collections.SatisfiesBuilder |
Collections.everyIn(String variable,
Expression expression)
Create an EVERY comprehension with a first IN range.
|
static Collections.SatisfiesBuilder |
Collections.everyWithin(String variable,
Expression expression)
Create an EVERY comprehension with a first WITHIN range.
|
static Expression |
NumberFunctions.exp(Expression expression)
Returned expression results in the exponential of expression.
|
static Collections.WhenBuilder |
Collections.firstIn(Expression arrayExpression,
String variable,
Expression expression)
Create a FIRST comprehension with a first IN range.
|
static Collections.WhenBuilder |
Collections.firstWithin(Expression arrayExpression,
String variable,
Expression expression)
Create a FIRST comprehension with a first WITHIN range.
|
static Expression |
NumberFunctions.floor(Expression expression)
Returned expression results in the largest integer not greater than the number.
|
static Expression |
ComparisonFunctions.greatest(Expression e1,
Expression e2,
Expression... otherExpressions)
Returned expression results in the largest non-NULL, non-MISSING value if the values are of the same type, otherwise NULL.
|
static Expression |
ConditionalFunctions.ifInf(Expression expression1,
Expression expression2,
Expression... others)
Returned expression results in first non-MISSING, non-Inf number.
|
static Expression |
ConditionalFunctions.ifMissing(Expression expression1,
Expression expression2,
Expression... others)
Returned expression results in the first non-MISSING value.
|
static Expression |
ConditionalFunctions.ifMissingOrNull(Expression expression1,
Expression expression2,
Expression... others)
Returned expression results in first non-NULL, non-MISSING value.
|
static Expression |
ConditionalFunctions.ifNaN(Expression expression1,
Expression expression2,
Expression... others)
Returned expression results in first non-MISSING, non-NaN number.
|
static Expression |
ConditionalFunctions.ifNaNOrInf(Expression expression1,
Expression expression2,
Expression... others)
Returned expression results in first non-MISSING, non-Inf, or non-NaN number.
|
static Expression |
ConditionalFunctions.ifNull(Expression expression1,
Expression expression2,
Expression... others)
Returned expression results in first non-NULL value.
|
Collections.SatisfiesBuilder |
Collections.SatisfiesBuilder.in(String variable,
Expression expression) |
Collections.WhenBuilder |
Collections.WhenBuilder.in(String variable,
Expression expression) |
static Expression |
StringFunctions.initCap(Expression expression)
Returned expression results in the conversion of the string so that the first letter of each word is uppercase and every other letter is lowercase.
|
static Expression |
TypeFunctions.isArray(Expression expression)
Returned expression results in True if expression is an array, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isAtom(Expression expression)
Returned expression results in True if expression is a Boolean, number, or string, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isBoolean(Expression expression)
Returned expression results in True if expression is a Boolean, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isNumber(Expression expression)
Returned expression results in True if expression is a number, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isObject(Expression expression)
Returned expression results in True if expression is an object, otherwise returns MISSING, NULL or false.
|
static Expression |
TypeFunctions.isString(Expression expression)
Returned expression results in True if expression is a string, otherwise returns MISSING, NULL or false.
|
static Expression |
ComparisonFunctions.least(Expression e1,
Expression e2,
Expression... otherExpressions)
Returned expression results in the smallest non-NULL, non-MISSING value if the values are of the same type, otherwise NULL.
|
static Expression |
StringFunctions.length(Expression expression)
Returned expression results in the length of the string expression.
|
static Expression |
NumberFunctions.ln(Expression expression)
Returned expression results in the log base e.
|
static Expression |
NumberFunctions.log(Expression expression)
Returned expression results in the log base 10.
|
static Expression |
StringFunctions.lower(Expression expression)
Returned expression results in the given string expression in lowercase
|
static Expression |
StringFunctions.ltrim(Expression expression)
Returned expression results in the string with all leading white spaces removed.
|
static Expression |
StringFunctions.ltrim(Expression expression,
String characters)
Returned expression results in the string with all leading chars removed (any char in the characters string).
|
static Expression |
AggregateFunctions.max(Expression expression)
Returned expression results in the maximum non-NULL, non-MISSING value in the group in N1QL collation order.
|
static Expression |
MetaFunctions.meta(Expression expression) |
static Expression |
DateFunctions.millis(Expression expression)
Returned expression results in date that has been converted in a supported format to UNIX milliseconds.
|
static Expression |
DateFunctions.millisToStr(Expression expression,
String format)
Returned expression results in the string in the supported format to which the UNIX milliseconds has been converted.
|
static Expression |
DateFunctions.millisToUtc(Expression expression,
String format)
Returned expression results in the UTC string to which the UNIX time stamp has been converted in the supported format.
|
static Expression |
DateFunctions.millisToZone(Expression expression,
String timeZoneName,
String format)
Returned expression results in a convertion of the UNIX time stamp to a string in the named time zone.
|
static Expression |
AggregateFunctions.min(Expression expression)
Returned expression results in the minimum non-NULL, non-MISSING value in the group in N1QL collation order.
|
static Expression |
ConditionalFunctions.missingIf(Expression expression1,
Expression expression2)
Returned expression results in MISSING if expression1 = expression2, otherwise returns expression1.
|
static Expression |
ConditionalFunctions.nanIf(Expression expression1,
Expression expression2)
Returned expression results in NaN if expression1 = expression2, otherwise returns expression1.
|
static Expression |
ConditionalFunctions.negInfIf(Expression expression1,
Expression expression2)
Returned expression results in NegInf if expression1 = expression2, otherwise returns expression1.
|
static Expression |
ConditionalFunctions.nullIf(Expression expression1,
Expression expression2)
Returned expression results in NULL if expression1 = expression2, otherwise returns expression1.
|
static Expression |
ObjectFunctions.objectLength(Expression expression)
Returned expression results in the number of name-value pairs in the object.
|
static Expression |
ObjectFunctions.objectNames(Expression expression)
Returned expression results in an array containing the attribute names of the object, in N1QL collation order.
|
static Expression |
ObjectFunctions.objectPairs(Expression expression)
Returned expression results in an array containing the attribute name and value pairs of the object, in N1QL collation order of the names.
|
static Expression |
ObjectFunctions.objectValues(Expression expression)
Returned expression results in an array containing the attribute values of the object, in N1QL collation order of the corresponding names.
|
static Expression |
JsonFunctions.polyLength(Expression expression)
Returned expression results in length of the value after evaluating the expression.
|
static Expression |
ConditionalFunctions.posInfIf(Expression expression1,
Expression expression2)
Returned expression results in PosInf if expression1 = expression2, otherwise returns expression1.
|
static Expression |
StringFunctions.position(Expression expression,
String substring)
Returned expression results in the first position of the substring within the string, or -1.
|
static Expression |
NumberFunctions.power(Expression expression1,
Expression expression2)
Returned expression results in expression1 to the power of expression2.
|
static Expression |
NumberFunctions.radians(Expression expression)
Returned expression results in the conversion of degrees to radians.
|
static Expression |
NumberFunctions.random(Expression seed)
Returned expression results in a pseudo-random number with optional seed.
|
static Expression |
PatternMatchingFunctions.regexpContains(Expression expression,
String pattern)
Returned expression results in True if the string value contains the regular expression pattern.
|
static Expression |
PatternMatchingFunctions.regexpLike(Expression expression,
String pattern)
Returned expression results in True if the string value matches the regular expression pattern
|
static Expression |
PatternMatchingFunctions.regexpPosition(Expression expression,
String pattern)
Returned expression results in the first position of the regular expression pattern within the string, or -1.
|
static Expression |
PatternMatchingFunctions.regexpReplace(Expression expression,
String pattern,
String repl)
Returned expression results in a new string with all occurrences of pattern replaced with repl.
|
static Expression |
PatternMatchingFunctions.regexpReplace(Expression expression,
String pattern,
String repl,
int n)
Returned expression results in a new string with occurrences of pattern replaced with repl.
|
static Expression |
StringFunctions.repeat(Expression expression,
int n)
Returned expression results in the string formed by repeating expression n times.
|
static Expression |
StringFunctions.replace(Expression expression,
String substring,
String repl)
Returned expression results in a string with all occurrences of substr replaced with repl.
|
static Expression |
StringFunctions.replace(Expression expression,
String substring,
String repl,
int n)
Returned expression results in a string with at most n occurrences of substr replaced with repl.
|
static Expression |
NumberFunctions.round(Expression expression)
Returned expression results in the value rounded to 0 digits to the right of the decimal point.
|
static Expression |
NumberFunctions.round(Expression expression,
int digits)
Returned expression results in the value rounded to the given number of integer digits to the right of the decimal point (left if digits is negative).
|
static Expression |
StringFunctions.rtrim(Expression expression)
Returned expression results in the string with all trailing white spaces removed.
|
static Expression |
StringFunctions.rtrim(Expression expression,
String characters)
Returned expression results in the string with all trailing chars removed (any char in the characters string).
|
Expression |
Collections.SatisfiesBuilder.satisfies(Expression condition)
Sometimes the conditions you want to filter need to be applied to the arrays nested inside the document.
|
static Expression |
NumberFunctions.sign(Expression expression)
Returned expression results in the sign of the numerical expression, represented as -1, 0, or 1 for negative, zero, or positive numbers respectively.
|
static Expression |
NumberFunctions.sin(Expression expression)
Returned expression results in the sine.
|
static Expression |
StringFunctions.split(Expression expression)
Returned expression results in a split of the string into an array of substrings separated by any combination of white space characters.
|
static Expression |
StringFunctions.split(Expression expression,
String sep)
Returned expression results in a split of the string into an array of substrings separated by sep.
|
static Expression |
NumberFunctions.squareRoot(Expression expression)
Returned expression results in the square root.
|
static Expression |
DateFunctions.strToMillis(Expression expression)
Returned expression results in date that has been converted in a supported format to UNIX milliseconds.
|
static Expression |
DateFunctions.strToUtc(Expression expression)
Returned expression results in a conversion of the ISO 8601 time stamp to UTC.
|
static Expression |
DateFunctions.strToZoneName(Expression expression,
String zoneName)
Returned expression results in a conversion of the supported time stamp string to the named time zone.
|
static Expression |
StringFunctions.substr(Expression expression,
int position)
Returned expression results in a substring from the integer position to the end of the string.
|
static Expression |
StringFunctions.substr(Expression expression,
int position,
int length)
Returned expression results in a substring from the integer position of the given length.
|
static Expression |
AggregateFunctions.sum(Expression expression)
Returned expression results in the sum of all the number values in the group.
|
static Expression |
NumberFunctions.tan(Expression expression)
Returned expression results in the tangent.
|
Case.CaseClause |
Case.ThenClause.then(Expression expression)
THEN clause associated with a
WHEN clause . |
static Expression |
StringFunctions.title(Expression expression)
Returned expression results in the conversion of the string so that the first letter of each word is uppercase and every other letter is lowercase.
|
static Expression |
TypeFunctions.toArray(Expression expression)
Returned expression results in an array as follows:
|
static Expression |
TypeFunctions.toAtom(Expression expression)
Returned expression results in an atomic value as follows: - MISSING is MISSING.
|
static Expression |
TypeFunctions.toBoolean(Expression expression)
Returned expression results in a Boolean as follows:
|
static Expression |
TypeFunctions.toNumber(Expression expression)
Returned expression results in a number as follows:
|
static Expression |
TypeFunctions.toObject(Expression expression)
Returned expression results in an object as follows:
|
static Expression |
TypeFunctions.toString(Expression expression)
Returned expression results in a string as follows:
|
static Expression |
StringFunctions.trim(Expression expression)
Returned expression results in the string with all leading and trailing white spaces removed.
|
static Expression |
StringFunctions.trim(Expression expression,
String characters)
Returned expression results in the string with all leading and trailing chars removed (any char in the characters string).
|
static Expression |
NumberFunctions.trunc(Expression expression)
Returned expression results in a truncation of the number to 0 digits to the right of the decimal point.
|
static Expression |
NumberFunctions.trunc(Expression expression,
int digits)
Returned expression results in a truncation of the number to the given number of integer digits to the right of the decimal point (left if digits is negative).
|
static Expression |
TypeFunctions.type(Expression expression)
Returned expression results in one of the following strings, based on the value of expression:
|
static Expression |
StringFunctions.upper(Expression expression)
Returned expression results in uppercase of the string expression.
|
Case.ThenClause |
Case.WhenClause.when(Expression conditionOrExpression)
WHEN clause, to be followed by its
THEN clause . |
Expression |
Collections.WhenBuilder.when(Expression condition)
Set a WHEN clause, a condition that must be satisfied by the array comprehension, and ends the comprehension.
|
Collections.SatisfiesBuilder |
Collections.SatisfiesBuilder.within(String variable,
Expression expression) |
Collections.WhenBuilder |
Collections.WhenBuilder.within(String variable,
Expression expression) |
Modifier and Type | Method and Description |
---|---|
AsPath |
DefaultFromPath.from(Expression from) |
AsPath |
FromPath.from(Expression expression)
Note that from Expression should be a single identifier/path
|
LettingPath |
DefaultGroupByPath.groupBy(Expression... expressions) |
LettingPath |
GroupByPath.groupBy(Expression... expressions) |
SelectResultPath |
DefaultHavingPath.having(Expression condition) |
SelectResultPath |
HavingPath.having(Expression condition) |
JoinPath |
DefaultLetPath.innerJoin(Expression from) |
JoinPath |
LetPath.innerJoin(Expression from) |
NestPath |
DefaultLetPath.innerNest(Expression from) |
NestPath |
LetPath.innerNest(Expression from) |
UnnestPath |
DefaultLetPath.innerUnnest(Expression path) |
UnnestPath |
LetPath.innerUnnest(Expression path) |
JoinPath |
DefaultLetPath.join(Expression from) |
JoinPath |
LetPath.join(Expression from) |
JoinPath |
DefaultLetPath.leftJoin(Expression from) |
JoinPath |
LetPath.leftJoin(Expression from) |
NestPath |
DefaultLetPath.leftNest(Expression from) |
NestPath |
LetPath.leftNest(Expression from) |
JoinPath |
DefaultLetPath.leftOuterJoin(Expression from) |
JoinPath |
LetPath.leftOuterJoin(Expression from) |
NestPath |
DefaultLetPath.leftOuterNest(Expression from) |
NestPath |
LetPath.leftOuterNest(Expression from) |
UnnestPath |
DefaultLetPath.leftOuterUnnest(Expression path) |
UnnestPath |
LetPath.leftOuterUnnest(Expression path) |
UnnestPath |
DefaultLetPath.leftUnnest(Expression path) |
UnnestPath |
LetPath.leftUnnest(Expression path) |
NestPath |
DefaultLetPath.nest(Expression from) |
NestPath |
LetPath.nest(Expression from) |
MergeUpdatePath |
DefaultMergeKeyClausePath.onKey(Expression expression) |
MergeUpdatePath |
MergeKeyClausePath.onKey(Expression expression) |
LetPath |
DefaultKeysPath.onKeys(Expression expression) |
LetPath |
KeysPath.onKeys(Expression expression)
the on-key clause of a join/nest/unnest clause
|
MergeUpdatePath |
DefaultMergeKeyClausePath.onPrimaryKey(Expression expression) |
MergeUpdatePath |
MergeKeyClausePath.onPrimaryKey(Expression expression) |
Statement |
DefaultReturningPath.returning(Expression expression) |
Statement |
ReturningPath.returning(Expression expression) |
Statement |
DefaultReturningPath.returningElement(Expression expression) |
Statement |
ReturningPath.returningElement(Expression expression) |
Statement |
DefaultReturningPath.returningRaw(Expression expression) |
Statement |
ReturningPath.returningRaw(Expression expression) |
ReturningPath |
DefaultInitialInsertPath.select(Expression key,
Expression value,
Statement select) |
ReturningPath |
DefaultInitialInsertPath.select(Expression key,
Statement select) |
ReturningPath |
DefaultInitialInsertPath.select(Expression key,
String value,
Statement select) |
ReturningPath |
DefaultInitialInsertPath.select(String key,
Expression value,
Statement select) |
FromPath |
DefaultSelectPath.select(Expression... expressions) |
ReturningPath |
InitialInsertPath.select(Expression key,
Expression value,
Statement select) |
ReturningPath |
InitialInsertPath.select(Expression key,
Statement select) |
ReturningPath |
InitialInsertPath.select(Expression key,
String value,
Statement select) |
ReturningPath |
InitialInsertPath.select(String key,
Expression value,
Statement select) |
FromPath |
SelectPath.select(Expression... expressions) |
FromPath |
DefaultSelectPath.selectAll(Expression... expressions) |
FromPath |
SelectPath.selectAll(Expression... expressions) |
FromPath |
DefaultSelectPath.selectDistinct(Expression... expressions) |
FromPath |
SelectPath.selectDistinct(Expression... expressions) |
FromPath |
DefaultSelectPath.selectRaw(Expression expression) |
FromPath |
SelectPath.selectRaw(Expression expression) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
boolean value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
boolean value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
double value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
double value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
float value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
float value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
int value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
int value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
long value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
long value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
JsonArray value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
JsonArray value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
JsonObject value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
JsonObject value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
Expression value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
Expression value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
String value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(Expression path,
String value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(String path,
boolean value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(String path,
double value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(String path,
float value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(String path,
int value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(String path,
long value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(String path,
JsonArray value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(String path,
JsonObject value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(String path,
Expression value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(String path,
Expression value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetOrUnsetPath.set(String path,
String value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
boolean value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
boolean value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
double value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
double value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
float value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
float value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
int value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
int value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
long value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
long value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
JsonArray value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
JsonArray value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
JsonObject value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
JsonObject value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
Expression value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
Expression value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
String value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(Expression path,
String value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(String path,
boolean value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(String path,
double value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(String path,
float value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(String path,
int value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(String path,
long value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(String path,
JsonArray value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(String path,
JsonObject value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(String path,
Expression value) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(String path,
Expression value,
Expression updateFor) |
MergeUpdateSetPath |
DefaultMergeUpdateSetPath.set(String path,
String value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
boolean value) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
boolean value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
double value) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
double value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
float value) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
float value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
int value) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
int value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
long value) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
long value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
JsonArray value) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
JsonArray value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
JsonObject value) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
JsonObject value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
Expression value) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
Expression value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
String value) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(Expression path,
String value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(String path,
boolean value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(String path,
double value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(String path,
float value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(String path,
int value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(String path,
long value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(String path,
JsonArray value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(String path,
JsonObject value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(String path,
Expression value) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(String path,
Expression value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetOrUnsetPath.set(String path,
String value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
boolean value) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
boolean value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
double value) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
double value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
float value) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
float value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
int value) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
int value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
long value) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
long value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
JsonArray value) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
JsonArray value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
JsonObject value) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
JsonObject value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
Expression value) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
Expression value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
String value) |
UpdateSetPath |
DefaultUpdateSetPath.set(Expression path,
String value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(String path,
boolean value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(String path,
double value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(String path,
float value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(String path,
int value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(String path,
long value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(String path,
JsonArray value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(String path,
JsonObject value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(String path,
Expression value) |
UpdateSetPath |
DefaultUpdateSetPath.set(String path,
Expression value,
Expression updateFor) |
UpdateSetPath |
DefaultUpdateSetPath.set(String path,
String value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
boolean value) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
boolean value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
double value) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
double value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
float value) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
float value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
int value) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
int value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
long value) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
long value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
JsonArray value) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
JsonArray value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
JsonObject value) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
JsonObject value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
Expression value) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
Expression value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
String value) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(Expression path,
String value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(String path,
boolean value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(String path,
double value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(String path,
float value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(String path,
int value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(String path,
long value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(String path,
JsonArray value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(String path,
JsonObject value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(String path,
Expression value) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(String path,
Expression value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetOrUnsetPath.set(String path,
String value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
boolean value) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
boolean value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
double value) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
double value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
float value) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
float value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
int value) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
int value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
long value) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
long value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
JsonArray value) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
JsonArray value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
JsonObject value) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
JsonObject value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
Expression value) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
Expression value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
String value) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(Expression path,
String value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(String path,
boolean value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(String path,
double value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(String path,
float value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(String path,
int value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(String path,
long value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(String path,
JsonArray value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(String path,
JsonObject value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(String path,
Expression value) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(String path,
Expression value,
Expression updateFor) |
MergeUpdateSetPath |
MergeUpdateSetPath.set(String path,
String value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
boolean value) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
boolean value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
double value) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
double value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
float value) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
float value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
int value) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
int value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
long value) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
long value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
JsonArray value) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
JsonArray value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
JsonObject value) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
JsonObject value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
Expression value) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
Expression value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
String value) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(Expression path,
String value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(String path,
boolean value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(String path,
double value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(String path,
float value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(String path,
int value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(String path,
long value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(String path,
JsonArray value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(String path,
JsonObject value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(String path,
Expression value) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(String path,
Expression value,
Expression updateFor) |
UpdateSetPath |
UpdateSetOrUnsetPath.set(String path,
String value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
boolean value) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
boolean value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
double value) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
double value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
float value) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
float value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
int value) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
int value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
long value) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
long value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
JsonArray value) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
JsonArray value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
JsonObject value) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
JsonObject value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
Expression value) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
Expression value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
String value) |
UpdateSetPath |
UpdateSetPath.set(Expression path,
String value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(String path,
boolean value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(String path,
double value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(String path,
float value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(String path,
int value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(String path,
long value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(String path,
JsonArray value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(String path,
JsonObject value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(String path,
Expression value) |
UpdateSetPath |
UpdateSetPath.set(String path,
Expression value,
Expression updateFor) |
UpdateSetPath |
UpdateSetPath.set(String path,
String value,
Expression updateFor) |
UnnestPath |
DefaultLetPath.unnest(Expression path) |
UnnestPath |
LetPath.unnest(Expression path) |
UpdateUnsetPath |
DefaultInitialUpdateUnsetPath.unset(Expression path) |
UpdateUnsetPath |
DefaultInitialUpdateUnsetPath.unset(Expression path,
Expression updateFor) |
UpdateUnsetPath |
DefaultInitialUpdateUnsetPath.unset(String path,
Expression updateFor) |
MergeUpdateUnsetPath |
DefaultMergeUpdateSetOrUnsetPath.unset(Expression path) |
MergeUpdateUnsetPath |
DefaultMergeUpdateSetOrUnsetPath.unset(Expression path,
Expression updateFor) |
MergeUpdateUnsetPath |
DefaultMergeUpdateSetOrUnsetPath.unset(String path,
Expression updateFor) |
MergeUpdateUnsetPath |
DefaultMergeUpdateSetPath.unset(Expression path) |
MergeUpdateUnsetPath |
DefaultMergeUpdateSetPath.unset(Expression path,
Expression updateFor) |
MergeUpdateUnsetPath |
DefaultMergeUpdateSetPath.unset(String path,
Expression updateFor) |
MergeUpdateUnsetPath |
DefaultMergeUpdateUnsetPath.unset(Expression path) |
MergeUpdateUnsetPath |
DefaultMergeUpdateUnsetPath.unset(Expression path,
Expression updateFor) |
MergeUpdateUnsetPath |
DefaultMergeUpdateUnsetPath.unset(String path,
Expression updateFor) |
UpdateUnsetPath |
DefaultUpdateSetOrUnsetPath.unset(Expression path) |
UpdateUnsetPath |
DefaultUpdateSetOrUnsetPath.unset(Expression path,
Expression updateFor) |
UpdateUnsetPath |
DefaultUpdateSetOrUnsetPath.unset(String path,
Expression updateFor) |
UpdateUnsetPath |
DefaultUpdateUnsetPath.unset(Expression path) |
UpdateUnsetPath |
DefaultUpdateUnsetPath.unset(Expression path,
Expression updateFor) |
UpdateUnsetPath |
DefaultUpdateUnsetPath.unset(String path,
Expression updateFor) |
UpdateUnsetPath |
InitialUpdateUnsetPath.unset(Expression path) |
UpdateUnsetPath |
InitialUpdateUnsetPath.unset(Expression path,
Expression updateFor) |
UpdateUnsetPath |
InitialUpdateUnsetPath.unset(String path,
Expression updateFor) |
MergeUpdateUnsetPath |
MergeUpdateSetOrUnsetPath.unset(Expression path) |
MergeUpdateUnsetPath |
MergeUpdateSetOrUnsetPath.unset(Expression path,
Expression updateFor) |
MergeUpdateUnsetPath |
MergeUpdateSetOrUnsetPath.unset(String path,
Expression updateFor) |
MergeUpdateUnsetPath |
MergeUpdateSetPath.unset(Expression path) |
MergeUpdateUnsetPath |
MergeUpdateSetPath.unset(Expression path,
Expression updateFor) |
MergeUpdateUnsetPath |
MergeUpdateSetPath.unset(String path,
Expression updateFor) |
MergeUpdateUnsetPath |
MergeUpdateUnsetPath.unset(Expression path) |
MergeUpdateUnsetPath |
MergeUpdateUnsetPath.unset(Expression path,
Expression updateFor) |
MergeUpdateUnsetPath |
MergeUpdateUnsetPath.unset(String path,
Expression updateFor) |
UpdateUnsetPath |
UpdateSetOrUnsetPath.unset(Expression path) |
UpdateUnsetPath |
UpdateSetOrUnsetPath.unset(Expression path,
Expression updateFor) |
UpdateUnsetPath |
UpdateSetOrUnsetPath.unset(String path,
Expression updateFor) |
UpdateUnsetPath |
UpdateUnsetPath.unset(Expression path) |
UpdateUnsetPath |
UpdateUnsetPath.unset(Expression path,
Expression updateFor) |
UpdateUnsetPath |
UpdateUnsetPath.unset(String path,
Expression updateFor) |
MutateWherePath |
DefaultDeleteUsePath.useKeys(Expression expression) |
LetPath |
DefaultKeysPath.useKeys(Expression expression) |
UpdateSetOrUnsetPath |
DefaultUpdateUsePath.useKeys(Expression expression) |
MutateWherePath |
DeleteUsePath.useKeys(Expression expression) |
LetPath |
KeysPath.useKeys(Expression expression)
use the primary keyspace (doc id) in a join clause)
|
UpdateSetOrUnsetPath |
UpdateUsePath.useKeys(Expression expression) |
MergeKeyClausePath |
DefaultMergeSourcePath.using(Expression source) |
MergeKeyClausePath |
MergeSourcePath.using(Expression source) |
InsertValuesPath |
DefaultInitialInsertPath.values(Expression id,
boolean value) |
InsertValuesPath |
DefaultInitialInsertPath.values(Expression id,
double value) |
InsertValuesPath |
DefaultInitialInsertPath.values(Expression id,
float value) |
InsertValuesPath |
DefaultInitialInsertPath.values(Expression id,
int value) |
InsertValuesPath |
DefaultInitialInsertPath.values(Expression id,
long value) |
InsertValuesPath |
DefaultInitialInsertPath.values(Expression id,
JsonArray value) |
InsertValuesPath |
DefaultInitialInsertPath.values(Expression id,
JsonObject value) |
InsertValuesPath |
DefaultInitialInsertPath.values(Expression id,
Expression value) |
InsertValuesPath |
DefaultInitialInsertPath.values(Expression id,
String value) |
InsertValuesPath |
DefaultInitialInsertPath.values(String id,
Expression value) |
InsertValuesPath |
DefaultInsertValuesPath.values(Expression id,
boolean value) |
InsertValuesPath |
DefaultInsertValuesPath.values(Expression id,
double value) |
InsertValuesPath |
DefaultInsertValuesPath.values(Expression id,
float value) |
InsertValuesPath |
DefaultInsertValuesPath.values(Expression id,
int value) |
InsertValuesPath |
DefaultInsertValuesPath.values(Expression id,
long value) |
InsertValuesPath |
DefaultInsertValuesPath.values(Expression id,
JsonArray value) |
InsertValuesPath |
DefaultInsertValuesPath.values(Expression id,
JsonObject value) |
InsertValuesPath |
DefaultInsertValuesPath.values(Expression id,
Expression value) |
InsertValuesPath |
DefaultInsertValuesPath.values(Expression id,
String value) |
InsertValuesPath |
DefaultInsertValuesPath.values(String id,
Expression value) |
InsertValuesPath |
InitialInsertPath.values(Expression id,
boolean value) |
InsertValuesPath |
InitialInsertPath.values(Expression id,
double value) |
InsertValuesPath |
InitialInsertPath.values(Expression id,
float value) |
InsertValuesPath |
InitialInsertPath.values(Expression id,
int value) |
InsertValuesPath |
InitialInsertPath.values(Expression id,
long value) |
InsertValuesPath |
InitialInsertPath.values(Expression id,
JsonArray value) |
InsertValuesPath |
InitialInsertPath.values(Expression id,
JsonObject value) |
InsertValuesPath |
InitialInsertPath.values(Expression id,
Expression value) |
InsertValuesPath |
InitialInsertPath.values(Expression id,
String value) |
InsertValuesPath |
InitialInsertPath.values(String id,
Expression value) |
InsertValuesPath |
InsertValuesPath.values(Expression id,
boolean value) |
InsertValuesPath |
InsertValuesPath.values(Expression id,
double value) |
InsertValuesPath |
InsertValuesPath.values(Expression id,
float value) |
InsertValuesPath |
InsertValuesPath.values(Expression id,
int value) |
InsertValuesPath |
InsertValuesPath.values(Expression id,
long value) |
InsertValuesPath |
InsertValuesPath.values(Expression id,
JsonArray value) |
InsertValuesPath |
InsertValuesPath.values(Expression id,
JsonObject value) |
InsertValuesPath |
InsertValuesPath.values(Expression id,
Expression value) |
InsertValuesPath |
InsertValuesPath.values(Expression id,
String value) |
InsertValuesPath |
InsertValuesPath.values(String id,
Expression value) |
MergeInsertWherePath |
DefaultMergeInsertPath.whenNotMatchedThenInsert(Expression expression) |
MergeInsertWherePath |
MergeInsertPath.whenNotMatchedThenInsert(Expression expression) |
MergeInsertPath |
DefaultMergeDeleteWherePath.where(Expression expression) |
MutateLimitPath |
DefaultMergeInsertWherePath.where(Expression expression) |
MergeDeletePath |
DefaultMergeUpdateWherePath.where(Expression expression) |
MutateLimitPath |
DefaultMutateWherePath.where(Expression expression) |
GroupByPath |
DefaultWherePath.where(Expression expression) |
MergeInsertPath |
MergeDeleteWherePath.where(Expression expression) |
MutateLimitPath |
MergeInsertWherePath.where(Expression expression) |
MergeDeletePath |
MergeUpdateWherePath.where(Expression expression) |
MutateLimitPath |
MutateWherePath.where(Expression expression)
Filter resulting rows based on the given expression.
|
GroupByPath |
WherePath.where(Expression expression)
Filter resulting rows based on the given expression.
|
Modifier and Type | Method and Description |
---|---|
WherePath |
DefaultOnPath.on(String keyspace,
Expression expression,
Expression... additionalExpressions) |
WherePath |
DefaultOnPath.on(String namespace,
String keyspace,
Expression expression,
Expression... additionalExpressions) |
WherePath |
OnPath.on(String keyspace,
Expression expression,
Expression... additionalExpressions)
Describes the target of a secondary N1QL index.
|
WherePath |
OnPath.on(String namespace,
String keyspace,
Expression expression,
Expression... additionalExpressions)
Describes the target of a secondary N1QL index.
|
UsingWithPath |
DefaultWherePath.where(Expression filterExpression) |
UsingWithPath |
WherePath.where(Expression filterExpression)
Adds filtering clause to the secondary index creation.
|
Copyright © 2015 Couchbase, Inc.