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 typeinterfaceCommonTableExpression<R extends Record>A common table expression.interfaceA condition or predicate.interfaceAConditionthat always yieldsfalse.interfaceField<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.jsonExists(Field, Field)orDSL.jsonbExists(Field, Field)functions where theON ERRORclause can be defined.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 of anJSON_TABLEexpression.interfaceA step in the construction of anJSON_TABLEexpression.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.interfaceA step in the construction of theLIKEfunction.interfaceAConditionthat always yieldsnull.interfaceParam<T>A named parameter and/or bind value.interfaceParameter<T>A parameter to a stored procedure or function.interfaceinterfaceA table.interfaceTableField<R extends Record,T> A field contained in a table.interfaceTableOnConditionStep<R extends Record>An intermediate (optional) type for the construction of aJOINclause, where the join criteria is added using anONclause (with aCondition.interfaceTableOptionalOnStep<R extends Record>interfaceAConditionthat always yieldstrue.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.interfaceA step in the construction of anXMLTABLEexpression.interfaceA step in the construction of anXMLTABLEexpression.Methods in org.jooq that return types with arguments of type GroupFieldModifier and TypeMethodDescription@NotNull QOM.UnmodifiableList<? extends GroupField>Select.$groupBy()Experimental query object model accessor method, see alsoQOM.@NotNull QOM.UnmodifiableList<? extends GroupField>WindowSpecification.$partitionBy()Experimental query object model accessor method, see alsoQOM.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 query@NotNull SelectHavingStep<R>SelectGroupByStep.groupByDistinct(GroupField... fields) Add aGROUP BY DISTINCTclause to the query@NotNull WindowOrderByStep<T>WindowPartitionByStep.partitionBy(GroupField... fields) Add aPARTITION BYclause to the window functions.@NotNull WindowSpecificationOrderByStepWindowSpecificationPartitionByStep.partitionBy(GroupField... fields) Add aPARTITION BYclause to the window specification.Method parameters in org.jooq with type arguments of type GroupFieldModifier and TypeMethodDescriptionSelect.$groupBy(Collection<? extends GroupField> newGroupBy) Experimental query object model accessor method, see alsoQOM.voidSelectQuery.addGroupBy(Collection<? extends GroupField> fields) Adds grouping fields.@NotNull SelectHavingStep<R>SelectGroupByStep.groupBy(Collection<? extends GroupField> fields) Add aGROUP BYclause to the query@NotNull SelectHavingStep<R>SelectGroupByStep.groupByDistinct(Collection<? extends GroupField> fields) Add aGROUP BY DISTINCTclause to the query@NotNull WindowOrderByStep<T>WindowPartitionByStep.partitionBy(Collection<? extends GroupField> fields) Add aPARTITION BYclause to the window functions.@NotNull WindowSpecificationOrderByStepWindowSpecificationPartitionByStep.partitionBy(Collection<? extends GroupField> fields) Add aPARTITION BYclause to the window specification. -
Uses of GroupField in org.jooq.impl
Subinterfaces of GroupField in org.jooq.implModifier and TypeInterfaceDescriptionstatic interfaceTheABSfunction.static interfaceTheACOSfunction.static interfaceTheACOSHfunction.static interfaceTheACOTHfunction.static interfaceQOM.Add<T>TheADDoperator.static interfaceTheANDoperator.static interfaceQOM.AnyValue<T>TheANY VALUEfunction.static interfaceQOM.Array<T>static interfaceQOM.ArrayAgg<T>static interfaceTheARRAY APPENDfunction.static interfaceTheARRAY CONCATfunction.static interfaceQOM.ArrayGet<T>TheARRAY GETfunction.static interfaceTheARRAY OVERLAPfunction.static interfaceTheARRAY PREPENDfunction.static interfacestatic interfaceTheARRAY REMOVEfunction.static interfaceTheARRAY REPLACEfunction.static interfaceTheASCIIfunction.static interfaceTheASINfunction.static interfaceTheASINHfunction.static interfaceTheATANfunction.static interfaceTheATAN2function.static interfaceTheATANHfunction.static interfaceTheAVGfunction.static interfaceQOM.Between<T>TheBETWEENpredicate.static interfaceQOM.BitAnd<T extends Number>TheBIT ANDoperator.static interfaceQOM.BitAndAgg<T extends Number>TheBIT AND AGGfunction.static interfaceTheBIT COUNTfunction.static interfaceQOM.BitGet<T extends Number>TheBIT GETfunction.static interfaceTheBIT LENGTHfunction.static interfaceQOM.BitNand<T extends Number>TheBIT NANDoperator.static interfaceQOM.BitNandAgg<T extends Number>TheBIT NAND AGGfunction.static interfaceQOM.BitNor<T extends Number>TheBIT NORoperator.static interfaceQOM.BitNorAgg<T extends Number>TheBIT NOR AGGfunction.static interfaceQOM.BitNot<T extends Number>TheBIT NOToperator.static interfaceTheBIT ORoperator.static interfaceQOM.BitOrAgg<T extends Number>TheBIT OR AGGfunction.static interfaceQOM.BitSet<T extends Number>TheBIT SETfunction.static interfaceQOM.BitXNor<T extends Number>TheBIT X NORoperator.static interfaceQOM.BitXNorAgg<T extends Number>TheBIT X NOR AGGfunction.static interfaceQOM.BitXor<T extends Number>TheBIT XORoperator.static interfaceQOM.BitXorAgg<T extends Number>TheBIT XOR AGGfunction.static interfaceTheBOOL ANDfunction.static interfaceTheBOOL ORfunction.static interfaceTheCARDINALITYfunction.static interfacestatic interfaceQOM.CaseSimple<V,T> static interfaceQOM.Cast<T>static interfaceTheCEILfunction.static interfaceTheCHAR LENGTHfunction.static interfaceQOM.Choose<T>static interfaceTheCHRfunction.static interfaceQOM.Coalesce<T>static interfaceQOM.Coerce<T>static interfacestatic interfaceQOM.Collect<T,A extends ArrayRecord<T>> static interfaceQOM.CombinedCondition<R extends QOM.CombinedCondition<R>>static interfaceQOM.CompareCondition<T,R extends QOM.CompareCondition<T, R>> static interfacestatic interfaceTheFIELDfunction.static interfaceTheCONNECT BY ISCYCLEfunction.static interfaceTheCONNECT BY ISLEAFfunction.static interfaceTheCONNECT BY ROOTfunction.static interfaceQOM.Contains<T>TheCONTAINSoperator.static interfaceTheCONTAINS IGNORE CASEoperator.static interfaceQOM.Convert<T>static interfaceTheCORRfunction.static interfaceTheCOSfunction.static interfaceTheCOSHfunction.static interfaceTheCOTfunction.static interfaceTheCOTHfunction.static interfaceTheCOUNTfunction.static interfacestatic interfaceTheCOVAR POPfunction.static interfaceTheCOVAR SAMPfunction.static interfaceQOM.CrossApply<R extends Record>static interfaceQOM.CrossJoin<R extends Record>static interfacestatic interfacestatic interfaceTheCURRENT CATALOGfunction.static interfacestatic interfaceTheCURRENT SCHEMAfunction.static interfacestatic interfacestatic interfaceTheCURRENT USERfunction.static interfaceQOM.DataChangeDeltaTable<R extends Record>static interfaceQOM.DateAdd<T>TheDATE ADDfunction.static interfaceQOM.Decode<V,T> static interfaceQOM.Default<T>static interfaceTheDEGREESfunction.static interfaceTheDELETINGfunction.static interfacestatic interfaceQOM.DerivedTable<R extends Record>static interfaceTheDIGITSfunction.static interfaceQOM.Div<T>TheDIVoperator.static interfacestatic interfacestatic interfaceQOM.EndsWith<T>TheENDS WITHoperator.static interfaceTheENDS WITH IGNORE CASEoperator.static interfaceQOM.Eq<T>TheEQoperator.static interfaceTheEQoperator.static interfaceTheEfunction.static interfaceQOM.Excluded<T>TheEXCLUDEDfunction.static interfaceTheEXISTSfunction.static interfaceTheEXPfunction.static interfacestatic interfaceAConditionthat is alwaysFALSE.static interfacestatic interfaceTheCONDITIONfunction.static interfacestatic interfacestatic interfaceTheFLOORfunction.static interfaceQOM.FullJoin<R extends Record>static interfaceQOM.Function<T>static interfaceQOM.Ge<T>TheGEoperator.static interfacestatic interfaceTheGEoperator.static interfaceQOM.Greatest<T>static interfacestatic interfaceQOM.Gt<T>TheGToperator.static interfaceTheGToperator.static interfaceQOM.HintedTable<R extends Record>A table with a MySQL style index access hint.static interfaceQOM.Iif<T>static interfaceQOM.In<T>TheINoperator.static interfaceQOM.InList<T>TheINpredicate accepting a list of values.static interfaceTheINSERTINGfunction.static interfaceTheIS DISTINCT FROMoperator.static interfaceTheIS DOCUMENToperator.static interfaceTheIS JSONoperator.static interfaceTheIS NOT DISTINCT FROMoperator.static interfaceTheIS NOT DOCUMENToperator.static interfaceTheIS NOT JSONoperator.static interfaceTheIS NOT NULLoperator.static interfaceTheIS NULLoperator.static interfacestatic interfaceQOM.JoinTable<R extends Record,J extends QOM.JoinTable<R, J>> static interfaceTheJSON ARRAYfunction.static interfacestatic interfaceTheJSONB GET ATTRIBUTEfunction.static interfaceTheJSONB GET ATTRIBUTE AS TEXTfunction.static interfaceTheJSONB GET ELEMENTfunction.static interfaceTheJSONB GET ELEMENT AS TEXTfunction.static interfaceTheJSONB INSERTfunction.static interfaceTheJSONB KEYSfunction.static interfaceTheJSONB REMOVEfunction.static interfaceTheJSONB REPLACEfunction.static interfaceTheJSONB SETfunction.static interfaceTheJSON GET ATTRIBUTEfunction.static interfaceTheJSON GET ATTRIBUTE AS TEXTfunction.static interfaceTheJSON GET ELEMENTfunction.static interfaceTheJSON GET ELEMENT AS TEXTfunction.static interfaceTheJSON INSERTfunction.static interfaceTheJSON KEYSfunction.static interfaceTheJSON OBJECTfunction.static interfacestatic interfaceTheJSON REMOVEfunction.static interfaceTheJSON REPLACEfunction.static interfaceTheJSON SETfunction.static interfaceQOM.Lag<T>static interfacestatic interfaceQOM.Lateral<R extends Record>static interfaceQOM.Le<T>TheLEoperator.static interfaceQOM.Lead<T>static interfaceQOM.Least<T>static interfaceTheLEFTfunction.static interfaceQOM.LeftAntiJoin<R extends Record>static interfaceQOM.LeftJoin<R extends Record>static interfaceQOM.LeftSemiJoin<R extends Record>static interfaceTheLEoperator.static interfaceTheLEVELfunction.static interfaceTheLIKEoperator.static interfaceTheLIKE IGNORE CASEoperator.static interfaceTheLIKEoperator.static interfaceQOM.LinkedTable<R extends Record>A table with a database link.static interfaceTheLNfunction.static interfaceTheLOGfunction.static interfaceTheLOG10function.static interfaceTheLOWERfunction.static interfaceTheLPADfunction.static interfaceQOM.Lt<T>TheLToperator.static interfaceTheLToperator.static interfaceTheLTRIMfunction.static interfaceQOM.Max<T>TheMAXfunction.static interfaceTheMD5function.static interfaceTheMEDIANfunction.static interfaceQOM.Min<T>TheMINfunction.static interfaceTheMODoperator.static interfaceQOM.Mode<T>static interfaceQOM.Mul<T>TheMULoperator.static interfaceQOM.Multiset<R extends Record>static interfaceQOM.MultisetAgg<R extends Record>static interfaceQOM.NaturalFullJoin<R extends Record>static interfaceQOM.NaturalJoin<R extends Record>static interfaceQOM.NaturalLeftJoin<R extends Record>static interfaceQOM.NaturalRightJoin<R extends Record>static interfaceQOM.Ne<T>TheNEoperator.static interfaceQOM.Neg<T>static interfaceTheNEoperator.static interfaceTheNOToperator.static interfaceTheNOToperator.static interfaceQOM.NotIn<T>TheNOT INoperator.static interfaceTheNOT INpredicate accepting a list of values.static interfaceTheNOT LIKEoperator.static interfaceTheNOT LIKE IGNORE CASEoperator.static interfaceTheNOT LIKEoperator.static interfaceTheNOT SIMILAR TOoperator.static interfaceTheNOT SIMILAR TOoperator.static interfaceQOM.NthValue<T>static interfacestatic interfaceAConditionthat is alwaysNULL.static interfaceQOM.Nullif<T>TheNULLIFfunction.static interfaceQOM.Nvl<T>TheNVLfunction.static interfaceQOM.Nvl2<T>static interfaceTheOCTET LENGTHfunction.static interfaceTheORoperator.static interfaceQOM.OuterApply<R extends Record>static interfaceTheOVERLAYfunction.static interfacestatic interfaceThePIfunction.static interfaceQOM.PlusJoin<T>ThePLUSoperator.static interfaceThePOSITIONfunction.static interfaceThePOWERoperator.static interfaceQOM.Prior<T>ThePRIORfunction.static interfaceThePRODUCTfunction.static interfaceQOM.QualifiedJoin<R extends Record,J extends QOM.QualifiedJoin<R, J>> static interfaceTheROWIDoperator.static interfaceTheRADIANSfunction.static interfaceTheRANDfunction.static interfacestatic interfacestatic interfacestatic interfaceTheREGR AVGXfunction.static interfaceTheREGR AVGYfunction.static interfaceTheREGR COUNTfunction.static interfaceTheREGR INTERCEPTfunction.static interfaceTheREGR R2function.static interfaceTheREGR SLOPEfunction.static interfaceTheREGR SXXfunction.static interfaceTheREGR SXYfunction.static interfaceTheREGR SYYfunction.static interfaceTheREPEATfunction.static interfaceTheREPLACEfunction.static interfaceTheREVERSEfunction.static interfaceTheRIGHTfunction.static interfaceQOM.RightJoin<R extends Record>static interfacestatic interfaceTheROUNDfunction.static interfaceQOM.RowAsField<R extends Record>static interfaceTheROW EQoperator.static interfaceTheROW GEoperator.static interfaceTheROW GToperator.static interfacestatic interfacestatic interfaceTheROW LEoperator.static interfaceTheROW LToperator.static interfaceTheROW NEoperator.static interfaceTheROWNUMfunction.static interfacestatic interfacestatic interfacestatic interfaceTheRPADfunction.static interfaceTheRTRIMfunction.static interfacestatic interfacestatic interfacestatic interfaceTheSHLoperator.static interfaceTheSHRoperator.static interfaceTheSIGNfunction.static interfaceTheSIMILAR TOoperator.static interfaceTheSIMILAR TOoperator.static interfaceTheSINfunction.static interfaceTheSINHfunction.static interfaceTheSPACEfunction.static interfaceTheSPLIT PARTfunction.static interfaceTheSQRTfunction.static interfaceQOM.Square<T extends Number>TheSQUAREfunction.static interfaceTheST AREAfunction.static interfaceTheSTARTS WITHoperator.static interfaceTheSTARTS WITH IGNORE CASEoperator.static interfaceTheST ASBINARYfunction.static interfaceTheST ASTEXTfunction.static interfaceTheST CENTROIDfunction.static interfaceQOM.StContains<T extends Spatial>TheST CONTAINSfunction.static interfaceTheST CROSSESfunction.static interfaceTheSTDDEV POPfunction.static interfaceTheSTDDEV SAMPfunction.static interfaceQOM.StDifference<T extends Spatial>TheST DIFFERENCEfunction.static interfaceQOM.StDisjoint<T extends Spatial>TheST DISJOINTfunction.static interfaceQOM.StDistance<T extends Spatial>TheST DISTANCEfunction.static interfaceQOM.StEndPoint<T extends Spatial>TheST ENDPOINTfunction.static interfaceQOM.StEquals<T extends Spatial>TheST EQUALSfunction.static interfaceTheST EXTERIORRINGfunction.static interfaceQOM.StGeometryN<T extends Spatial>TheST GEOMETRYNfunction.static interfaceTheST GEOMETRYTYPEfunction.static interfaceTheST GEOMFROMTEXTfunction.static interfaceTheST GEOMFROMWKBfunction.static interfaceTheST INTERIORRINGNfunction.static interfaceQOM.StIntersection<T extends Spatial>TheST INTERSECTIONfunction.static interfaceQOM.StIntersects<T extends Spatial>TheST INTERSECTSfunction.static interfaceTheST ISCLOSEDfunction.static interfaceTheST ISEMPTYfunction.static interfaceTheST LENGTHfunction.static interfaceTheST NUMGEOMETRIESfunction.static interfaceTheST NUMINTERIORRINGfunction.static interfaceTheST NUMPOINTSfunction.static interfaceQOM.StOverlaps<T extends Spatial>TheST OVERLAPSfunction.static interfaceQOM.StPointN<T extends Spatial>TheST POINTNfunction.static interfaceQOM.StraightJoin<R extends Record>static interfaceTheST SRIDfunction.static interfaceQOM.StStartPoint<T extends Spatial>TheST STARTPOINTfunction.static interfaceQOM.StTouches<T extends Spatial>TheST TOUCHESfunction.static interfaceQOM.StUnion<T extends Spatial>TheST UNIONfunction.static interfaceQOM.StWithin<T extends Spatial>TheST WITHINfunction.static interfaceTheST Xfunction.static interfaceTheST Yfunction.static interfaceTheST Zfunction.static interfaceQOM.Sub<T>TheSUBoperator.static interfaceTheSUBSTRINGfunction.static interfaceTheSUBSTRING INDEXfunction.static interfaceTheSUMfunction.static interfaceTheSYS CONNECT BY PATHfunction.static interfaceQOM.TableAlias<R extends Record>static interfaceQOM.TableAsField<R extends Record>static interfaceQOM.TableEq<R extends Record>TheEQoperator.static interfaceQOM.TableNe<R extends Record>TheNEoperator.static interfaceTheTANfunction.static interfaceTheTANHfunction.static interfaceTheTAUfunction.static interfacestatic interfaceTheTO CHARfunction.static interfaceTheTO DATEfunction.static interfaceTheTO HEXfunction.static interfaceTheTO TIMESTAMPfunction.static interfaceTheTRANSLATEfunction.static interfaceTheTRIMfunction.static interfaceAConditionthat is alwaysTRUE.static interfaceTheTRUNCfunction.static interfaceTheUNIQUEfunction.static interfaceTheUPDATINGfunction.static interfaceTheUPPERfunction.static interfaceTheUUIDfunction.static interfaceQOM.Values<R extends Record>static interfaceTheVAR POPfunction.static interfaceTheVAR SAMPfunction.static interfaceQOM.WidthBucket<T extends Number>TheWIDTH BUCKETfunction.static interfacestatic interfaceQOM.WithOrdinalityTable<R extends Record>A collection derived table or table valued function with aWITH ORDINALITYclause.static interfaceQOM.WithTable<R extends Record>A table with a T-SQL styleWITHhint.static interfacestatic interfaceTheXMLCOMMENTfunction.static interfaceTheXMLCONCATfunction.static interfaceTheXMLDOCUMENTfunction.static interfacestatic interfacestatic interfaceTheXMLFORESTfunction.static interfacestatic interfaceTheXMLPIfunction.static interfacestatic interfaceTheXMLSERIALIZEfunction.static interfaceTheXORoperator.Classes in org.jooq.impl that implement GroupFieldModifier and TypeClassDescriptionclassA base class for customConditionimplementations in client code.classCustomField<T>A base class for customFieldimplementations in client code.classCustomTable<R extends TableRecord<R>>A base class for customTableimplementations in client code.classA common base type for tablesMethods 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.emptyGroupingSet()Create a GROUPING SETS(field1, field2, .., fieldn) grouping field where each grouping set only consists of a single 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.Methods in org.jooq.impl with parameters of type GroupFieldModifier and TypeMethodDescriptionstatic @NotNull WindowSpecificationOrderByStepDSL.partitionBy(GroupField... fields) Create aWindowSpecificationwith aPARTITION BYclause.Method parameters in org.jooq.impl with type arguments of type GroupFieldModifier and TypeMethodDescriptionstatic @NotNull WindowSpecificationOrderByStepDSL.partitionBy(Collection<? extends GroupField> fields) Create aWindowSpecificationwith aPARTITION BYclause.