Module org.jooq
Package org.jooq

Interface Field<T>

Type Parameters:
T - The field type
All Superinterfaces:
FieldOrConstraint, FieldOrRow, GroupField, Named, OrderField<T>, QueryPart, SelectField<T>, SelectFieldOrAsterisk, Serializable, Typed<T>
All Known Subinterfaces:
AggregateFilterStep<T>, AggregateFunction<T>, ArrayAggOrderByStep<T>, CaseConditionStep<T>, CaseWhenStep<V,​T>, GroupConcatOrderByStep, GroupConcatSeparatorStep, JSONArrayAggNullStep<T>, JSONArrayAggOrderByStep<J>, JSONArrayAggReturningStep<T>, JSONArrayNullStep<T>, JSONArrayReturningStep<T>, JSONObjectAggNullStep<T>, JSONObjectAggReturningStep<T>, JSONObjectNullStep<T>, JSONObjectReturningStep<T>, JSONValueOnStep<J>, JSONValueReturningStep<T>, Param<T>, Parameter<T>, ParamOrVariable<T>, TableField<R,​T>, UDTField<R,​T>, Variable<T>, WindowBeforeOverStep<T>, WindowExcludeStep<T>, WindowFinalStep<T>, WindowOrderByStep<T>, WindowPartitionByStep<T>, WindowRowsStep<T>, XMLAggOrderByStep<T>
All Known Implementing Classes:
CustomField

public interface Field<T> extends SelectField<T>, GroupField, OrderField<T>, FieldOrRow, FieldOrConstraint
A column expression.

Column expressions or fields can be used in a variety of SQL statements and clauses, including (non-exhaustive list):

Example:

 // Assuming import static org.jooq.impl.DSL.*;

 using(configuration)
    .select(ACTOR.LAST_NAME)  // Field reference
    .from(ACTOR)
    .groupBy(ACTOR.LAST_NAME) // Field reference
    .orderBy(ACTOR.LAST_NAME) // Field reference
    .fetch();
 

Instances can be created using a variety of ways, including:

Author:
Lukas Eder