public interface AggregateFilterStep<T> extends WindowBeforeOverStep<T>
FILTER clause
can be added.Modifier and Type | Method and Description |
---|---|
WindowBeforeOverStep<T> |
filterWhere(java.lang.Boolean field)
Deprecated.
- 3.8.0 - [#4763] - Use
filterWhere(Condition...) or
filterWhere(Field) instead. Due to ambiguity between
calling this method using Field.equals(Object)
argument, vs. calling the other method via a
Field.equal(Object) argument, this method will be
removed in the future. |
WindowBeforeOverStep<T> |
filterWhere(java.util.Collection<? extends Condition> conditions)
Add a
FILTER clause to the aggregate function, connecting
conditions with each other with Operator.AND . |
WindowBeforeOverStep<T> |
filterWhere(Condition... conditions)
Add a
FILTER clause to the aggregate function, connecting
conditions with each other with Operator.AND . |
WindowBeforeOverStep<T> |
filterWhere(Field<java.lang.Boolean> field)
Add a
FILTER clause to the aggregate function. |
WindowBeforeOverStep<T> |
filterWhere(SQL sql)
Add a
FILTER clause to the aggregate function. |
WindowBeforeOverStep<T> |
filterWhere(java.lang.String sql)
Add a
FILTER clause to the aggregate function. |
WindowBeforeOverStep<T> |
filterWhere(java.lang.String sql,
java.lang.Object... bindings)
Add a
FILTER clause to the aggregate function. |
WindowBeforeOverStep<T> |
filterWhere(java.lang.String sql,
QueryPart... parts)
Add a
FILTER clause to the aggregate function. |
abs, acos, add, add, as, as, as, as, asc, ascii, asin, atan, atan2, atan2, avg, avgOver, between, between, between, between, betweenSymmetric, betweenSymmetric, betweenSymmetric, betweenSymmetric, bitAnd, bitAnd, bitLength, bitNand, bitNand, bitNor, bitNor, bitNot, bitOr, bitOr, bitXNor, bitXNor, bitXor, bitXor, cast, cast, cast, ceil, changed, charLength, coalesce, coalesce, coerce, coerce, coerce, compare, compare, compare, compare, concat, concat, contains, contains, containsIgnoreCase, containsIgnoreCase, cos, cosh, cot, coth, count, countDistinct, countOver, decode, decode, decode, decode, deg, desc, div, div, divide, divide, endsWith, endsWith, eq, eq, eq, eq, equal, equal, equal, equal, equalIgnoreCase, equalIgnoreCase, equals, exp, extract, field, firstValue, floor, from, ge, ge, ge, ge, get, getBinding, getComment, getConverter, getDataType, getDataType, getName, getQualifiedName, getType, getUnqualifiedName, getValue, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterThan, greaterThan, greaterThan, greaterThan, greatest, greatest, gt, gt, gt, gt, in, in, in, in, in, isDistinctFrom, isDistinctFrom, isFalse, isNotDistinctFrom, isNotDistinctFrom, isNotNull, isNull, isTrue, lag, lag, lag, lag, lastValue, le, le, le, le, lead, lead, lead, lead, least, least, length, lessOrEqual, lessOrEqual, lessOrEqual, lessOrEqual, lessThan, lessThan, lessThan, lessThan, like, like, like, like, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeRegex, likeRegex, ln, log, lower, lpad, lpad, lpad, lpad, lt, lt, lt, lt, ltrim, max, maxOver, median, min, minOver, minus, minus, mod, mod, modulo, modulo, mul, mul, multiply, multiply, ne, ne, ne, ne, neg, notBetween, notBetween, notBetween, notBetween, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notContains, notContains, notContainsIgnoreCase, notContainsIgnoreCase, notEqual, notEqual, notEqual, notEqual, notEqualIgnoreCase, notEqualIgnoreCase, notIn, notIn, notIn, notIn, notIn, notLike, notLike, notLike, notLike, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeRegex, notLikeRegex, nullif, nullif, nvl, nvl, nvl2, nvl2, octetLength, original, plus, plus, plus, position, position, pow, pow, power, power, rad, rem, rem, repeat, repeat, replace, replace, replace, replace, reset, round, round, rpad, rpad, rpad, rpad, rtrim, shl, shl, shr, shr, sign, sin, sinh, sort, sort, sortAsc, sortAsc, sortDefault, sortDesc, sortDesc, sqrt, startsWith, startsWith, stddevPop, stddevPopOver, stddevSamp, stddevSampOver, sub, sub, substring, substring, substring, substring, subtract, subtract, sum, sumOver, tan, tanh, times, times, trim, unaryMinus, unaryPlus, upper, varPop, varPopOver, varSamp, varSampOver
@Support WindowBeforeOverStep<T> filterWhere(Condition... conditions)
FILTER clause
to the aggregate function, connecting
conditions with each other with Operator.AND
.@Support WindowBeforeOverStep<T> filterWhere(java.util.Collection<? extends Condition> conditions)
FILTER clause
to the aggregate function, connecting
conditions with each other with Operator.AND
.@Support WindowBeforeOverStep<T> filterWhere(Field<java.lang.Boolean> field)
FILTER clause
to the aggregate function.@Deprecated @Support WindowBeforeOverStep<T> filterWhere(java.lang.Boolean field)
filterWhere(Condition...)
or
filterWhere(Field)
instead. Due to ambiguity between
calling this method using Field.equals(Object)
argument, vs. calling the other method via a
Field.equal(Object)
argument, this method will be
removed in the future.FILTER clause
to the aggregate function.@Support @PlainSQL WindowBeforeOverStep<T> filterWhere(SQL sql)
FILTER clause
to the aggregate function.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
DSL.condition(SQL)
,
SQL
@Support @PlainSQL WindowBeforeOverStep<T> filterWhere(java.lang.String sql)
FILTER clause
to the aggregate function.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
DSL.condition(String)
,
SQL
@Support @PlainSQL WindowBeforeOverStep<T> filterWhere(java.lang.String sql, java.lang.Object... bindings)
FILTER clause
to the aggregate function.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
@Support @PlainSQL WindowBeforeOverStep<T> filterWhere(java.lang.String sql, QueryPart... parts)
FILTER clause
to the aggregate function.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Copyright © 2018. All Rights Reserved.