Module org.jooq
Package org.jooq

Interface SortField<T>

  • Type Parameters:
    T - The field type
    All Superinterfaces:
    OrderField<T>, QueryPart, Serializable

    public interface SortField<T>
    extends OrderField<T>
    A sort specification.

    The SQL ORDER BY clause accepts expressions based on Field, which may be enhanced by ASC or DESC as well as NULLS FIRST or NULLS LAST.

    Example:

     // Assuming import static org.jooq.impl.DSL.*;
    
     using(configuration)
        .select(ACTOR.FIRST_NAME, ACTOR.LAST_NAME)
        .from(ACTOR)
        .orderBy(ACTOR.LAST_UPDATE.desc().nullsLast())
        .fetch();
     

    Instances can be created using Field.asc(), Field.desc() and related methods.

    Author:
    Lukas Eder
    See Also:
    Field.asc(), Field.desc()
    • Method Detail

      • getName

        @NotNull
        @NotNull String getName()
        The name of this sort field
      • getOrder

        @NotNull
        @NotNull SortOrder getOrder()
        Get the underlying sort order of this sort field
      • nullsFirst

        @NotNull
        @Support
        @NotNull SortField<T> nullsFirst()
        Add a NULLS FIRST clause to this sort field
      • nullsLast

        @NotNull
        @Support
        @NotNull SortField<T> nullsLast()
        Add a NULLS LAST clause to this sort field