Uses of Interface
org.jooq.OrderField

Packages that use OrderField

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

Uses of OrderField in org.jooq

Subinterfaces of OrderField 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	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	JSONArrayNullStep<T>	A step in the construction of DSL.jsonArray(Field...) or DSL.jsonbArray(Field...) functions where the NULL clause can be defined.
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	JSONObjectNullStep<T>	A step in the construction of DSL.jsonObject(JSONEntry...) or DSL.jsonbObject(JSONEntry...) functions where the NULL clause can be defined.
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	Param<T>	A named parameter and/or bind value.
interface	SortField<T>	A sort specification.
interface	TableField<R extends Record,T>	A field contained in a table.
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>	This type is used for the window function DSL API.
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.

Methods in org.jooq with parameters of type OrderField

Modifier and Type	Method	Description
void	DeleteQuery.addOrderBy(OrderField<?>... fields)	Adds ordering fields.
void	SelectQuery.addOrderBy(OrderField<?>... fields)	Adds ordering fields.
void	UpdateQuery.addOrderBy(OrderField<?>... fields)	Adds ordering fields.
@NotNull AggregateFilterStep<T>	AggregateFunction.keepDenseRankFirstOrderBy(OrderField<?>... fields)	Restrict this aggregate function to FIRST values
@NotNull AggregateFilterStep<T>	AggregateFunction.keepDenseRankLastOrderBy(OrderField<?>... fields)	Restrict this aggregate function to FIRST values
@NotNull CreateIndexIncludeStep	CreateIndexStep.on(Table<?> table, OrderField<?>... fields)	Specify the table and column expressions on which to create an index.
@NotNull AggregateFilterStep<T>	ArrayAggOrderByStep.orderBy(OrderField<?>... fields)	Add an ORDER BY clause to the function.
@NotNull DeleteLimitStep<R>	DeleteOrderByStep.orderBy(OrderField<?>... fields)	Add an ORDER BY clause to the query.
@NotNull GroupConcatSeparatorStep	GroupConcatOrderByStep.orderBy(OrderField<?>... fields)	Add an ORDER BY clause to the function.
@NotNull JSONArrayAggNullStep<J>	JSONArrayAggOrderByStep.orderBy(OrderField<?>... fields)	Add an ORDER BY clause to the function.
@NotNull SelectSeekStepN<R>	SelectOrderByStep.orderBy(OrderField<?>... fields)	Add an ORDER BY clause to the query
<T1> @NotNull SelectSeekStep1<R,T1>	SelectOrderByStep.orderBy(OrderField<T1> field1)	Add an ORDER BY clause to the query.
<T1,T2> @NotNull SelectSeekStep2<R,T1,T2>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2)	Add an ORDER BY clause to the query.
<T1,T2,T3> @NotNull SelectSeekStep3<R,T1,T2,T3>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4> @NotNull SelectSeekStep4<R,T1,T2,T3,T4>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5> @NotNull SelectSeekStep5<R,T1,T2,T3,T4,T5>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6> @NotNull SelectSeekStep6<R,T1,T2,T3,T4,T5,T6>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7> @NotNull SelectSeekStep7<R,T1,T2,T3,T4,T5,T6,T7>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7,T8> @NotNull SelectSeekStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7,T8,T9> @NotNull SelectSeekStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> @NotNull SelectSeekStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> @NotNull SelectSeekStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> @NotNull SelectSeekStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> @NotNull SelectSeekStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> @NotNull SelectSeekStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> @NotNull SelectSeekStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> @NotNull SelectSeekStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15, OrderField<T16> field16)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> @NotNull SelectSeekStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15, OrderField<T16> field16, OrderField<T17> field17)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> @NotNull SelectSeekStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15, OrderField<T16> field16, OrderField<T17> field17, OrderField<T18> field18)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> @NotNull SelectSeekStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15, OrderField<T16> field16, OrderField<T17> field17, OrderField<T18> field18, OrderField<T19> field19)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> @NotNull SelectSeekStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15, OrderField<T16> field16, OrderField<T17> field17, OrderField<T18> field18, OrderField<T19> field19, OrderField<T20> field20)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> @NotNull SelectSeekStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15, OrderField<T16> field16, OrderField<T17> field17, OrderField<T18> field18, OrderField<T19> field19, OrderField<T20> field20, OrderField<T21> field21)	Add an ORDER BY clause to the query.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> @NotNull SelectSeekStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>	SelectOrderByStep.orderBy(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15, OrderField<T16> field16, OrderField<T17> field17, OrderField<T18> field18, OrderField<T19> field19, OrderField<T20> field20, OrderField<T21> field21, OrderField<T22> field22)	Add an ORDER BY clause to the query.
@NotNull UpdateLimitStep<R>	UpdateOrderByStep.orderBy(OrderField<?>... fields)	Add an ORDER BY clause to the query.
@NotNull WindowRowsStep<T>	WindowOrderByStep.orderBy(OrderField<?>... fields)	Add an ORDER BY clause to the window function.
@NotNull WindowSpecificationRowsStep	WindowSpecificationOrderByStep.orderBy(OrderField<?>... fields)	Add an ORDER BY clause to the window specification.
@NotNull AggregateFilterStep<T>	XMLAggOrderByStep.orderBy(OrderField<?>... fields)	Add an ORDER BY clause to the function.
@NotNull SelectLimitStep<R>	SelectOrderByStep.orderSiblingsBy(OrderField<?>... fields)	Add an ORDER SIBLINGS BY clause to the query
@NotNull AggregateFilterStep<T>	OrderedAggregateFunction.withinGroupOrderBy(OrderField<?>... fields)	Add an WITHIN GROUP (ORDER BY ..) clause to the ordered aggregate function
<T> @NotNull AggregateFilterStep<T>	OrderedAggregateFunctionOfDeferredType.withinGroupOrderBy(OrderField<T> field)	Add an WITHIN GROUP (ORDER BY ..) clause to the ordered aggregate function

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

Modifier and Type	Method	Description
void	DeleteQuery.addOrderBy(Collection<? extends OrderField<?>> fields)	Adds ordering fields.
void	SelectQuery.addOrderBy(Collection<? extends OrderField<?>> fields)	Adds ordering fields.
void	UpdateQuery.addOrderBy(Collection<? extends OrderField<?>> fields)	Adds ordering fields.
@NotNull AggregateFilterStep<T>	AggregateFunction.keepDenseRankFirstOrderBy(Collection<? extends OrderField<?>> fields)	Restrict this aggregate function to FIRST values
@NotNull AggregateFilterStep<T>	AggregateFunction.keepDenseRankLastOrderBy(Collection<? extends OrderField<?>> fields)	Restrict this aggregate function to FIRST values
@NotNull CreateIndexIncludeStep	CreateIndexStep.on(Table<?> table, Collection<? extends OrderField<?>> fields)	Specify the table and column expressions on which to create an index.
@NotNull AggregateFilterStep<T>	ArrayAggOrderByStep.orderBy(Collection<? extends OrderField<?>> fields)	Add an ORDER BY clause to the function.
@NotNull DeleteLimitStep<R>	DeleteOrderByStep.orderBy(Collection<? extends OrderField<?>> fields)	Add an ORDER BY clause to the query.
@NotNull GroupConcatSeparatorStep	GroupConcatOrderByStep.orderBy(Collection<? extends OrderField<?>> fields)	Add an ORDER BY clause to the function.
@NotNull JSONArrayAggNullStep<J>	JSONArrayAggOrderByStep.orderBy(Collection<? extends OrderField<?>> fields)	Add an ORDER BY clause to the function.
@NotNull SelectSeekStepN<R>	SelectOrderByStep.orderBy(Collection<? extends OrderField<?>> fields)	Add an ORDER BY clause to the query
@NotNull UpdateLimitStep<R>	UpdateOrderByStep.orderBy(Collection<? extends OrderField<?>> fields)	Add an ORDER BY clause to the query.
@NotNull WindowRowsStep<T>	WindowOrderByStep.orderBy(Collection<? extends OrderField<?>> fields)	Add an ORDER BY clause to the window function.
@NotNull WindowSpecificationRowsStep	WindowSpecificationOrderByStep.orderBy(Collection<? extends OrderField<?>> fields)	Add an ORDER BY clause to the window specification.
@NotNull AggregateFilterStep<T>	XMLAggOrderByStep.orderBy(Collection<? extends OrderField<?>> fields)	Add an ORDER BY clause to the function.
@NotNull SelectLimitStep<R>	SelectOrderByStep.orderSiblingsBy(Collection<? extends OrderField<?>> fields)	Add an ORDER SIBLINGS BY clause to the query
@NotNull AggregateFilterStep<T>	OrderedAggregateFunction.withinGroupOrderBy(Collection<? extends OrderField<?>> fields)	Add an WITHIN GROUP (ORDER BY ..) clause to the ordered aggregate function

Uses of OrderField in org.jooq.impl

Classes in org.jooq.impl that implement OrderField

Modifier and Type	Class	Description
class	CustomField<T>	A base class for custom Field implementations in client code.

Methods in org.jooq.impl with parameters of type OrderField

Modifier and Type	Method	Description
static Index	AbstractKeys.createIndex(String name, Table<?> table, OrderField<?>[] sortFields, boolean unique)	Deprecated. - [#6875] [#7158] - 3.11.0 - Please re-generate your code
static @NotNull Index	Internal.createIndex(String name, Table<?> table, OrderField<?>[] sortFields, boolean unique)	Deprecated. - 3.14.0 - [#9404] - Please re-generate your code.
static @NotNull Index	Internal.createIndex(Name name, Table<?> table, OrderField<?>[] sortFields, boolean unique)	Factory method for indexes.
static @NotNull WindowSpecificationRowsStep	DSL.orderBy(OrderField<?>... fields)	Create a WindowSpecification with an ORDER BY clause.

Method parameters in org.jooq.impl with type arguments of type OrderField

Modifier and Type	Method	Description
static @NotNull WindowSpecificationRowsStep	DSL.orderBy(Collection<? extends OrderField<?>> fields)	Create a WindowSpecification with an ORDER BY clause.