public interface Value<T> extends CqnValue, Orderable
Modifier and Type | Method and Description |
---|---|
CqnSelectListValue |
as(String alias) |
Value<Number> |
average()
Creates a function by passing this value as a parameter to the underlying
data store's AVG function.
|
Predicate |
between(T low,
T high)
Creates a between predicate that tests if this value is within a closed
interval with given bounds
|
Predicate |
between(T low,
Value<T> high)
Creates a between predicate that tests if this value is within a closed
interval with given bounds
|
Predicate |
between(Value<T> low,
T high)
Creates a between predicate that tests if this value is within a closed
interval with given bounds
|
Predicate |
between(Value<T> low,
Value<T> high)
Creates a between predicate that tests if this value is within a closed
interval with given bounds
|
Predicate |
contains(String substring)
Creates a predicate that tests whether this string value contains a given
substring
|
Predicate |
contains(Value<String> substring)
Creates a predicate that tests whether this string value contains a given
substring
|
Predicate |
contains(Value<String> substring,
boolean caseInsensitive)
Creates a predicate that tests whether this string value contains a given
substring
|
Value<Long> |
countDistinct()
Creates a function by passing this value as a parameter with the DISTINCT
keyword to the underlying data store's COUNT function.
|
Value<Number> |
dividedBy(Number d)
Creates an expression that divides this numeric value by a given divisor
|
Value<Number> |
dividedBy(Value<? extends Number> d)
Creates an expression that divides this numeric value by a given divisor
|
Predicate |
endsWith(String suffix)
Creates a predicate that tests whether this string value ends with a given
suffix
|
Predicate |
endsWith(Value<String> suffix)
Creates a predicate that tests whether this string value ends with a given
suffix
|
Predicate |
eq(T v)
Creates a comparison predicate that tests if this value is equal to a given
value.
|
Predicate |
eq(Value<T> v)
Creates a comparison predicate that tests if this value is equal to a given
value.
|
Predicate |
func(String functionName,
Value<?>... additional)
Creates a predicate that applies a given function to this values and optional
additional values
|
Predicate |
ge(T v)
Creates a comparison predicate that tests if this value is greater than or
equal to a given value
|
Predicate |
ge(Value<T> v)
Creates a comparison predicate that tests if this value is greater than or
equal to a given value
|
Predicate |
gt(T v)
Creates a comparison predicate that tests if this value is greater than a
given value
|
Predicate |
gt(Value<T> v)
Creates a comparison predicate that tests if this value is greater than a
given value
|
Predicate |
in(Iterable<Value<? extends T>> ts)
Creates an IN predicate that tests if this value is equal to any value in a
given list
|
Predicate |
in(List<? extends T> ts)
Creates an IN predicate that tests if this value is equal to any value in a
given list
|
Predicate |
in(T... vs)
Creates an IN predicate that tests if this value is equal to any value in a
given list
|
Predicate |
in(Value<T>... ts)
Creates an IN predicate that tests if this value is equal to any value in a
given list
|
Predicate |
is(T v)
Creates a comparison predicate that tests if this value is equal to a given
value.
|
Predicate |
is(Value<T> v)
Creates a comparison predicate that tests if this value is equal to a given
value.
|
Predicate |
isNot(T v)
Creates a comparison predicate that tests if this value is not equal to a
given value.
|
Predicate |
isNot(Value<T> v)
Creates a comparison predicate that tests if this value is not equal to a
given value.
|
Predicate |
isNotNull()
Creates a predicate that tests if this value is not NULL
|
Predicate |
isNull()
Creates a predicate that tests if this value is NULL
|
Predicate |
le(T v)
Creates a comparison predicate that tests if this value is less than or equal
to a given value
|
Predicate |
le(Value<T> v)
Creates a comparison predicate that tests if this value is less than or equal
to a given value
|
Predicate |
lt(T v)
Creates a comparison predicate that tests if this value is less than a given
value
|
Predicate |
lt(Value<T> v)
Creates a comparison predicate that tests if this value is less than a given
value
|
Value<T> |
max()
Creates a function by passing this value as a parameter to the underlying
data store's MAX function.
|
Value<T> |
min()
Creates a function by passing this value as a parameter to the underlying
data store's MIN function.
|
Value<Number> |
minus(Number s)
Creates an expression that subtracts a given subtrahend from this numeric
value
|
Value<Number> |
minus(Value<? extends Number> s)
Creates an expression that subtracts a given subtrahend from this numeric
value
|
Predicate |
ne(T v)
Creates a comparison predicate that tests if this value is not equal to a
given value.
|
Predicate |
ne(Value<T> v)
Creates a comparison predicate that tests if this value is not equal to a
given value.
|
Predicate |
plain(Object... p) |
Value<Number> |
plus(Number s)
Creates an expression that adds a given summand to this numeric value
|
Value<Number> |
plus(Value<? extends Number> s)
Creates an expression that adds a given summand to this numeric value
|
Predicate |
startsWith(String prefix)
Creates a predicate that tests whether this string value starts with a given
prefix
|
Predicate |
startsWith(Value<String> prefix)
Creates a predicate that tests whether this string value starts with a given
prefix
|
Value<String> |
substring(int start)
Creates an expression for substring extraction from this string value.
|
Value<String> |
substring(int start,
int length)
Creates an expression for substring extraction from this string value.
|
Value<String> |
substring(Value<Integer> start)
Creates an expression for substring extraction from this string value.
|
Value<String> |
substring(Value<Integer> start,
Value<Integer> length)
Creates an expression for substring extraction from this value.
|
Value<Number> |
sum()
Creates a function by passing this value as a parameter to the underlying
data store's SUM function.
|
Value<Number> |
times(Number f)
Creates an expression that multiplies this numeric value with a given factor
|
Value<Number> |
times(Value<? extends Number> f)
Creates an expression that multiplies this numeric value with a given factor
|
Value<String> |
toLower()
Creates an expression for converting this string value to lower case using
the rules of the underlying data store.
|
Value<String> |
toUpper()
Creates an expression for converting this string value to upper case using
the rules of the underlying data store.
|
<U> Value<U> |
type(CdsBaseType cdsType) |
<U> Value<U> |
type(Class<U> javaType) |
<U> Value<U> |
type(String cdsType) |
CqnSelectListValue |
withoutAlias() |
as, asExpression, asFunction, asList, asLiteral, asNullValue, asParameter, asPlain, asRef, isExpression, isFunction, isList, isLiteral, isNullValue, isParameter, isPlain, isRef, ofRef, type
toJson
asc, ascNullsLast, desc, descNullsFirst
Value<Number> plus(Number s)
s
- the summandValue<Number> plus(Value<? extends Number> s)
s
- the summandValue<Number> minus(Number s)
s
- the subtrahendValue<Number> minus(Value<? extends Number> s)
s
- the subtrahendValue<Number> times(Number f)
f
- the factorValue<Number> times(Value<? extends Number> f)
f
- the factorValue<Number> dividedBy(Number d)
d
- the divisorValue<Number> dividedBy(Value<? extends Number> d)
d
- the divisorValue<String> substring(Value<Integer> start, Value<Integer> length)
start
- the start positionlength
- the number of characters that you want to extractValue<String> substring(int start, int length)
start
- the start positionlength
- the number of characters that you want to extractValue<String> substring(Value<Integer> start)
start
- the start positionValue<String> substring(int start)
start
- the start positionValue<String> toUpper()
Value<String> toLower()
Value<T> min()
Value<T> max()
Value<Number> sum()
Value<Number> average()
Value<Long> countDistinct()
Predicate isNull()
Predicate isNotNull()
Predicate eq(T v)
v
- the value to compare withPredicate eq(Value<T> v)
v
- the value to compare withPredicate ne(T v)
v
- the value to compare withPredicate ne(Value<T> v)
v
- the value to compare withPredicate is(T v)
v
- the value to compare withPredicate is(Value<T> v)
v
- the value to compare withPredicate isNot(T v)
v
- the value to compare withPredicate isNot(Value<T> v)
v
- the value to compare withPredicate gt(T v)
v
- the value to compare withPredicate gt(Value<T> v)
v
- the value to compare withPredicate ge(T v)
v
- the value to compare withPredicate ge(Value<T> v)
v
- the value to compare withPredicate lt(T v)
v
- the value to compare withPredicate lt(Value<T> v)
v
- the value to compare withPredicate le(T v)
v
- the value to compare withPredicate le(Value<T> v)
v
- the value to compare withPredicate between(T low, T high)
low
- the lower boundhigh
- the upper boundPredicate between(Value<T> low, T high)
low
- the lower boundhigh
- the upper boundPredicate between(T low, Value<T> high)
low
- the lower boundhigh
- the upper boundPredicate between(Value<T> low, Value<T> high)
low
- the lower boundhigh
- the upper boundPredicate in(T... vs)
vs
- the given valuesPredicate in(List<? extends T> ts)
ts
- the given valuesPredicate in(Value<T>... ts)
ts
- the given valuesPredicate in(Iterable<Value<? extends T>> ts)
ts
- the given valuesPredicate func(String functionName, Value<?>... additional)
functionName
- the function nameadditional
- the additional valuesPredicate contains(String substring)
substring
- the substringPredicate contains(Value<String> substring)
substring
- the substringPredicate contains(Value<String> substring, boolean caseInsensitive)
substring
- the substringcaseInsensitive
- whether the test should be case insensitivePredicate startsWith(String prefix)
prefix
- the prefixPredicate startsWith(Value<String> prefix)
prefix
- the prefixPredicate endsWith(String suffix)
suffix
- the suffixPredicate endsWith(Value<String> suffix)
suffix
- the suffixCqnSelectListValue as(String alias)
CqnSelectListValue withoutAlias()
<U> Value<U> type(CdsBaseType cdsType)
Copyright © 2023 SAP. All rights reserved.