Uses of Interface
org.jooq.GroupField
Packages that use GroupField
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of GroupField in org.jooq
Subinterfaces of GroupField in org.jooqModifier and TypeInterfaceDescriptioninterfaceThe step in the specification of aggregate functions where the SQL:2003 standardFILTER clausecan be added.interfaceAn aggregate function.interfaceThe SQL standardARRAY_AGG()function.interfaceThe final step in creating a case statement of the typeinterfaceCaseWhenStep<V,T>The final step in creating a case statement of the typeinterfaceField<T>A column expression.interfaceMySQL'sGROUP_CONCATfunction.interfaceMySQL'sGROUP_CONCATfunction.interfaceA step in the construction ofDSL.jsonArrayAgg(Field)orDSL.jsonbArrayAgg(Field)functions where theNULLclause can be defined.interfaceA step in the construction ofDSL.jsonArrayAgg(Field)orDSL.jsonbArrayAgg(Field)functions where theORDER BYclause can be defined.interfaceA step in the construction ofDSL.jsonArrayAgg(Field)orDSL.jsonbArrayAgg(Field)functions where theRETURNINGclause can be defined.interfaceA step in the construction of theJSON ARRAYfunction.interfaceA step in the construction of theJSON ARRAYfunction.interfaceA step in the construction ofDSL.jsonObjectAgg(JSONEntry)orDSL.jsonbObjectAgg(JSONEntry)functions where theNULLclause can be defined.interfaceA step in the construction ofDSL.jsonObjectAgg(JSONEntry)orDSL.jsonbObjectAgg(JSONEntry)functions where theRETURNINGclause can be defined.interfaceA step in the construction of theJSON OBJECTfunction.interfaceA step in the construction of theJSON OBJECTfunction.interfaceA step in the construction ofDSL.jsonValue(Field, Field)orDSL.jsonbValue(Field, Field)functions where theON EMPTYandON ERRORclauses can be defined.interfaceA step in the construction of theJSON VALUEfunction.interfaceParam<T>A named parameter and/or bind value.interfaceParameter<T>A parameter to a stored procedure or function.interfaceinterfaceTableField<R extends Record,T>A field contained in a table.interfaceA field contained in a UDT.interfaceVariable<T>A local variable reference.interfaceThis type is used for the window function DSL API.interfaceThis type is used for the window function DSL API.interfaceDeprecated, 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.interfaceThis type is used for the window function DSL API.interfaceThis type is used for the window function DSL API.interfaceThis type is used for the window function DSL API.interfaceThe SQL standardARRAY_AGG()function.Methods in org.jooq with parameters of type GroupFieldModifier and TypeMethodDescriptionvoidSelectQuery.addGroupBy(GroupField... fields)Adds grouping fields.@NotNull SelectHavingStep<R>SelectGroupByStep.groupBy(GroupField... fields)Add aGROUP BYclause to the queryMethod parameters in org.jooq with type arguments of type GroupFieldModifier and TypeMethodDescriptionvoidSelectQuery.addGroupBy(Collection<? extends GroupField> fields)Adds grouping fields.@NotNull SelectHavingStep<R>SelectGroupByStep.groupBy(Collection<? extends GroupField> fields)Add aGROUP BYclause to the query -
Uses of GroupField in org.jooq.impl
Classes in org.jooq.impl that implement GroupFieldModifier and TypeClassDescriptionclassCustomField<T>A base class for customFieldimplementations in client code.Methods in org.jooq.impl that return GroupFieldModifier and TypeMethodDescriptionstatic @NotNull GroupFieldCreate a CUBE(field1, field2, .., fieldn) grouping field.static @NotNull GroupFieldDSL.cube(FieldOrRow... fields)Create a CUBE(field1, field2, .., fieldn) grouping field.static @NotNull GroupFieldDSL.groupingSets(Collection<? extends Field<?>>... fieldSets)Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna, fieldnb)) grouping field.static @NotNull GroupFieldDSL.groupingSets(Field<?>... fields)Create a GROUPING SETS(field1, field2, .., fieldn) grouping field where each grouping set only consists of a single field.static @NotNull GroupFieldDSL.groupingSets(Field<?>[]... fieldSets)Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna, fieldnb)) grouping field.static @NotNull GroupFieldCreate a ROLLUP(field1, field2, .., fieldn) grouping field.static @NotNull GroupFieldDSL.rollup(FieldOrRow... fields)Create a ROLLUP(field1, field2, .., fieldn) grouping field.