|
|||||||||
| PREV NEXT | FRAMES NO FRAMES | ||||||||
| Packages that use SortField | |
|---|---|
| org.jooq | |
| Uses of SortField in org.jooq |
|---|
| Methods in org.jooq that return SortField | ||
|---|---|---|
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 |
|
|
Field.sort(Map<T,Z> sortMap)
Create a sort field of the form (in pseudo code)
CASE [this] WHEN [sortMap.key(0)] THEN sortMap.value(0)
WHEN [sortMap.key(1)] THEN sortMap.value(1)
... |
|
SortField<Integer> |
Field.sortAsc(Collection<T> sortList)
Create a sort field of the form
CASE [this] WHEN [sortList.get(0)] THEN 0
WHEN [sortList.get(1)] THEN 1
... |
|
SortField<Integer> |
Field.sortAsc(T... sortList)
Create a sort field of the form
CASE [this] WHEN [sortList[0]] THEN 0
WHEN [sortList[1]] THEN 1
... |
|
SortField<Integer> |
Field.sortDesc(Collection<T> sortList)
Create a sort field of the form
CASE [this] WHEN [sortList.get(0)] THEN 0
WHEN [sortList.get(1)] THEN 1
... |
|
SortField<Integer> |
Field.sortDesc(T... sortList)
Create a sort field of the form
CASE [this] WHEN [sortList[0]] THEN 0
WHEN [sortList[1]] THEN 1
... |
|
| Methods in org.jooq with parameters of type SortField | |
|---|---|
void |
OrderProvider.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. |
SimpleSelectLimitStep<R> |
SimpleSelectOrderByStep.orderBy(SortField<?>... fields)
Add an ORDER BY clause to the query |
SelectLimitStep |
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 |
SimpleSelectLimitStep<R> |
SimpleSelectOrderByStep.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. |
SelectLimitStep |
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 | |
|---|---|
void |
OrderProvider.addOrderBy(Collection<SortField<?>> fields)
Adds ordering fields |
WindowBeforeOverStep<T> |
AggregateFunction.keepDenseRankFirstOrderBy(Collection<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<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<SortField<?>> fields)
Add an ORDER BY clause to the window function. |
SimpleSelectLimitStep<R> |
SimpleSelectOrderByStep.orderBy(Collection<SortField<?>> fields)
Add an ORDER BY clause to the query |
SelectLimitStep |
SelectOrderByStep.orderBy(Collection<SortField<?>> fields)
Add an ORDER BY clause to the query |
GroupConcatSeparatorStep |
GroupConcatOrderByStep.orderBy(Collection<SortField<?>> fields)
Add an ORDER BY clause to the query |
SimpleSelectLimitStep<R> |
SimpleSelectOrderByStep.orderSiblingsBy(Collection<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. |
SelectLimitStep |
SelectOrderByStep.orderSiblingsBy(Collection<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<SortField<?>> fields)
Add an WITHIN GROUP (ORDER BY ..) |
|
|||||||||
| PREV NEXT | FRAMES NO FRAMES | ||||||||