object Builder
avg |
fun <O, R> KProperty1<O, R?>.avg(groupByColumns: List<KProperty1<O, R>>? = null, orderBy: Direction? = null): AggregateFunctionExpression<O, R> fun <R> Field. fun <R> FieldInfo.avg(groupByColumns: List<FieldInfo>? = null, orderBy: Direction? = null): AggregateFunctionExpression<Any, R> |
between |
fun <O, R : Comparable<R>> KProperty1<O, R?>.between(from: R, to: R): ColumnPredicateExpression<O, R> fun <R : Comparable<R>> Field. fun <R : Comparable<R>> FieldInfo.between(from: R, to: R): ColumnPredicateExpression<Any, R> fun <R : Comparable<R>> between(from: R, to: R): Between<R> |
compare |
fun <R : Comparable<R>> compare(operator: BinaryComparisonOperator, value: R): BinaryComparison<R> |
comparePredicate |
fun <O, R : Comparable<R>> KProperty1<O, R?>.comparePredicate(operator: BinaryComparisonOperator, value: R): ColumnPredicateExpression<O, R> fun <R : Comparable<R>> Field. fun <R : Comparable<R>> FieldInfo.comparePredicate(operator: BinaryComparisonOperator, value: R): ColumnPredicateExpression<Any, R> |
count |
fun <O, R> KProperty1<O, R?>.count(): AggregateFunctionExpression<O, R> fun Field. fun FieldInfo.count(): AggregateFunctionExpression<Any, Any> |
equal |
fun <O, R> KProperty1<O, R?>.equal(value: R, exactMatch: Boolean = true): ColumnPredicateExpression<O, R> fun <R> Field. fun <R> FieldInfo.equal(value: R, exactMatch: Boolean = true): ColumnPredicateExpression<Any, R> fun <R> equal(value: R, exactMatch: Boolean = true): EqualityComparison<R> |
functionPredicate |
fun <O, R> KProperty1<O, R?>.functionPredicate(predicate: ColumnPredicate<R>, groupByColumns: List<Column<O, R>>? = null, orderBy: Direction? = null): AggregateFunctionExpression<O, R> fun <R> Field. fun <R> FieldInfo.functionPredicate(predicate: ColumnPredicate<R>, groupByColumns: List<Column<Any, R>>? = null, orderBy: Direction? = null): AggregateFunctionExpression<Any, R> |
greaterThan |
fun <O, R : Comparable<R>> KProperty1<O, R?>.greaterThan(value: R): ColumnPredicateExpression<O, R> fun <R : Comparable<R>> Field. fun <R : Comparable<R>> FieldInfo.greaterThan(value: R): ColumnPredicateExpression<Any, R> fun <R : Comparable<R>> greaterThan(value: R): BinaryComparison<R> |
greaterThanOrEqual |
fun <O, R : Comparable<R>> KProperty1<O, R?>.greaterThanOrEqual(value: R): ColumnPredicateExpression<O, R> fun <R : Comparable<R>> Field. fun <R : Comparable<R>> FieldInfo.greaterThanOrEqual(value: R): ColumnPredicateExpression<Any, R> fun <R : Comparable<R>> greaterThanOrEqual(value: R): BinaryComparison<R> |
in |
fun <O, R : Comparable<R>> KProperty1<O, R?>.in(collection: Collection<R>, exactMatch: Boolean = true): ColumnPredicateExpression<O, R> fun <R : Comparable<R>> Field. fun <R : Comparable<R>> FieldInfo.in(collection: Collection<R>, exactMatch: Boolean = true): ColumnPredicateExpression<Any, R> fun <R : Comparable<R>> in(collection: Collection<R>, exactMatch: Boolean = true): CollectionExpression<R> |
isNotNull |
fun <R> isNotNull(): NullExpression<R> |
isNull |
fun <R> isNull(): NullExpression<R> fun <O, R> KProperty1<O, R?>.isNull(): ColumnPredicateExpression<O, R> fun Field. fun FieldInfo.isNull(): ColumnPredicateExpression<Any, Any> |
lessThan |
fun <O, R : Comparable<R>> KProperty1<O, R?>.lessThan(value: R): ColumnPredicateExpression<O, R> fun <R : Comparable<R>> Field. fun <R : Comparable<R>> FieldInfo.lessThan(value: R): ColumnPredicateExpression<Any, R> fun <R : Comparable<R>> lessThan(value: R): BinaryComparison<R> |
lessThanOrEqual |
fun <O, R : Comparable<R>> KProperty1<O, R?>.lessThanOrEqual(value: R): ColumnPredicateExpression<O, R> fun <R : Comparable<R>> Field. fun <R : Comparable<R>> FieldInfo.lessThanOrEqual(value: R): ColumnPredicateExpression<Any, R> fun <R : Comparable<R>> lessThanOrEqual(value: R): BinaryComparison<R> |
like |
fun like(string: String, exactMatch: Boolean = true): Likeness fun <O> KProperty1<O, String?>.like(string: String, exactMatch: Boolean = true): ColumnPredicateExpression<O, String> fun Field. fun FieldInfo.like(string: String, exactMatch: Boolean = true): ColumnPredicateExpression<Any, String> |
max |
fun <O, R> KProperty1<O, R?>.max(groupByColumns: List<KProperty1<O, R>>? = null, orderBy: Direction? = null): AggregateFunctionExpression<O, R> fun <R> Field. fun <R> FieldInfo.max(groupByColumns: List<FieldInfo>? = null, orderBy: Direction? = null): AggregateFunctionExpression<Any, R> |
min |
fun <O, R> KProperty1<O, R?>.min(groupByColumns: List<KProperty1<O, R>>? = null, orderBy: Direction? = null): AggregateFunctionExpression<O, R> fun <R> Field. fun <R> FieldInfo.min(groupByColumns: List<FieldInfo>? = null, orderBy: Direction? = null): AggregateFunctionExpression<Any, R> |
notEqual |
fun <O, R> KProperty1<O, R?>.notEqual(value: R, exactMatch: Boolean = true): ColumnPredicateExpression<O, R> fun <R> Field. fun <R> FieldInfo.notEqual(value: R, exactMatch: Boolean = true): ColumnPredicateExpression<Any, R> fun <R> notEqual(value: R, exactMatch: Boolean = true): EqualityComparison<R> |
notIn |
fun <O, R : Comparable<R>> KProperty1<O, R?>.notIn(collection: Collection<R>, exactMatch: Boolean = true): ColumnPredicateExpression<O, R> fun <R : Comparable<R>> Field. fun <R : Comparable<R>> FieldInfo.notIn(collection: Collection<R>, exactMatch: Boolean = true): ColumnPredicateExpression<Any, R> fun <R : Comparable<R>> notIn(collection: Collection<R>, exactMatch: Boolean = true): CollectionExpression<R> |
notLike |
fun notLike(string: String, exactMatch: Boolean = true): Likeness fun <O> KProperty1<O, String?>.notLike(string: String, exactMatch: Boolean = true): ColumnPredicateExpression<O, String> fun Field. fun FieldInfo.notLike(string: String, exactMatch: Boolean = true): ColumnPredicateExpression<Any, String> |
notNull |
fun <O, R> KProperty1<O, R?>.notNull(): ColumnPredicateExpression<O, R> fun Field. fun FieldInfo.notNull(): ColumnPredicateExpression<Any, Any> |
predicate |
fun <O, R> KProperty1<O, R?>.predicate(predicate: ColumnPredicate<R>): ColumnPredicateExpression<O, R> fun <R> Field. fun <R> FieldInfo.predicate(predicate: ColumnPredicate<R>): ColumnPredicateExpression<Any, R> |
sum |
aggregate functions fun <O, R> KProperty1<O, R?>.sum(groupByColumns: List<KProperty1<O, R>>? = null, orderBy: Direction? = null): AggregateFunctionExpression<O, R> fun <R> Field. fun <R> FieldInfo.sum(groupByColumns: List<FieldInfo>? = null, orderBy: Direction? = null): AggregateFunctionExpression<Any, R> |