Uses of Interface
org.jooq.SortField

Packages that use SortField

Package	Description
org.jooq	The org.jooq package contains jOOQ's public API.

Uses of SortField in org.jooq

Methods in org.jooq that return SortField

Modifier and Type	Method and Description
SortField<T>	Field.asc() Create an ascending sort field from this field.
SortField<T>	Field.desc() Create a descending sort field from this field.
SortField<T>	SortField.nullsFirst() Add a NULLS FIRST clause to this sort field
SortField<T>	SortField.nullsLast() Add a NULLS LAST clause to this sort field
<Z> SortField<Z>	Field.sort(Map<T,Z> sortMap) Create an indirected sort field.
SortField<T>	Field.sort(SortOrder order) Create an ascending/descending sort field from this field.
SortField<Integer>	Field.sortAsc(Collection<T> sortList) Create an indirected sort field.
SortField<Integer>	Field.sortAsc(T... sortList) Create an indirected sort field.
SortField<Integer>	Field.sortDesc(Collection<T> sortList) Create an indirected sort field.
SortField<Integer>	Field.sortDesc(T... sortList) Create an indirected sort field.

Methods in org.jooq with parameters of type SortField

Modifier and Type	Method and Description
void	SelectQuery.addOrderBy(SortField<?>... fields) Adds ordering fields
WindowBeforeOverStep<T>	AggregateFunction.keepDenseRankFirstOrderBy(SortField<?>... fields) Restrict this aggregate function to FIRST values An example: MAX(ID) KEEP (DENSE_RANK FIRST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
WindowBeforeOverStep<T>	AggregateFunction.keepDenseRankLastOrderBy(SortField<?>... fields) Restrict this aggregate function to FIRST values An example: MAX(ID) KEEP (DENSE_RANK LAST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
WindowRowsStep<T>	WindowOrderByStep.orderBy(SortField<?>... fields) Add an ORDER BY clause to the window function.
SelectLimitStep<R>	SelectOrderByStep.orderBy(SortField<?>... fields) Add an ORDER BY clause to the query
GroupConcatSeparatorStep	GroupConcatOrderByStep.orderBy(SortField<?>... fields) Add an ORDER BY clause to the query
SelectLimitStep<R>	SelectOrderByStep.orderSiblingsBy(SortField<?>... fields) Add an ORDER SIBLINGS BY clause to the query This clause can be used only along with Oracle's CONNECT BY clause, to indicate that the hierarchical ordering should be preserved and elements of each hierarchy should be ordered among themselves.
AggregateFunction<T>	OrderedAggregateFunction.withinGroupOrderBy(SortField<?>... fields) Add an WITHIN GROUP (ORDER BY ..)

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

Modifier and Type	Method and Description
void	SelectQuery.addOrderBy(Collection<? extends SortField<?>> fields) Adds ordering fields
WindowBeforeOverStep<T>	AggregateFunction.keepDenseRankFirstOrderBy(Collection<? extends SortField<?>> fields) Restrict this aggregate function to FIRST values An example: MAX(ID) KEEP (DENSE_RANK FIRST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
WindowBeforeOverStep<T>	AggregateFunction.keepDenseRankLastOrderBy(Collection<? extends SortField<?>> fields) Restrict this aggregate function to FIRST values An example: MAX(ID) KEEP (DENSE_RANK LAST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
WindowRowsStep<T>	WindowOrderByStep.orderBy(Collection<? extends SortField<?>> fields) Add an ORDER BY clause to the window function.
SelectLimitStep<R>	SelectOrderByStep.orderBy(Collection<? extends SortField<?>> fields) Add an ORDER BY clause to the query
GroupConcatSeparatorStep	GroupConcatOrderByStep.orderBy(Collection<? extends SortField<?>> fields) Add an ORDER BY clause to the query
SelectLimitStep<R>	SelectOrderByStep.orderSiblingsBy(Collection<? extends SortField<?>> fields) Add an ORDER SIBLINGS BY clause to the query This clause can be used only along with Oracle's CONNECT BY clause, to indicate that the hierarchical ordering should be preserved and elements of each hierarchy should be ordered among themselves.
AggregateFunction<T>	OrderedAggregateFunction.withinGroupOrderBy(Collection<? extends SortField<?>> fields) Add an WITHIN GROUP (ORDER BY ..)