Criteria query API.

Values
currentSource Codeshared current current
Functions
absSource Codeshared Expression<T> abs<T>(Expression<T> expression)
given T satisfies Object of Integer | Float
addSource Codeshared Expression<T> add<T>(Expression<T>+ expressions)
given T satisfies Object of Integer | Float
afterSource Codeshared Predicate after<T>(Expression<T> left, Expression<T> right)
given T satisfies JDate of Date | Time | Timestamp
andSource Codeshared Predicate and(Predicate+ predicates)
ascSource Codeshared Order asc<T>(Expression<T?>|Expression<T> expression)
given T satisfies Comparable<T> of Integer | Float | String
averageSource Codeshared Expression<T> average<T>(Expression<T> expression)
given T satisfies Number<T> of Integer | Float
beforeSource Codeshared Predicate before<T>(Expression<T> left, Expression<T> right)
given T satisfies JDate of Date | Time | Timestamp
betweenSource Codeshared Predicate between<T>(Expression<T> expression, Expression<T> lowerBound, Expression<T> upperBound)
given T satisfies Comparable<T> of Integer | Float | String
coalesceSource Codeshared Expression<T?> coalesce<T>(Expression<T?>+ expressions)
concatSource Codeshared Expression<String> concat(Expression<String>+ expressions)
constructSource Codeshared Selection<T> construct<T, A>(Class<T,A> type, Selection<A> select)
given T satisfies Object
countSource Codeshared Expression<Integer> count(Expression<out Anything> expression)
countDistinctSource Codeshared Expression<Integer> countDistinct(Expression<out Anything> expression)
descSource Codeshared Order desc<T>(Expression<T?>|Expression<T> expression)
given T satisfies Comparable<T> of Integer | Float | String
distinctSource Codeshared Selection<R> distinct<R>(Selection<R> selection)
divideSource Codeshared Expression<T> divide<T>(Expression<T> left, Expression<T> right)
given T satisfies Object of Integer | Float
earliestSource Codeshared Expression<T> earliest<T>(Expression<T> expression)
given T satisfies JDate of Date | Time | Timestamp
equalSource Codeshared Predicate equal<T>(Expression<T> left, Expression<T> right)
given T satisfies Object
greaterSource Codeshared Predicate greater<T>(Expression<T> left, Expression<T> right)
given T satisfies Comparable<T> of Integer | Float | String
greaterOrEqualSource Codeshared Predicate greaterOrEqual<T>(Expression<T> left, Expression<T> right)
given T satisfies Comparable<T> of Integer | Float | String
greatestSource Codeshared Expression<String> greatest(Expression<String> expression)
groupSource Codeshared Grouping group(Grouping* groupings)
latestSource Codeshared Expression<T> latest<T>(Expression<T> expression)
given T satisfies JDate of Date | Time | Timestamp
leastSource Codeshared Expression<String> least(Expression<String> expression)
lengthSource Codeshared Expression<Integer> length(Expression<String> expression)
lessSource Codeshared Predicate less<T>(Expression<T> left, Expression<T> right)
given T satisfies Comparable<T> of Integer | Float | String
lessOrEqualSource Codeshared Predicate lessOrEqual<T>(Expression<T> left, Expression<T> right)
given T satisfies Comparable<T> of Integer | Float | String
likeSource Codeshared Predicate like(Expression<String> expression, String pattern, Character? escape = null)
Parameters:
  • escape = null
literalSource Codeshared Expression<T> literal<T>(T literal)
given T satisfies Object of Integer | Float | String | Boolean
locateSource Codeshared Expression<Integer> locate(Expression<String> expression, String pattern, Integer position = 0)
Parameters:
  • position = 0
lowerSource Codeshared Expression<String> lower(Expression<String> expression)
maxSource Codeshared Expression<T> max<T>(Expression<T> expression)
given T satisfies Number<T> of Integer | Float
minSource Codeshared Expression<T> min<T>(Expression<T> expression)
given T satisfies Number<T> of Integer | Float
multiplySource Codeshared Expression<T> multiply<T>(Expression<T>+ expressions)
given T satisfies Object of Integer | Float
negativeSource Codeshared Expression<T> negative<T>(Expression<T> expression)
given T satisfies Object of Integer | Float
notSource Codeshared Predicate not(Predicate expression)
notEqualSource Codeshared Predicate notEqual<T>(Expression<T> left, Expression<T> right)
given T satisfies Object
notLikeSource Codeshared Predicate notLike(Expression<String> expression, String pattern, Character? escape = null)
Parameters:
  • escape = null
numericSource Codeshared Numeric<T> numeric<T>(Expression<T> expression)
given T satisfies Number<T> of Integer | Float
orSource Codeshared Predicate or(Predicate+ predicates)
orderSource Codeshared Order order(Order* orders)
predicateSource Codeshared Predicate predicate(Expression<Boolean> expression)
remainderSource Codeshared Expression<Integer> remainder(Expression<Integer> left, Expression<Integer> right)
sqrSource Codeshared Expression<T> sqr<T>(Expression<T> expression)
given T satisfies Object of Integer | Float
sqrtSource Codeshared Expression<T> sqrt<T>(Expression<T> expression)
given T satisfies Object of Integer | Float
substringSource Codeshared Expression<String> substring(Expression<String> expression, Integer from, Integer? length = null)
Parameters:
  • length = null
subtractSource Codeshared Expression<T> subtract<T>(Expression<T> left, Expression<T> right)
given T satisfies Object of Integer | Float
sumSource Codeshared Expression<T> sum<T>(Expression<T> expression)
given T satisfies Object of Integer | Float
trimSource Codeshared Expression<String> trim(Expression<String> expression, Character? character = null)
Parameters:
  • character = null
trimLeadingSource Codeshared Expression<String> trimLeading(Expression<String> expression, Character? character = null)
Parameters:
  • character = null
trimTrailingSource Codeshared Expression<String> trimTrailing(Expression<String> expression, Character? character = null)
Parameters:
  • character = null
upperSource Codeshared Expression<String> upper(Expression<String> expression)
withSource Codeshared Enumeration<T,T,[]> with<T>(Selection<T> selection)
with2Source Codeshared Selection<[A, B]> with2<A, B>(Selection<A> first, Selection<B> second)
with3Source Codeshared Selection<[A, B, C]> with3<A, B, C>(Selection<A> first, Selection<B> second, Selection<C> third)
with4Source Codeshared Selection<[A, B, C, D]> with4<A, B, C, D>(Selection<A> first, Selection<B> second, Selection<C> third, Selection<D> fourth)
with5Source Codeshared Selection<[A, B, C, D, E]> with5<A, B, C, D, E>(Selection<A> first, Selection<B> second, Selection<C> third, Selection<D> fourth, Selection<E> fifth)
with6Source Codeshared Selection<[A, B, C, D, E, F]> with6<A, B, C, D, E, F>(Selection<A> first, Selection<B> second, Selection<C> third, Selection<D> fourth, Selection<E> fifth, Selection<F> sixth)
Interfaces
ExpressionSource Codeshared Expression<T>
GroupingSource Codeshared Grouping
NumericSource Codeshared Numeric<T>
given T satisfies Number<T> of Integer | Float
OrderSource Codeshared Order
PredicateSource Codeshared Predicate
SelectionSource Codeshared Selection<out T>
Classes
CriteriaSource Codeshared Criteria
EnumerationSource Codeshared sealed Enumeration<out E,out F,out R>
FetchSource Codeshared sealed Fetch<out E,out T>
given T satisfies Object
FetchParentSource Codeshared abstract FetchParent<out T>
given T satisfies Object
FromSource Codeshared abstract From<out T>
given T satisfies Object
JoinSource Codeshared sealed Join<out E,out T>
given E satisfies Object
given T satisfies Object
JoinTypeSource Codeshared JoinType
ListJoinSource Codeshared sealed ListJoin<out E,out T>
given E satisfies Object
given T satisfies Object
MapJoinSource Codeshared sealed MapJoin<out E,out K,out V>
given E satisfies Object
given K satisfies Object
given V satisfies Object
RootSource Codeshared sealed Root<out T>
given T satisfies Object
SetJoinSource Codeshared sealed SetJoin<out E,out T>
given E satisfies Object
given T satisfies Object
currentSource Codeshared current