- All Superinterfaces:
Field<T>
,FieldOrConstraint
,FieldOrRow
,FieldOrRowOrSelect
,GroupField
,Named
,OrderField<T>
,QueryPart
,SelectField<T>
,SelectFieldOrAsterisk
,Serializable
,TableElement
,Typed<T>
,WindowBeforeOverStep<T>
,WindowOverStep<T>
- All Known Subinterfaces:
AggregateFunction<T>
,ArrayAggOrderByStep<T>
,GroupConcatOrderByStep
,GroupConcatSeparatorStep
,JSONArrayAggNullStep<T>
,JSONArrayAggOrderByStep<J>
,JSONArrayAggReturningStep<T>
,JSONObjectAggNullStep<T>
,JSONObjectAggReturningStep<T>
,OptionallyOrderedAggregateFunction<T>
,QOM.AnyValue<T>
,QOM.ArrayAgg<T>
,QOM.Avg
,QOM.BitAndAgg<T>
,QOM.BitNandAgg<T>
,QOM.BitNorAgg<T>
,QOM.BitOrAgg<T>
,QOM.BitXNorAgg<T>
,QOM.BitXorAgg<T>
,QOM.BoolAnd
,QOM.BoolOr
,QOM.Collect<T,
,A> QOM.Corr
,QOM.Count
,QOM.CountTable
,QOM.CovarPop
,QOM.CovarSamp
,QOM.JSONArrayAgg<J>
,QOM.JSONObjectAgg<J>
,QOM.Max<T>
,QOM.MaxBy<T>
,QOM.Median
,QOM.Min<T>
,QOM.MinBy<T>
,QOM.Mode<T>
,QOM.MultisetAgg<R>
,QOM.Product
,QOM.RatioToReport
,QOM.RegrAvgX
,QOM.RegrAvgY
,QOM.RegrCount
,QOM.RegrIntercept
,QOM.RegrR2
,QOM.RegrSlope
,QOM.RegrSxx
,QOM.RegrSxy
,QOM.RegrSyy
,QOM.StddevPop
,QOM.StddevSamp
,QOM.Sum
,QOM.VarPop
,QOM.VarSamp
,QOM.XMLAgg
,XMLAggOrderByStep<T>
FILTER clause
can be added.
Referencing XYZ*Step
types directly from client code
It is usually not recommended to reference any XYZ*Step
types
directly from client code, or assign them to local variables. When writing
dynamic SQL, creating a statement's components dynamically, and passing them
to the DSL API statically is usually a better choice. See the manual's
section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.
Drawbacks of referencing the XYZ*Step
types directly:
- They're operating on mutable implementations (as of jOOQ 3.x)
- They're less composable and not easy to get right when dynamic SQL gets complex
- They're less readable
- They might have binary incompatible changes between minor releases
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescription@NotNull WindowBeforeOverStep
<T> filterWhere
(String sql) Add aFILTER clause
to the aggregate function.@NotNull WindowBeforeOverStep
<T> filterWhere
(String sql, Object... bindings) Add aFILTER clause
to the aggregate function.@NotNull WindowBeforeOverStep
<T> filterWhere
(String sql, QueryPart... parts) Add aFILTER clause
to the aggregate function.@NotNull WindowBeforeOverStep
<T> filterWhere
(Collection<? extends Condition> conditions) Add aFILTER clause
to the aggregate function, connecting conditions with each other withOperator.AND
.@NotNull WindowBeforeOverStep
<T> filterWhere
(Condition condition) Add aFILTER clause
to the aggregate function, connecting conditions with each other withOperator.AND
.@NotNull WindowBeforeOverStep
<T> filterWhere
(Condition... conditions) Add aFILTER clause
to the aggregate function, connecting conditions with each other withOperator.AND
.@NotNull WindowBeforeOverStep
<T> filterWhere
(Field<Boolean> field) Add aFILTER clause
to the aggregate function.@NotNull WindowBeforeOverStep
<T> filterWhere
(SQL sql) Add aFILTER clause
to the aggregate function.Methods inherited from interface org.jooq.Field
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, collate, collate, collate, comment, comment, compare, compare, compare, compare, concat, concat, concat, contains, contains, containsIgnoreCase, containsIgnoreCase, convert, convert, convert, convertFrom, convertFrom, convertTo, convertTo, cos, cosh, cot, coth, count, countDistinct, countOver, decode, decode, decode, decode, deg, desc, div, div, divide, divide, endsWith, endsWith, endsWithIgnoreCase, endsWithIgnoreCase, eq, eq, eq, eq, equal, equal, equal, equal, equalIgnoreCase, equalIgnoreCase, equals, exp, extract, field, firstValue, floor, from, ge, ge, ge, ge, get, getComment, getName, getValue, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterThan, greaterThan, greaterThan, greaterThan, greatest, greatest, gt, gt, gt, gt, in, in, in, in, in, isDistinctFrom, isDistinctFrom, isDistinctFrom, isDocument, isFalse, isJson, isNotDistinctFrom, isNotDistinctFrom, isNotDistinctFrom, isNotDocument, isNotJson, 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, 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, notLike, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeRegex, notLikeRegex, notSimilarTo, notSimilarTo, notSimilarTo, notSimilarTo, notSimilarTo, nullif, nullif, nullsFirst, nullsLast, 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, similarTo, similarTo, similarTo, similarTo, similarTo, sin, sinh, sort, sort, sortAsc, sortAsc, sortDefault, sortDesc, sortDesc, sqrt, startsWith, startsWith, startsWithIgnoreCase, startsWithIgnoreCase, stddevPop, stddevPopOver, stddevSamp, stddevSampOver, sub, sub, substring, substring, substring, substring, subtract, subtract, sum, sumOver, tan, tanh, times, times, touched, trim, unaryMinus, unaryPlus, upper, varPop, varPopOver, varSamp, varSampOver
Methods inherited from interface org.jooq.Named
$name, getCommentPart, getQualifiedName, getUnqualifiedName
Methods inherited from interface org.jooq.QueryPart
$replace, $replace, $traverse, $traverse, hashCode, toString
Methods inherited from interface org.jooq.Typed
$dataType, getBinding, getConverter, getDataType, getDataType, getType
-
Method Details
-
filterWhere
Add aFILTER clause
to the aggregate function, connecting conditions with each other withOperator.AND
. -
filterWhere
Add aFILTER clause
to the aggregate function, connecting conditions with each other withOperator.AND
. -
filterWhere
@NotNull @Support @NotNull WindowBeforeOverStep<T> filterWhere(Collection<? extends Condition> conditions) Add aFILTER clause
to the aggregate function, connecting conditions with each other withOperator.AND
. -
filterWhere
Add aFILTER clause
to the aggregate function. -
filterWhere
Add aFILTER 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!
- See Also:
-
filterWhere
Add aFILTER 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!
- See Also:
-
filterWhere
@NotNull @Support @PlainSQL @NotNull WindowBeforeOverStep<T> filterWhere(String sql, Object... bindings) Add aFILTER 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!
- See Also:
-
filterWhere
@NotNull @Support @PlainSQL @NotNull WindowBeforeOverStep<T> filterWhere(String sql, QueryPart... parts) Add aFILTER 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!
- See Also:
-