Interface ComparableExpression<C extends Comparable<? super C>>

Type Parameters:

C - the type of the expression

All Superinterfaces:

Expression<C>, Selection<C>, TupleElement<C>

All Known Subinterfaces:

BooleanExpression, BooleanPath, CriteriaBuilder.In<T>, NumericExpression<N>, Predicate, TemporalExpression<T>, TextExpression

public interface ComparableExpression<C extends Comparable<? super C>>
extends Expression<C>

Type for comparable query expressions.

Since:

4.0

Method Summary

Modifier and Type	Method	Description
Order	asc()	Create an ordering by the ascending value of this expression.
Order	asc(Nulls nullPrecedence)	Create an ordering by the ascending value of this expression.
Predicate	between(C x, C y)	Create a predicate for testing whether this expression is between the first and second arguments in value.
Predicate	between(Expression<? extends C> x, Expression<? extends C> y)	Create a predicate for testing whether this expression is between the first and second arguments in value.
ComparableExpression<C>	coalesce(C y)	Create an expression that returns null if this and the argument evaluate to null, and the value of the first non-null expression otherwise.
ComparableExpression<C>	coalesce(Expression<? extends C> y)	Create an expression that returns null if this and the argument evaluate to null, and the value of the first non-null expression otherwise.
Order	desc()	Create an ordering by the descending value of this expression.
Order	desc(Nulls nullPrecedence)	Create an ordering by the descending value of this expression.
Predicate	greaterThan(C y)	Create a predicate for testing whether this expression is greater than the first argument.
Predicate	greaterThan(Expression<? extends C> y)	Create a predicate for testing whether this expression is greater than the first argument.
Predicate	greaterThanOrEqualTo(C y)	Create a predicate for testing whether this expression is greater than or equal to the first argument.
Predicate	greaterThanOrEqualTo(Expression<? extends C> y)	Create a predicate for testing whether this expression is greater than or equal to the first argument.
Predicate	lessThan(C y)	Create a predicate for testing whether this expression is less than the first argument.
Predicate	lessThan(Expression<? extends C> y)	Create a predicate for testing whether this expression is less than the first argument.
Predicate	lessThanOrEqualTo(C y)	Create a predicate for testing whether this expression is less than or equal to the first argument.
Predicate	lessThanOrEqualTo(Expression<? extends C> y)	Create a predicate for testing whether this expression is less than or equal to the first argument.
ComparableExpression<C>	max()	Create an aggregate expression for finding the greatest of the values (strings, dates, etc).
ComparableExpression<C>	min()	Create an aggregate expression for finding the least of the values (strings, dates, etc).
ComparableExpression<C>	nullif(C y)	Create an expression that tests whether this expression is equal to the argument, returning null if they are and the value of the first expression if they are not.
ComparableExpression<C>	nullif(Expression<? extends C> y)	Create an expression that tests whether this expression is equal to the argument, returning null if they are and the value of the first expression if they are not.

Methods inherited from interface Expression

as, cast, count, countDistinct, equalTo, equalTo, in, in, in, in, in, isMember, isNotMember, isNotNull, isNull, notEqualTo, notEqualTo, selectCase

Methods inherited from interface Selection

alias, getCompoundSelectionItems, isCompoundSelection

Methods inherited from interface TupleElement

getAlias, getJavaType

Method Details

greaterThan

Predicate greaterThan(Expression<? extends C> y)

Create a predicate for testing whether this expression is greater than the first argument.

Parameters:

y - expression

Returns:

greater-than predicate

See Also:

• CriteriaBuilder.greaterThan(Expression, Expression)

greaterThan

Predicate greaterThan(C y)

Create a predicate for testing whether this expression is greater than the first argument.

Parameters:

y - value

Returns:

greater-than predicate

See Also:

• CriteriaBuilder.greaterThan(Expression, Comparable)

greaterThanOrEqualTo

Predicate greaterThanOrEqualTo(Expression<? extends C> y)

Create a predicate for testing whether this expression is greater than or equal to the first argument.

Parameters:

y - expression

Returns:

greater-than-or-equal predicate

See Also:

• CriteriaBuilder.greaterThanOrEqualTo(Expression, Expression)

greaterThanOrEqualTo

Predicate greaterThanOrEqualTo(C y)

Create a predicate for testing whether this expression is greater than or equal to the first argument.

Parameters:

y - value

Returns:

greater-than-or-equal predicate

See Also:

• CriteriaBuilder.greaterThanOrEqualTo(Expression, Comparable)

lessThan

Predicate lessThan(Expression<? extends C> y)

Create a predicate for testing whether this expression is less than the first argument.

Parameters:

y - expression

Returns:

less-than predicate

See Also:

• CriteriaBuilder.lessThan(Expression, Expression)

lessThan

Predicate lessThan(C y)

Create a predicate for testing whether this expression is less than the first argument.

Parameters:

y - value

Returns:

less-than predicate

See Also:

• CriteriaBuilder.lessThan(Expression, Comparable)

lessThanOrEqualTo

Predicate lessThanOrEqualTo(Expression<? extends C> y)

Create a predicate for testing whether this expression is less than or equal to the first argument.

Parameters:

y - expression

Returns:

less-than-or-equal predicate

See Also:

• CriteriaBuilder.lessThanOrEqualTo(Expression, Expression)

lessThanOrEqualTo

Predicate lessThanOrEqualTo(C y)

Create a predicate for testing whether this expression is less than or equal to the first argument.

Parameters:

y - value

Returns:

less-than-or-equal predicate

See Also:

• CriteriaBuilder.lessThanOrEqualTo(Expression, Comparable)

between

Predicate between(Expression<? extends C> x,
 Expression<? extends C> y)

Create a predicate for testing whether this expression is between the first and second arguments in value.

Parameters:

x - expression

y - expression

Returns:

between predicate

See Also:

• CriteriaBuilder.between(Expression, Expression, Expression)

between

Predicate between(C x,
 C y)

Create a predicate for testing whether this expression is between the first and second arguments in value.

Parameters:

x - value

y - value

Returns:

between predicate

See Also:

• CriteriaBuilder.between(Expression, Comparable, Comparable)

max

ComparableExpression<C> max()

Create an aggregate expression for finding the greatest of the values (strings, dates, etc).

Returns:

greatest expression

See Also:

• CriteriaBuilder.greatest(Expression)

min

ComparableExpression<C> min()

Create an aggregate expression for finding the least of the values (strings, dates, etc).

Returns:

least expression

See Also:

• CriteriaBuilder.least(Expression)

asc

Order asc()

Create an ordering by the ascending value of this expression.

Returns:

ascending ordering corresponding to this expression

Since:

4.0

desc

Order desc()

Create an ordering by the descending value of this expression.

Returns:

descending ordering corresponding to this expression

asc

Order asc(Nulls nullPrecedence)

Create an ordering by the ascending value of this expression.

Parameters:

nullPrecedence - the precedence of null values

Returns:

ascending ordering corresponding to this expression

desc

Order desc(Nulls nullPrecedence)

Create an ordering by the descending value of this expression.

Parameters:

nullPrecedence - the precedence of null values

Returns:

descending ordering corresponding to this expression

coalesce

ComparableExpression<C> coalesce(C y)

Description copied from interface: Expression

Create an expression that returns null if this and the argument evaluate to null, and the value of the first non-null expression otherwise.

Specified by:

coalesce in interface Expression<C extends Comparable<? super C>>

Parameters:

y - value

Returns:

coalesce expression

coalesce

ComparableExpression<C> coalesce(Expression<? extends C> y)

Description copied from interface: Expression

Create an expression that returns null if this and the argument evaluate to null, and the value of the first non-null expression otherwise.

Specified by:

coalesce in interface Expression<C extends Comparable<? super C>>

Parameters:

y - expression

Returns:

coalesce expression

nullif

ComparableExpression<C> nullif(C y)

Description copied from interface: Expression

Create an expression that tests whether this expression is equal to the argument, returning null if they are and the value of the first expression if they are not.

Specified by:

nullif in interface Expression<C extends Comparable<? super C>>

Parameters:

y - value

Returns:

nullif expression

nullif

ComparableExpression<C> nullif(Expression<? extends C> y)

Description copied from interface: Expression

Create an expression that tests whether this expression is equal to the argument, returning null if they are and the value of the first expression if they are not.

Specified by:

nullif in interface Expression<C extends Comparable<? super C>>

Parameters:

y - expression

Returns:

nullif expression