Uses of Interface
org.jooq.GroupField

Packages that use GroupField

Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.impl	This package contains jOOQ's implementation classes.

Uses of GroupField in org.jooq

Subinterfaces of GroupField in org.jooq

Modifier and Type	Interface	Description
interface	AggregateFilterStep<T>	The step in the specification of aggregate functions where the SQL:2003 standard FILTER clause can be added.
interface	AggregateFunction<T>	An aggregate function.
interface	ArrayAggOrderByStep<T>	The SQL standard ARRAY_AGG() function.
interface	CaseConditionStep<T>	The final step in creating a case statement of the type
interface	CaseWhenStep<V,T>	The final step in creating a case statement of the type
interface	CommonTableExpression<R extends Record>	A common table expression.
interface	Field<T>	A column expression.
interface	GroupConcatOrderByStep	MySQL's GROUP_CONCAT function.
interface	GroupConcatSeparatorStep	MySQL's GROUP_CONCAT function.
interface	JSONArrayAggNullStep<T>	A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the NULL clause can be defined.
interface	JSONArrayAggOrderByStep<J>	A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the ORDER BY clause can be defined.
interface	JSONArrayAggReturningStep<T>	A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the RETURNING clause can be defined.
interface	JSONArrayNullStep<T>	A step in the construction of the JSON ARRAY function.
interface	JSONArrayReturningStep<T>	A step in the construction of the JSON ARRAY function.
interface	JSONObjectAggNullStep<T>	A step in the construction of DSL.jsonObjectAgg(JSONEntry) or DSL.jsonbObjectAgg(JSONEntry) functions where the NULL clause can be defined.
interface	JSONObjectAggReturningStep<T>	A step in the construction of DSL.jsonObjectAgg(JSONEntry) or DSL.jsonbObjectAgg(JSONEntry) functions where the RETURNING clause can be defined.
interface	JSONObjectNullStep<T>	A step in the construction of the JSON OBJECT function.
interface	JSONObjectReturningStep<T>	A step in the construction of the JSON OBJECT function.
interface	JSONTableColumnPathStep	A step in the construction of an JSON_TABLE expression.
interface	JSONTableColumnsStep	A step in the construction of an JSON_TABLE expression.
interface	JSONValueOnStep<J>	A step in the construction of DSL.jsonValue(Field, Field) or DSL.jsonbValue(Field, Field) functions where the ON EMPTY and ON ERROR clauses can be defined.
interface	JSONValueReturningStep<T>	A step in the construction of the JSON VALUE function.
interface	Param<T>	A named parameter and/or bind value.
interface	Parameter<T>	A parameter to a stored procedure or function.
interface	ParamOrVariable<T>	A common super type of Param and Variable.
interface	Table<R extends Record>	A table.
interface	TableField<R extends Record,T>	A field contained in a table.
interface	TableOnConditionStep<R extends Record>	An intermediate (optional) type for the construction of a JOIN clause, where the join criteria is added using an ON clause (with a Condition.
interface	TableOptionalOnStep<R extends Record>	An intermediate type for the construction of a JOIN clause, where there may optionally be a join criteria added using an ON clause (with a Condition), or using a USING clause (with a list of Field)
interface	UDTField<R extends UDTRecord<R>,T>	A field contained in a UDT.
interface	Variable<T>	A local variable reference.
interface	WindowBeforeOverStep<T>	This type is used for the window function DSL API.
interface	WindowExcludeStep<T>	This type is used for the window function DSL API.
interface	WindowFinalStep<T>	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	WindowOrderByStep<T>	This type is used for the window function DSL API.
interface	WindowPartitionByStep<T>	This type is used for the window function DSL API.
interface	WindowRowsStep<T>	This type is used for the window function DSL API.
interface	XMLAggOrderByStep<T>	The SQL standard ARRAY_AGG() function.
interface	XMLTableColumnPathStep	A step in the construction of an XMLTABLE expression.
interface	XMLTableColumnsStep	A step in the construction of an XMLTABLE expression.

Methods in org.jooq that return types with arguments of type GroupField

Modifier and Type	Method	Description
@NotNull QOM.UnmodifiableList<? extends GroupField>	Select.$groupBy()	Experimental query object model accessor method, see also QOM.

Methods in org.jooq with parameters of type GroupField

Modifier and Type	Method	Description
void	SelectQuery.addGroupBy(GroupField... fields)	Adds grouping fields.
@NotNull SelectHavingStep<R>	SelectGroupByStep.groupBy(GroupField... fields)	Add a GROUP BY clause to the query
@NotNull SelectHavingStep<R>	SelectGroupByStep.groupByDistinct(GroupField... fields)	Add a GROUP BY DISTINCT clause to the query

Method parameters in org.jooq with type arguments of type GroupField

Modifier and Type	Method	Description
void	SelectQuery.addGroupBy(Collection<? extends GroupField> fields)	Adds grouping fields.
@NotNull SelectHavingStep<R>	SelectGroupByStep.groupBy(Collection<? extends GroupField> fields)	Add a GROUP BY clause to the query
@NotNull SelectHavingStep<R>	SelectGroupByStep.groupByDistinct(Collection<? extends GroupField> fields)	Add a GROUP BY DISTINCT clause to the query

Uses of GroupField in org.jooq.impl

Subinterfaces of GroupField in org.jooq.impl

Modifier and Type	Interface	Description
static interface	QOM.Abs<T extends Number>	The ABS function.
static interface	QOM.Acos	The ACOS function.
static interface	QOM.Add<T>	The ADD operator.
static interface	QOM.AnyValue<T>	The ANY VALUE function.
static interface	QOM.Array<T>
static interface	QOM.ArrayAgg<T>
static interface	QOM.ArrayGet<T>	The ARRAY GET function.
static interface	QOM.ArrayQuery<T>
static interface	QOM.Ascii	The ASCII function.
static interface	QOM.Asin	The ASIN function.
static interface	QOM.Atan	The ATAN function.
static interface	QOM.Atan2	The ATAN2 function.
static interface	QOM.Avg	The AVG function.
static interface	QOM.BitAnd<T extends Number>	The BIT AND operator.
static interface	QOM.BitAndAgg<T extends Number>	The BIT AND AGG function.
static interface	QOM.BitCount	The BIT COUNT function.
static interface	QOM.BitLength	The BIT LENGTH function.
static interface	QOM.BitNand<T extends Number>	The BIT NAND operator.
static interface	QOM.BitNor<T extends Number>	The BIT NOR operator.
static interface	QOM.BitNot<T extends Number>	The BIT NOT operator.
static interface	QOM.BitOr<T extends Number>	The BIT OR operator.
static interface	QOM.BitOrAgg<T extends Number>	The BIT OR AGG function.
static interface	QOM.BitXNor<T extends Number>	The BIT X NOR operator.
static interface	QOM.BitXor<T extends Number>	The BIT XOR operator.
static interface	QOM.BitXorAgg<T extends Number>	The BIT XOR AGG function.
static interface	QOM.BoolAnd	The BOOL AND function.
static interface	QOM.BoolOr	The BOOL OR function.
static interface	QOM.Cardinality	The CARDINALITY function.
static interface	QOM.Cast<T>
static interface	QOM.Ceil<T extends Number>	The CEIL function.
static interface	QOM.CharLength	The CHAR LENGTH function.
static interface	QOM.Choose<T>
static interface	QOM.Chr	The CHR function.
static interface	QOM.Coalesce<T>
static interface	QOM.Coerce<T>
static interface	QOM.Collated
static interface	QOM.Collect<T,A extends ArrayRecord<T>>
static interface	QOM.Concat
static interface	QOM.ConditionAsField	The FIELD function.
static interface	QOM.ConnectByIsCycle	The CONNECT BY ISCYCLE function.
static interface	QOM.ConnectByIsLeaf	The CONNECT BY ISLEAF function.
static interface	QOM.ConnectByRoot<T>	The CONNECT BY ROOT function.
static interface	QOM.Convert<T>
static interface	QOM.Corr	The CORR function.
static interface	QOM.Cos	The COS function.
static interface	QOM.Cosh	The COSH function.
static interface	QOM.Cot	The COT function.
static interface	QOM.Coth	The COTH function.
static interface	QOM.Count	The COUNT function.
static interface	QOM.CountTable
static interface	QOM.CovarPop	The COVAR POP function.
static interface	QOM.CovarSamp	The COVAR SAMP function.
static interface	QOM.Cube
static interface	QOM.CumeDist
static interface	QOM.CurrentCatalog	The CURRENT CATALOG function.
static interface	QOM.CurrentDate<T>
static interface	QOM.CurrentSchema	The CURRENT SCHEMA function.
static interface	QOM.CurrentTime<T>
static interface	QOM.CurrentTimestamp<T>
static interface	QOM.CurrentUser	The CURRENT USER function.
static interface	QOM.DataChangeDeltaTable<R extends Record>
static interface	QOM.DateAdd<T>	The DATE ADD function.
static interface	QOM.Default<T>
static interface	QOM.Degrees	The DEGREES function.
static interface	QOM.DenseRank
static interface	QOM.DerivedTable<R extends Record>
static interface	QOM.Digits	The DIGITS function.
static interface	QOM.Div<T>	The DIV operator.
static interface	QOM.Dual
static interface	QOM.Euler	The E function.
static interface	QOM.Exp	The EXP function.
static interface	QOM.Extract
static interface	QOM.FieldAlias<T>
static interface	QOM.FieldFunction<T>
static interface	QOM.FirstValue<T>
static interface	QOM.Floor<T extends Number>	The FLOOR function.
static interface	QOM.Function<T>
static interface	QOM.GenerateSeries<T>
static interface	QOM.Greatest<T>
static interface	QOM.GroupingSets
static interface	QOM.Iif<T>
static interface	QOM.Inline<T>
static interface	QOM.JSONArray<T>	The JSON ARRAY function.
static interface	QOM.JSONArrayAgg<J>
static interface	QOM.JSONObject<T>	The JSON OBJECT function.
static interface	QOM.JSONObjectAgg<J>
static interface	QOM.Lag<T>
static interface	QOM.LastValue<T>
static interface	QOM.Lateral<R extends Record>
static interface	QOM.Lead<T>
static interface	QOM.Least<T>
static interface	QOM.Left	The LEFT function.
static interface	QOM.Level	The LEVEL function.
static interface	QOM.LinkedTable<R extends Record>
static interface	QOM.Log	The LN function.
static interface	QOM.Log10	The LOG10 function.
static interface	QOM.Lower	The LOWER function.
static interface	QOM.Lpad	The LPAD function.
static interface	QOM.Ltrim	The LTRIM function.
static interface	QOM.Max<T>	The MAX function.
static interface	QOM.Md5	The MD5 function.
static interface	QOM.Median	The MEDIAN function.
static interface	QOM.Min<T>	The MIN function.
static interface	QOM.Mod<T extends Number>	The MOD operator.
static interface	QOM.Mode<T>
static interface	QOM.Mul<T>	The MUL operator.
static interface	QOM.Multiset<R extends Record>
static interface	QOM.MultisetAgg<R extends Record>
static interface	QOM.Neg<T>
static interface	QOM.NotField	The NOT operator.
static interface	QOM.NthValue<T>
static interface	QOM.Ntile
static interface	QOM.Nullif<T>	The NULLIF function.
static interface	QOM.Nvl<T>	The NVL function.
static interface	QOM.Nvl2<T>
static interface	QOM.OctetLength	The OCTET LENGTH function.
static interface	QOM.Overlay	The OVERLAY function.
static interface	QOM.PercentRank
static interface	QOM.Pi	The PI function.
static interface	QOM.PlusJoin<T>	The PLUS operator.
static interface	QOM.Position	The POSITION function.
static interface	QOM.Power	The POWER operator.
static interface	QOM.Prior<T>	The PRIOR function.
static interface	QOM.Product	The PRODUCT function.
static interface	QOM.QualifiedRowid	The ROWID operator.
static interface	QOM.Radians	The RADIANS function.
static interface	QOM.Rand	The RAND function.
static interface	QOM.Rank
static interface	QOM.RatioToReport
static interface	QOM.RegrAvgX	The REGR AVGX function.
static interface	QOM.RegrAvgY	The REGR AVGY function.
static interface	QOM.RegrCount	The REGR COUNT function.
static interface	QOM.RegrIntercept	The REGR INTERCEPT function.
static interface	QOM.RegrR2	The REGR R2 function.
static interface	QOM.RegrSlope	The REGR SLOPE function.
static interface	QOM.RegrSxx	The REGR SXX function.
static interface	QOM.RegrSxy	The REGR SXY function.
static interface	QOM.RegrSyy	The REGR SYY function.
static interface	QOM.Repeat	The REPEAT function.
static interface	QOM.Replace	The REPLACE function.
static interface	QOM.Reverse	The REVERSE function.
static interface	QOM.Right	The RIGHT function.
static interface	QOM.Rollup
static interface	QOM.Round<T extends Number>	The ROUND function.
static interface	QOM.RowField<R extends Record>
static interface	QOM.Rownum	The ROWNUM function.
static interface	QOM.RowNumber
static interface	QOM.RowsFrom
static interface	QOM.Rpad	The RPAD function.
static interface	QOM.Rtrim	The RTRIM function.
static interface	QOM.ScalarSubquery<T>
static interface	QOM.Shl<T extends Number>	The SHL operator.
static interface	QOM.Shr<T extends Number>	The SHR operator.
static interface	QOM.Sign	The SIGN function.
static interface	QOM.Sin	The SIN function.
static interface	QOM.Sinh	The SINH function.
static interface	QOM.Space	The SPACE function.
static interface	QOM.SplitPart	The SPLIT PART function.
static interface	QOM.Sqrt	The SQRT function.
static interface	QOM.Square<T extends Number>	The SQUARE function.
static interface	QOM.StArea	The ST AREA function.
static interface	QOM.StAsBinary	The ST ASBINARY function.
static interface	QOM.StAsText	The ST ASTEXT function.
static interface	QOM.StCentroid	The ST CENTROID function.
static interface	QOM.StddevPop	The STDDEV POP function.
static interface	QOM.StddevSamp	The STDDEV SAMP function.
static interface	QOM.StDifference<T extends Spatial>	The ST DIFFERENCE function.
static interface	QOM.StDistance<T extends Spatial>	The ST DISTANCE function.
static interface	QOM.StEndPoint<T extends Spatial>	The ST ENDPOINT function.
static interface	QOM.StExteriorRing	The ST EXTERIORRING function.
static interface	QOM.StGeometryN<T extends Spatial>	The ST GEOMETRYN function.
static interface	QOM.StGeometryType	The ST GEOMETRYTYPE function.
static interface	QOM.StGeomFromText	The ST GEOMFROMTEXT function.
static interface	QOM.StGeomFromWKB	The ST GEOMFROMWKB function.
static interface	QOM.StInteriorRingN	The ST INTERIORRINGN function.
static interface	QOM.StIntersection<T extends Spatial>	The ST INTERSECTION function.
static interface	QOM.StLength	The ST LENGTH function.
static interface	QOM.StNumGeometries	The ST NUMGEOMETRIES function.
static interface	QOM.StNumInteriorRings	The ST NUMINTERIORRING function.
static interface	QOM.StNumPoints	The ST NUMPOINTS function.
static interface	QOM.StPointN<T extends Spatial>	The ST POINTN function.
static interface	QOM.StSrid	The ST SRID function.
static interface	QOM.StStartPoint<T extends Spatial>	The ST STARTPOINT function.
static interface	QOM.StUnion<T extends Spatial>	The ST UNION function.
static interface	QOM.StX	The ST X function.
static interface	QOM.StY	The ST Y function.
static interface	QOM.StZ	The ST Z function.
static interface	QOM.Sub<T>	The SUB operator.
static interface	QOM.Substring	The SUBSTRING function.
static interface	QOM.SubstringIndex	The SUBSTRING INDEX function.
static interface	QOM.Sum	The SUM function.
static interface	QOM.SysConnectByPath	The SYS CONNECT BY PATH function.
static interface	QOM.TableAlias<R extends Record>
static interface	QOM.Tan	The TAN function.
static interface	QOM.Tanh	The TANH function.
static interface	QOM.Tau	The TAU function.
static interface	QOM.TimestampDiff<T>
static interface	QOM.ToChar	The TO CHAR function.
static interface	QOM.ToDate	The TO DATE function.
static interface	QOM.ToHex	The TO HEX function.
static interface	QOM.ToTimestamp	The TO TIMESTAMP function.
static interface	QOM.Translate	The TRANSLATE function.
static interface	QOM.Trim	The TRIM function.
static interface	QOM.Trunc<T extends Number>	The TRUNC function.
static interface	QOM.Upper	The UPPER function.
static interface	QOM.Uuid	The UUID function.
static interface	QOM.Val<T>
static interface	QOM.Values<R extends Record>
static interface	QOM.VarPop	The VAR POP function.
static interface	QOM.VarSamp	The VAR SAMP function.
static interface	QOM.WidthBucket<T extends Number>	The WIDTH BUCKET function.
static interface	QOM.WindowFunction<T>
static interface	QOM.XMLAgg
static interface	QOM.XMLComment	The XMLCOMMENT function.
static interface	QOM.XMLConcat	The XMLCONCAT function.
static interface	QOM.XMLDocument	The XMLDOCUMENT function.
static interface	QOM.XMLElement
static interface	QOM.XMLForest	The XMLFOREST function.
static interface	QOM.XMLParse
static interface	QOM.XMLPi	The XMLPI function.
static interface	QOM.XMLQuery
static interface	QOM.XMLSerialize<T>	The XMLSERIALIZE function.

Classes in org.jooq.impl that implement GroupField

Modifier and Type	Class	Description
class	CustomField<T>	A base class for custom Field implementations in client code.
class	CustomTable<R extends TableRecord<R>>	A base class for custom Table implementations in client code.
class	TableImpl<R extends Record>	A common base type for tables

Methods in org.jooq.impl that return GroupField

Modifier and Type	Method	Description
static @NotNull GroupField	DSL.cube(Field<?>... fields)	Create a CUBE(field1, field2, .., fieldn) grouping field.
static @NotNull GroupField	DSL.cube(FieldOrRow... fields)	Create a CUBE(field1, field2, .., fieldn) grouping field.
static @NotNull GroupField	DSL.groupingSets(Collection<? extends Field<?>>... fieldSets)	Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna, fieldnb)) grouping field.
static @NotNull GroupField	DSL.groupingSets(Field<?>... fields)	Create a GROUPING SETS(field1, field2, .., fieldn) grouping field where each grouping set only consists of a single field.
static @NotNull GroupField	DSL.groupingSets(Field<?>[]... fieldSets)	Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna, fieldnb)) grouping field.
static @NotNull GroupField	DSL.rollup(Field<?>... fields)	Create a ROLLUP(field1, field2, .., fieldn) grouping field.
static @NotNull GroupField	DSL.rollup(FieldOrRow... fields)	Create a ROLLUP(field1, field2, .., fieldn) grouping field.