Uses of Interface org.jooq.OrderField (jOOQ 3.15.12 API)

Packages that use OrderField

Package

Description

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 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 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 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> 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.
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 LAST values @NotNull CreateIndexIncludeStep CreateIndexStep.on(Table<?> table, OrderField<?>... on) Add the ON clause to the CREATE INDEX statement. @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 LAST values @NotNull CreateIndexIncludeStep CreateIndexStep.on(Table<?> table, Collection<? extends OrderField<?>> on) Add the ON clause to the CREATE INDEX statement. @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.

Uses of Interfaceorg.jooq.OrderField

Uses of OrderField in org.jooq

Uses of OrderField in org.jooq.impl

Uses of Interface
org.jooq.OrderField