public interface QueryHaving<Q extends Query>
Modifier and Type | Method and Description |
---|---|
default <F extends Number,R extends EntityRelation> |
having(ColumnFunction<? extends Entity,F,R,F> col,
InnerQueryField<? extends R,F> val) |
default <E extends Entity,F extends Number,R extends EntityRelation> |
having(ColumnFunction<E,F,R,F> column,
F val)
Condition: column value must be EQUAL to value
|
default <E extends Entity,F extends Number,R extends EntityRelation> |
having(ColumnFunction<E,F,R,F> column,
R val)
Condition: column value must be EQUAL to value taken from related object.
|
default Q |
having(Having wrapper) |
default Q |
havingAnd(Supplier<WhereAnd> wrapper) |
default <F extends Number> |
havingBetween(ColumnFunction<?,F,?,F> column,
F valueFrom,
F valueTo) |
default <F extends Number,R extends EntityRelation> |
havingBetween(ColumnFunction<?,F,R,F> column,
R valueFrom,
R valueTo) |
default <F> Q |
havingEqual(Column<?,F,?> column,
Column<?,F,?> column2)
Condition: consider only those records, having EQUAL values in both columns
|
default <E extends Entity,F,R extends EntityRelation> |
havingEqual(Column<E,F,R> column,
F val)
Condition: consider only those records, matching the value with specified relation
|
default <E extends Entity,F,R extends EntityRelation> |
havingEqual(Column<E,F,R> column,
R val)
Condition: consider only those records, matching the value taken from related object, with specified relation
|
default <F extends Number> |
havingEqual(ColumnFunction<?,F,?,F> column,
ColumnFunction<?,F,?,F> column2)
Condition: consider only those records, having specified relation between values in both columns
|
default <F extends Number,R extends EntityRelation> |
havingEqual(String column,
Object val) |
default <F> Q |
havingGreater(Column<?,F,?> column,
Column<?,F,?> column2) |
default <E extends Entity,F,R extends EntityRelation> |
havingGreater(Column<E,F,R> column,
F val) |
default <E extends Entity,F,R extends EntityRelation> |
havingGreater(Column<E,F,R> column,
R val) |
default <F extends Number,R extends EntityRelation> |
havingGreater(String column,
Object val) |
default <F> Q |
havingGreaterOrEqual(Column<?,F,?> column,
Column<?,F,?> column2) |
default <E extends Entity,F,R extends EntityRelation> |
havingGreaterOrEqual(Column<E,F,R> column,
F val) |
default <E extends Entity,F,R extends EntityRelation> |
havingGreaterOrEqual(Column<E,F,R> column,
R val) |
default <F extends Number,R extends EntityRelation> |
havingGreaterOrEqual(String column,
Object val) |
default <E extends Entity,F extends Number,R extends EntityRelation> |
havingIfNotNull(ColumnFunction<E,F,R,F> column,
F val)
Condition: column value can not be NULL.
|
default <E extends Entity,F,R extends EntityRelation> |
havingIn(Column<E,F,R> column,
Collection<F> val) |
default <E extends Entity,F,R extends EntityRelation> |
havingIn(Column<E,F,R> column,
F... val) |
default <E extends Entity,F,R extends EntityRelation> |
havingIn(Column<E,F,R> column,
R... val) |
default <F extends Number> |
havingIsNotNull(ColumnFunction<?,F,?,F> column) |
default <F extends Number> |
havingIsNull(ColumnFunction<?,F,?,F> column)
Condition: column feature must be specified by operator.
|
default <F> Q |
havingLess(Column<?,F,?> column,
Column<?,F,?> column2) |
default <E extends Entity,F,R extends EntityRelation> |
havingLess(Column<E,F,R> column,
F val) |
default <E extends Entity,F,R extends EntityRelation> |
havingLess(Column<E,F,R> column,
R val) |
default <F extends Number,R extends EntityRelation> |
havingLess(String column,
Object val) |
default <F> Q |
havingLessOrEqual(Column<?,F,?> column,
Column<?,F,?> column2) |
default <E extends Entity,F,R extends EntityRelation> |
havingLessOrEqual(Column<E,F,R> column,
F val) |
default <E extends Entity,F,R extends EntityRelation> |
havingLessOrEqual(Column<E,F,R> column,
R val) |
default <F extends Number,R extends EntityRelation> |
havingLessOrEqual(String column,
Object val) |
default <E extends Entity,F,R extends EntityRelation> |
havingLike(Column<E,F,R> column,
F val) |
default <E extends Entity,F,R extends EntityRelation> |
havingNotEqual(Column<E,F,R> column,
F val) |
default <E extends Entity,F,R extends EntityRelation> |
havingNotEqual(Column<E,F,R> column,
R val) |
default <F extends Number,R extends EntityRelation> |
havingNotEqual(String column,
Object val) |
default <E extends Entity,F,R extends EntityRelation> |
havingNotIn(Column<E,F,R> column,
Collection<F> val) |
default <E extends Entity,F,R extends EntityRelation> |
havingNotIn(Column<E,F,R> column,
F... val) |
default <E extends Entity,F,R extends EntityRelation> |
havingNotIn(Column<E,F,R> column,
R... val) |
default Q |
havingOR(Supplier<WhereOr> wrapper) |
void |
setHavingWrapper(Having havingWrapper) |
void setHavingWrapper(Having havingWrapper)
default <F extends Number,R extends EntityRelation> Q having(ColumnFunction<? extends Entity,F,R,F> col, InnerQueryField<? extends R,F> val)
default <E extends Entity,F extends Number,R extends EntityRelation> Q having(ColumnFunction<E,F,R,F> column, F val)
E
- Entity type (E extends io.daobab.model.Entity)F
- value typeR
- ColumnRelatedFunction(AVG,SUM,COUNT,MIN,MAX...), might also return F valuecolumn
- - representation of table column or class field - table columnval
- - value - valuedefault <E extends Entity,F extends Number,R extends EntityRelation> Q having(ColumnFunction<E,F,R,F> column, R val)
E
- Entity type (E extends io.daobab.model.Entity)F
- value typeR
- ColumnRelatedFunction(AVG,SUM,COUNT,MIN,MAX...), might also return F valuecolumn
- - representation of table column or class fieldval
- - valuedefault <E extends Entity,F extends Number,R extends EntityRelation> Q havingIfNotNull(ColumnFunction<E,F,R,F> column, F val)
E
- Entity type (E extends io.daobab.model.Entity)F
- value typeR
- ColumnRelatedFunction(AVG,SUM,COUNT,MIN,MAX...), might also return F valuecolumn
- - representation of table column or class fieldval
- - valuedefault <F extends Number> Q havingIsNull(ColumnFunction<?,F,?,F> column)
F
- value typecolumn
- - representation of table column or class fielddefault <F extends Number> Q havingIsNotNull(ColumnFunction<?,F,?,F> column)
default <E extends Entity,F,R extends EntityRelation> Q havingEqual(Column<E,F,R> column, F val)
E
- Entity type (E extends io.daobab.model.Entity)F
- value typeR
- ColumnRelatedFunction(AVG,SUM,COUNT,MIN,MAX...), might also return F valuecolumn
- - representation of table column or class field
// * @param operator - logical relationval
- - valuedefault <E extends Entity,F,R extends EntityRelation> Q havingNotEqual(Column<E,F,R> column, F val)
default <E extends Entity,F,R extends EntityRelation> Q havingGreater(Column<E,F,R> column, F val)
default <E extends Entity,F,R extends EntityRelation> Q havingGreaterOrEqual(Column<E,F,R> column, F val)
default <E extends Entity,F,R extends EntityRelation> Q havingLess(Column<E,F,R> column, F val)
default <E extends Entity,F,R extends EntityRelation> Q havingLessOrEqual(Column<E,F,R> column, F val)
default <E extends Entity,F,R extends EntityRelation> Q havingLike(Column<E,F,R> column, F val)
default <E extends Entity,F,R extends EntityRelation> Q havingEqual(Column<E,F,R> column, R val)
E
- Entity type (E extends io.daobab.model.Entity)F
- value typeR
- ColumnRelatedFunction(AVG,SUM,COUNT,MIN,MAX...), might also return F valuecolumn
- - representation of table column or class field
// * @param operator - logical relationval
- - valuedefault <E extends Entity,F,R extends EntityRelation> Q havingNotEqual(Column<E,F,R> column, R val)
default <E extends Entity,F,R extends EntityRelation> Q havingGreater(Column<E,F,R> column, R val)
default <E extends Entity,F,R extends EntityRelation> Q havingGreaterOrEqual(Column<E,F,R> column, R val)
default <E extends Entity,F,R extends EntityRelation> Q havingLess(Column<E,F,R> column, R val)
default <E extends Entity,F,R extends EntityRelation> Q havingLessOrEqual(Column<E,F,R> column, R val)
default <E extends Entity,F,R extends EntityRelation> Q havingIn(Column<E,F,R> column, F... val)
E
- Entity type (E extends io.daobab.model.Entity)F
- value typeR
- ColumnRelatedFunction(AVG,SUM,COUNT,MIN,MAX...), might also return F valuecolumn
- - representation of table column or class fieldval
- - valuedefault <E extends Entity,F,R extends EntityRelation> Q havingNotIn(Column<E,F,R> column, F... val)
default <E extends Entity,F,R extends EntityRelation> Q havingIn(Column<E,F,R> column, Collection<F> val)
E
- Entity type (E extends io.daobab.model.Entity)F
- value typeR
- ColumnRelatedFunction(AVG,SUM,COUNT,MIN,MAX...), might also return F valuecolumn
- - representation of table column or class field
// * @param operator - logical relationval
- - valuedefault <E extends Entity,F,R extends EntityRelation> Q havingNotIn(Column<E,F,R> column, Collection<F> val)
default <E extends Entity,F,R extends EntityRelation> Q havingIn(Column<E,F,R> column, R... val)
default <E extends Entity,F,R extends EntityRelation> Q havingNotIn(Column<E,F,R> column, R... val)
default <F> Q havingEqual(Column<?,F,?> column, Column<?,F,?> column2)
F
- value typecolumn
- - representation of table column or class fieldcolumn2
- - representation of table column or class fielddefault <F> Q havingGreaterOrEqual(Column<?,F,?> column, Column<?,F,?> column2)
default <F extends Number> Q havingEqual(ColumnFunction<?,F,?,F> column, ColumnFunction<?,F,?,F> column2)
F
- value typecolumn
- - representation of table column or class fieldcolumn2
- - representation of table column or class fielddefault <F extends Number> Q havingBetween(ColumnFunction<?,F,?,F> column, F valueFrom, F valueTo)
default <F extends Number,R extends EntityRelation> Q havingBetween(ColumnFunction<?,F,R,F> column, R valueFrom, R valueTo)
default <F extends Number,R extends EntityRelation> Q havingEqual(String column, Object val)
default <F extends Number,R extends EntityRelation> Q havingGreater(String column, Object val)
default <F extends Number,R extends EntityRelation> Q havingGreaterOrEqual(String column, Object val)
default <F extends Number,R extends EntityRelation> Q havingLess(String column, Object val)
default <F extends Number,R extends EntityRelation> Q havingLessOrEqual(String column, Object val)
default <F extends Number,R extends EntityRelation> Q havingNotEqual(String column, Object val)
Copyright © 2021. All rights reserved.