Package org.apache.cayenne.exp.property
Interface ComparableProperty<E>
- All Superinterfaces:
Property<E>
- All Known Implementing Classes:
DateProperty,NumericIdProperty,NumericProperty,StringProperty
Interface (or "Trait") that provides basic functionality for comparable properties.
- Since:
- 4.2
- See Also:
-
Method Summary
Modifier and TypeMethodDescriptiondefault Expressiondefault Expressionbetween(ComparableProperty<?> lower, ComparableProperty<?> upper) default Expressiondefault Expressiongt(ComparableProperty<?> value) default ExpressiongtAll(ColumnSelect<E> subquery) default ExpressiongtAny(ColumnSelect<E> subquery) default Expressiondefault Expressiongte(ComparableProperty<?> value) default ExpressiongteAll(ColumnSelect<E> subquery) default ExpressiongteAny(ColumnSelect<E> subquery) default Expressiondefault Expressionlt(ComparableProperty<?> value) default ExpressionltAll(ColumnSelect<E> subquery) default ExpressionltAny(ColumnSelect<E> subquery) default Expressiondefault Expressionlte(ComparableProperty<?> value) default ExpressionlteAll(ColumnSelect<E> subquery) default ExpressionlteAny(ColumnSelect<E> subquery) default BaseProperty<E>max()default BaseProperty<E>min()
-
Method Details
-
between
- Parameters:
lower- The lower bound.upper- The upper bound.- Returns:
- An expression checking for objects between a lower and upper bound inclusive
-
between
- Parameters:
lower- The lower bound.upper- The upper bound.- Returns:
- An expression checking for objects between a lower and upper bound inclusive
-
gt
- Returns:
- A greater than Expression.
-
gt
- Returns:
- Represents a greater than relationship between two attributes (columns).
-
gte
- Returns:
- A greater than or equal to Expression.
-
gte
- Returns:
- Represents a greater than or equal relationship between two attributes (columns).
-
lt
- Returns:
- A less than Expression.
-
lt
- Returns:
- Represents a less than relationship between two attributes (columns).
-
lte
- Returns:
- A less than or equal to Expression.
-
lte
- Returns:
- Represents a less than or equal relationship between two attributes (columns).
-
max
-
min
-
ltAll
- Parameters:
subquery- to use, must be a single column query.- Returns:
Expressionthat translates to a "< ALL (subquery)" SQL- Since:
- 5.0
-
lteAll
- Parameters:
subquery- to use, must be a single column query.- Returns:
Expressionthat translates to a "<= ALL (subquery)" SQL- Since:
- 5.0
-
gtAll
- Parameters:
subquery- to use, must be a single column query.- Returns:
Expressionthat translates to a "> ALL (subquery)" SQL- Since:
- 5.0
-
gteAll
- Parameters:
subquery- to use, must be a single column query.- Returns:
Expressionthat translates to a ">= ALL (subquery)" SQL- Since:
- 5.0
-
ltAny
- Parameters:
subquery- to use, must be a single column query.- Returns:
Expressionthat translates to a "< ANY (subquery)" SQL- Since:
- 5.0
-
lteAny
- Parameters:
subquery- to use, must be a single column query.- Returns:
Expressionthat translates to a "<= ANY (subquery)" SQL- Since:
- 5.0
-
gtAny
- Parameters:
subquery- to use, must be a single column query.- Returns:
Expressionthat translates to a "> ANY (subquery)" SQL- Since:
- 5.0
-
gteAny
- Parameters:
subquery- to use, must be a single column query.- Returns:
Expressionthat translates to a ">= ANY (subquery)" SQL- Since:
- 5.0
-