Uses of Interface
org.jooq.Field

Packages that use Field

Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.impl	This package contains jOOQ's implementation classes.
org.jooq.tools	This package contains jOOQ's public utilities.
org.jooq.util.cubrid	This package contains classes related to the SQLDialect.CUBRID dialect family.
org.jooq.util.mariadb	This package contains classes related to the SQLDialect.MARIADB dialect family.
org.jooq.util.mysql	This package contains classes related to the SQLDialect.MYSQL dialect family.
org.jooq.util.oracle	This package contains classes related to the SQLDialect.ORACLE dialect family.
org.jooq.util.postgres	This package contains classes related to the SQLDialect.POSTGRES dialect family.
org.jooq.util.sqlite	This package contains classes related to the SQLDialect.SQLITE dialect family.
org.jooq.util.sqlserver	This package contains classes related to the SQLDialect.SQLSERVER dialect family.

Uses of Field in org.jooq

Subinterfaces of Field 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

Methods in org.jooq that return Field

Modifier and Type	Method	Description
@NotNull Field<T>	Field.abs()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.abs(Field) instead.
@NotNull Field<BigDecimal>	Field.acos()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.acos(Field) instead.
@NotNull Field<T>	Field.add(Number value)	An arithmetic expression adding this to value.
@NotNull Field<T>	Field.add(Field<?> value)	An arithmetic expression to add value to this.
@NotNull Field<T>	Field.as(Function<? super Field<T>,? extends String> aliasFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull Field<T>	SelectField.as(String alias)	Create an alias for this field.
@NotNull Field<T>	SelectField.as(Field<?> otherField)	Create an alias for this field based on another field's name.
@NotNull Field<T>	SelectField.as(Name alias)	Create an alias for this field.
@NotNull Field<Integer>	Field.ascii()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.ascii(Field) instead.
<T> @NotNull Field<T>	FieldLike.asField()	The underlying field representation of this object.
<T> @NotNull Field<T>	FieldLike.asField(String alias)	The underlying field representation of this object.
<T> @NotNull Field<T>	FieldLike.asField(Function<? super Field<T>,? extends String> aliasFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull Field<BigDecimal>	Field.asin()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.asin(Field) instead.
@NotNull Field<BigDecimal>	Field.atan()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.atan(Field) instead.
@NotNull Field<BigDecimal>	Field.atan2(Number y)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.atan2(Field, Number) instead.
@NotNull Field<BigDecimal>	Field.atan2(Field<? extends Number> y)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.atan2(Field, Field) instead.
@NotNull Field<BigDecimal>	Field.avg()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.avg(Field) instead.
@NotNull Field<T>	Field.bitAnd(Field<T> value)	The bitwise and operator.
@NotNull Field<T>	Field.bitAnd(T value)	The bitwise and operator.
@NotNull Field<Integer>	Field.bitLength()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.bitLength(Field) instead.
@NotNull Field<T>	Field.bitNand(Field<T> value)	The bitwise not and operator.
@NotNull Field<T>	Field.bitNand(T value)	The bitwise not and operator.
@NotNull Field<T>	Field.bitNor(Field<T> value)	The bitwise not or operator.
@NotNull Field<T>	Field.bitNor(T value)	The bitwise not or operator.
@NotNull Field<T>	Field.bitNot()	The bitwise not operator.
@NotNull Field<T>	Field.bitOr(Field<T> value)	The bitwise or operator.
@NotNull Field<T>	Field.bitOr(T value)	The bitwise or operator.
@NotNull Field<T>	Field.bitXNor(Field<T> value)	The bitwise not xor operator.
@NotNull Field<T>	Field.bitXNor(T value)	The bitwise not xor operator.
@NotNull Field<T>	Field.bitXor(Field<T> value)	The bitwise xor operator.
@NotNull Field<T>	Field.bitXor(T value)	The bitwise xor operator.
<Z> @NotNull Field<Z>	Field.cast(Class<Z> type)	Cast this field to another type.
<Z> @NotNull Field<Z>	Field.cast(DataType<Z> type)	Cast this field to a dialect-specific data type.
<Z> @NotNull Field<Z>	Field.cast(Field<Z> field)	Cast this field to the type of another field.
@NotNull Field<T>	Field.ceil()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.ceil(Field) instead.
@NotNull Field<Integer>	Field.charLength()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.charLength(Field) instead.
@NotNull Field<T>	Field.coalesce(Field<T> option, Field<?>... options)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.coalesce(Field, Field...) instead.
@NotNull Field<T>	Field.coalesce(T option, T... options)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.coalesce(Object, Object...) instead.
<Z> @NotNull Field<Z>	Field.coerce(Class<Z> type)	Coerce this field to another type.
<Z> @NotNull Field<Z>	Field.coerce(DataType<Z> type)	Coerce this field to a dialect-specific data type.
<Z> @NotNull Field<Z>	Field.coerce(Field<Z> field)	Coerce this field to the type of another field.
@NotNull Field<String>	Field.collate(String collation)	Apply a collation operator to this column expression.
@NotNull Field<String>	Field.collate(Collation collation)	Apply a collation operator to this column expression.
@NotNull Field<String>	Field.collate(Name collation)	Apply a collation operator to this column expression.
@NotNull Field<String>	Field.concat(char... values)	This method is part of the pre-2.0 API.
@NotNull Field<String>	Field.concat(String... values)	This method is part of the pre-2.0 API.
@NotNull Field<String>	Field.concat(Field<?>... fields)	This method is part of the pre-2.0 API.
<U> @NotNull Field<U>	Field.convert(Class<U> toType, Function<? super T,? extends U> from, Function<? super U,? extends T> to)	Apply an ad-hoc data type Converter to this field expression.
<U> @NotNull Field<U>	Field.convert(Binding<T,U> binding)	Apply an ad-hoc data type Binding to this field expression.
<U> @NotNull Field<U>	Field.convert(Converter<T,U> converter)	Apply an ad-hoc data type Converter to this field expression.
<U> @NotNull Field<U>	Field.convertFrom(Class<U> toType, Function<? super T,? extends U> from)	Apply an ad-hoc read-only data type Converter to this field expression.
<U> @NotNull Field<U>	Field.convertFrom(Function<? super T,? extends U> from)	Apply an ad-hoc read-only data type Converter to this field expression.
<U> @NotNull Field<U>	Field.convertTo(Class<U> toType, Function<? super U,? extends T> to)	Apply an ad-hoc write-only data type Converter to this field expression.
<U> @NotNull Field<U>	Field.convertTo(Function<? super U,? extends T> to)	Apply an ad-hoc write-only data type Converter to this field expression.
@NotNull Field<BigDecimal>	Field.cos()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.cos(Field) instead.
@NotNull Field<BigDecimal>	Field.cosh()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.cosh(Field) instead.
@NotNull Field<BigDecimal>	Field.cot()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.cot(Field) instead.
@NotNull Field<BigDecimal>	Field.coth()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.coth(Field) instead.
@NotNull Field<Integer>	Field.count()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.count(Field) instead.
@NotNull Field<Integer>	Field.countDistinct()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.countDistinct(Field) instead.
@NotNull Field<T>	Sequence.currval()	An expression to get the current value of this sequence.
<Z> @NotNull Field<Z>	Field.decode(Field<T> search, Field<Z> result)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.decode(Field, Field, Field) instead.
<Z> @NotNull Field<Z>	Field.decode(Field<T> search, Field<Z> result, Field<?>... more)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.decode(Field, Field, Field, Field...) instead.
<Z> @NotNull Field<Z>	Field.decode(T search, Z result)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.decode(Object, Object, Object) instead.
<Z> @NotNull Field<Z>	Field.decode(T search, Z result, Object... more)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.decode(Object, Object, Object, Object...) instead.
@Nullable Field<T>	DataType.default_()	The expression to be applied as the DEFAULT value for this data type.
@Nullable Field<T>	DataType.defaultValue()	The expression to be applied as the DEFAULT value for this data type.
@NotNull Field<BigDecimal>	Field.deg()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.deg(Field) instead.
@NotNull Field<T>	Field.div(Number value)	An arithmetic expression dividing this by value.
@NotNull Field<T>	Field.div(Field<? extends Number> value)	An arithmetic expression dividing this by value.
@NotNull Field<T>	Field.divide(Number value)	An alias for div(Number).
@NotNull Field<T>	Field.divide(Field<? extends Number> value)	An alias for div(Field).
@NotNull Field<T>	CaseConditionStep.else_(Field<T> result)	Add an else clause to the already constructed case statement
@NotNull Field<T>	CaseConditionStep.else_(Select<? extends Record1<T>> result)	Add an else clause to the already constructed case statement
@NotNull Field<T>	CaseConditionStep.else_(T result)	Add an else clause to the already constructed case statement
@NotNull Field<T>	CaseWhenStep.else_(Field<T> result)	Add an else clause to the already constructed case statement
@NotNull Field<T>	CaseWhenStep.else_(T result)	Add an else clause to the already constructed case statement
@NotNull Field<BigDecimal>	Field.exp()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.exp(Field) instead.
@NotNull Field<Integer>	Field.extract(DatePart datePart)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.extract(Field, DatePart) instead.
Field<U>	BindingGetResultSetContext.field()	The Field at column index BindingGetResultSetContext.index() whose value is retrieved.
@Nullable Field<T>	Field.field(Record record)	The inverse operation of Fields.field(Field).
@Nullable Field<?>	Fields.field(int index)	Get a field known to this type by index, or null if no field is available at the index.
<T> @Nullable Field<T>	Fields.field(int index, Class<T> type)	Get a field known to this type by index coerced to type, or null if no field is available at the index.
<T> @Nullable Field<T>	Fields.field(int index, DataType<T> dataType)	Get a field known to this type by index coerced to dataType, or null if no field is available at the index.
@Nullable Field<?>	Fields.field(String name)	Get a field known to this type by unqualified name, or null if no field is known to this type by this name.
<T> @Nullable Field<T>	Fields.field(String name, Class<T> type)	Get a field known to this type by unqualified name coerced to type, or null if no field is known to this type by this name.
<T> @Nullable Field<T>	Fields.field(String name, DataType<T> dataType)	Get a field known to this type by unqualified name coerced to dataType, or null if no field is known to this type by this name.
<T> @Nullable Field<T>	Fields.field(Field<T> field)	Get a field known to this type by field reference.
@Nullable Field<?>	Fields.field(Name name)	Get a field known to this type by qualified name, or null if no field is known to this type by this name.
<T> @Nullable Field<T>	Fields.field(Name name, Class<T> type)	Get a field known to this type by qualified name coerced to type, or null if no field is known to this type by this name.
<T> @Nullable Field<T>	Fields.field(Name name, DataType<T> dataType)	Get a field known to this type by qualified name coerced to dataType, or null if no field is known to this type by this name.
Field<?>	LoaderFieldMapper.LoaderFieldContext.field()	The Field of the source data to be mapped.
@NotNull Field<T1>	Record1.field1()	Get the first field.
@NotNull Field<T1>	Record10.field1()	Get the first field.
@NotNull Field<T1>	Record11.field1()	Get the first field.
@NotNull Field<T1>	Record12.field1()	Get the first field.
@NotNull Field<T1>	Record13.field1()	Get the first field.
@NotNull Field<T1>	Record14.field1()	Get the first field.
@NotNull Field<T1>	Record15.field1()	Get the first field.
@NotNull Field<T1>	Record16.field1()	Get the first field.
@NotNull Field<T1>	Record17.field1()	Get the first field.
@NotNull Field<T1>	Record18.field1()	Get the first field.
@NotNull Field<T1>	Record19.field1()	Get the first field.
@NotNull Field<T1>	Record2.field1()	Get the first field.
@NotNull Field<T1>	Record20.field1()	Get the first field.
@NotNull Field<T1>	Record21.field1()	Get the first field.
@NotNull Field<T1>	Record22.field1()	Get the first field.
@NotNull Field<T1>	Record3.field1()	Get the first field.
@NotNull Field<T1>	Record4.field1()	Get the first field.
@NotNull Field<T1>	Record5.field1()	Get the first field.
@NotNull Field<T1>	Record6.field1()	Get the first field.
@NotNull Field<T1>	Record7.field1()	Get the first field.
@NotNull Field<T1>	Record8.field1()	Get the first field.
@NotNull Field<T1>	Record9.field1()	Get the first field.
@NotNull Field<T1>	Row1.field1()	Get the first field.
@NotNull Field<T1>	Row10.field1()	Get the first field.
@NotNull Field<T1>	Row11.field1()	Get the first field.
@NotNull Field<T1>	Row12.field1()	Get the first field.
@NotNull Field<T1>	Row13.field1()	Get the first field.
@NotNull Field<T1>	Row14.field1()	Get the first field.
@NotNull Field<T1>	Row15.field1()	Get the first field.
@NotNull Field<T1>	Row16.field1()	Get the first field.
@NotNull Field<T1>	Row17.field1()	Get the first field.
@NotNull Field<T1>	Row18.field1()	Get the first field.
@NotNull Field<T1>	Row19.field1()	Get the first field.
@NotNull Field<T1>	Row2.field1()	Get the first field.
@NotNull Field<T1>	Row20.field1()	Get the first field.
@NotNull Field<T1>	Row21.field1()	Get the first field.
@NotNull Field<T1>	Row22.field1()	Get the first field.
@NotNull Field<T1>	Row3.field1()	Get the first field.
@NotNull Field<T1>	Row4.field1()	Get the first field.
@NotNull Field<T1>	Row5.field1()	Get the first field.
@NotNull Field<T1>	Row6.field1()	Get the first field.
@NotNull Field<T1>	Row7.field1()	Get the first field.
@NotNull Field<T1>	Row8.field1()	Get the first field.
@NotNull Field<T1>	Row9.field1()	Get the first field.
@NotNull Field<T10>	Record10.field10()	Get the tenth field.
@NotNull Field<T10>	Record11.field10()	Get the tenth field.
@NotNull Field<T10>	Record12.field10()	Get the tenth field.
@NotNull Field<T10>	Record13.field10()	Get the tenth field.
@NotNull Field<T10>	Record14.field10()	Get the tenth field.
@NotNull Field<T10>	Record15.field10()	Get the tenth field.
@NotNull Field<T10>	Record16.field10()	Get the tenth field.
@NotNull Field<T10>	Record17.field10()	Get the tenth field.
@NotNull Field<T10>	Record18.field10()	Get the tenth field.
@NotNull Field<T10>	Record19.field10()	Get the tenth field.
@NotNull Field<T10>	Record20.field10()	Get the tenth field.
@NotNull Field<T10>	Record21.field10()	Get the tenth field.
@NotNull Field<T10>	Record22.field10()	Get the tenth field.
@NotNull Field<T10>	Row10.field10()	Get the tenth field.
@NotNull Field<T10>	Row11.field10()	Get the tenth field.
@NotNull Field<T10>	Row12.field10()	Get the tenth field.
@NotNull Field<T10>	Row13.field10()	Get the tenth field.
@NotNull Field<T10>	Row14.field10()	Get the tenth field.
@NotNull Field<T10>	Row15.field10()	Get the tenth field.
@NotNull Field<T10>	Row16.field10()	Get the tenth field.
@NotNull Field<T10>	Row17.field10()	Get the tenth field.
@NotNull Field<T10>	Row18.field10()	Get the tenth field.
@NotNull Field<T10>	Row19.field10()	Get the tenth field.
@NotNull Field<T10>	Row20.field10()	Get the tenth field.
@NotNull Field<T10>	Row21.field10()	Get the tenth field.
@NotNull Field<T10>	Row22.field10()	Get the tenth field.
@NotNull Field<T11>	Record11.field11()	Get the eleventh field.
@NotNull Field<T11>	Record12.field11()	Get the eleventh field.
@NotNull Field<T11>	Record13.field11()	Get the eleventh field.
@NotNull Field<T11>	Record14.field11()	Get the eleventh field.
@NotNull Field<T11>	Record15.field11()	Get the eleventh field.
@NotNull Field<T11>	Record16.field11()	Get the eleventh field.
@NotNull Field<T11>	Record17.field11()	Get the eleventh field.
@NotNull Field<T11>	Record18.field11()	Get the eleventh field.
@NotNull Field<T11>	Record19.field11()	Get the eleventh field.
@NotNull Field<T11>	Record20.field11()	Get the eleventh field.
@NotNull Field<T11>	Record21.field11()	Get the eleventh field.
@NotNull Field<T11>	Record22.field11()	Get the eleventh field.
@NotNull Field<T11>	Row11.field11()	Get the eleventh field.
@NotNull Field<T11>	Row12.field11()	Get the eleventh field.
@NotNull Field<T11>	Row13.field11()	Get the eleventh field.
@NotNull Field<T11>	Row14.field11()	Get the eleventh field.
@NotNull Field<T11>	Row15.field11()	Get the eleventh field.
@NotNull Field<T11>	Row16.field11()	Get the eleventh field.
@NotNull Field<T11>	Row17.field11()	Get the eleventh field.
@NotNull Field<T11>	Row18.field11()	Get the eleventh field.
@NotNull Field<T11>	Row19.field11()	Get the eleventh field.
@NotNull Field<T11>	Row20.field11()	Get the eleventh field.
@NotNull Field<T11>	Row21.field11()	Get the eleventh field.
@NotNull Field<T11>	Row22.field11()	Get the eleventh field.
@NotNull Field<T12>	Record12.field12()	Get the twelfth field.
@NotNull Field<T12>	Record13.field12()	Get the twelfth field.
@NotNull Field<T12>	Record14.field12()	Get the twelfth field.
@NotNull Field<T12>	Record15.field12()	Get the twelfth field.
@NotNull Field<T12>	Record16.field12()	Get the twelfth field.
@NotNull Field<T12>	Record17.field12()	Get the twelfth field.
@NotNull Field<T12>	Record18.field12()	Get the twelfth field.
@NotNull Field<T12>	Record19.field12()	Get the twelfth field.
@NotNull Field<T12>	Record20.field12()	Get the twelfth field.
@NotNull Field<T12>	Record21.field12()	Get the twelfth field.
@NotNull Field<T12>	Record22.field12()	Get the twelfth field.
@NotNull Field<T12>	Row12.field12()	Get the twelfth field.
@NotNull Field<T12>	Row13.field12()	Get the twelfth field.
@NotNull Field<T12>	Row14.field12()	Get the twelfth field.
@NotNull Field<T12>	Row15.field12()	Get the twelfth field.
@NotNull Field<T12>	Row16.field12()	Get the twelfth field.
@NotNull Field<T12>	Row17.field12()	Get the twelfth field.
@NotNull Field<T12>	Row18.field12()	Get the twelfth field.
@NotNull Field<T12>	Row19.field12()	Get the twelfth field.
@NotNull Field<T12>	Row20.field12()	Get the twelfth field.
@NotNull Field<T12>	Row21.field12()	Get the twelfth field.
@NotNull Field<T12>	Row22.field12()	Get the twelfth field.
@NotNull Field<T13>	Record13.field13()	Get the thirteenth field.
@NotNull Field<T13>	Record14.field13()	Get the thirteenth field.
@NotNull Field<T13>	Record15.field13()	Get the thirteenth field.
@NotNull Field<T13>	Record16.field13()	Get the thirteenth field.
@NotNull Field<T13>	Record17.field13()	Get the thirteenth field.
@NotNull Field<T13>	Record18.field13()	Get the thirteenth field.
@NotNull Field<T13>	Record19.field13()	Get the thirteenth field.
@NotNull Field<T13>	Record20.field13()	Get the thirteenth field.
@NotNull Field<T13>	Record21.field13()	Get the thirteenth field.
@NotNull Field<T13>	Record22.field13()	Get the thirteenth field.
@NotNull Field<T13>	Row13.field13()	Get the thirteenth field.
@NotNull Field<T13>	Row14.field13()	Get the thirteenth field.
@NotNull Field<T13>	Row15.field13()	Get the thirteenth field.
@NotNull Field<T13>	Row16.field13()	Get the thirteenth field.
@NotNull Field<T13>	Row17.field13()	Get the thirteenth field.
@NotNull Field<T13>	Row18.field13()	Get the thirteenth field.
@NotNull Field<T13>	Row19.field13()	Get the thirteenth field.
@NotNull Field<T13>	Row20.field13()	Get the thirteenth field.
@NotNull Field<T13>	Row21.field13()	Get the thirteenth field.
@NotNull Field<T13>	Row22.field13()	Get the thirteenth field.
@NotNull Field<T14>	Record14.field14()	Get the fourteenth field.
@NotNull Field<T14>	Record15.field14()	Get the fourteenth field.
@NotNull Field<T14>	Record16.field14()	Get the fourteenth field.
@NotNull Field<T14>	Record17.field14()	Get the fourteenth field.
@NotNull Field<T14>	Record18.field14()	Get the fourteenth field.
@NotNull Field<T14>	Record19.field14()	Get the fourteenth field.
@NotNull Field<T14>	Record20.field14()	Get the fourteenth field.
@NotNull Field<T14>	Record21.field14()	Get the fourteenth field.
@NotNull Field<T14>	Record22.field14()	Get the fourteenth field.
@NotNull Field<T14>	Row14.field14()	Get the fourteenth field.
@NotNull Field<T14>	Row15.field14()	Get the fourteenth field.
@NotNull Field<T14>	Row16.field14()	Get the fourteenth field.
@NotNull Field<T14>	Row17.field14()	Get the fourteenth field.
@NotNull Field<T14>	Row18.field14()	Get the fourteenth field.
@NotNull Field<T14>	Row19.field14()	Get the fourteenth field.
@NotNull Field<T14>	Row20.field14()	Get the fourteenth field.
@NotNull Field<T14>	Row21.field14()	Get the fourteenth field.
@NotNull Field<T14>	Row22.field14()	Get the fourteenth field.
@NotNull Field<T15>	Record15.field15()	Get the fifteenth field.
@NotNull Field<T15>	Record16.field15()	Get the fifteenth field.
@NotNull Field<T15>	Record17.field15()	Get the fifteenth field.
@NotNull Field<T15>	Record18.field15()	Get the fifteenth field.
@NotNull Field<T15>	Record19.field15()	Get the fifteenth field.
@NotNull Field<T15>	Record20.field15()	Get the fifteenth field.
@NotNull Field<T15>	Record21.field15()	Get the fifteenth field.
@NotNull Field<T15>	Record22.field15()	Get the fifteenth field.
@NotNull Field<T15>	Row15.field15()	Get the fifteenth field.
@NotNull Field<T15>	Row16.field15()	Get the fifteenth field.
@NotNull Field<T15>	Row17.field15()	Get the fifteenth field.
@NotNull Field<T15>	Row18.field15()	Get the fifteenth field.
@NotNull Field<T15>	Row19.field15()	Get the fifteenth field.
@NotNull Field<T15>	Row20.field15()	Get the fifteenth field.
@NotNull Field<T15>	Row21.field15()	Get the fifteenth field.
@NotNull Field<T15>	Row22.field15()	Get the fifteenth field.
@NotNull Field<T16>	Record16.field16()	Get the sixteenth field.
@NotNull Field<T16>	Record17.field16()	Get the sixteenth field.
@NotNull Field<T16>	Record18.field16()	Get the sixteenth field.
@NotNull Field<T16>	Record19.field16()	Get the sixteenth field.
@NotNull Field<T16>	Record20.field16()	Get the sixteenth field.
@NotNull Field<T16>	Record21.field16()	Get the sixteenth field.
@NotNull Field<T16>	Record22.field16()	Get the sixteenth field.
@NotNull Field<T16>	Row16.field16()	Get the sixteenth field.
@NotNull Field<T16>	Row17.field16()	Get the sixteenth field.
@NotNull Field<T16>	Row18.field16()	Get the sixteenth field.
@NotNull Field<T16>	Row19.field16()	Get the sixteenth field.
@NotNull Field<T16>	Row20.field16()	Get the sixteenth field.
@NotNull Field<T16>	Row21.field16()	Get the sixteenth field.
@NotNull Field<T16>	Row22.field16()	Get the sixteenth field.
@NotNull Field<T17>	Record17.field17()	Get the seventeenth field.
@NotNull Field<T17>	Record18.field17()	Get the seventeenth field.
@NotNull Field<T17>	Record19.field17()	Get the seventeenth field.
@NotNull Field<T17>	Record20.field17()	Get the seventeenth field.
@NotNull Field<T17>	Record21.field17()	Get the seventeenth field.
@NotNull Field<T17>	Record22.field17()	Get the seventeenth field.
@NotNull Field<T17>	Row17.field17()	Get the seventeenth field.
@NotNull Field<T17>	Row18.field17()	Get the seventeenth field.
@NotNull Field<T17>	Row19.field17()	Get the seventeenth field.
@NotNull Field<T17>	Row20.field17()	Get the seventeenth field.
@NotNull Field<T17>	Row21.field17()	Get the seventeenth field.
@NotNull Field<T17>	Row22.field17()	Get the seventeenth field.
@NotNull Field<T18>	Record18.field18()	Get the eighteenth field.
@NotNull Field<T18>	Record19.field18()	Get the eighteenth field.
@NotNull Field<T18>	Record20.field18()	Get the eighteenth field.
@NotNull Field<T18>	Record21.field18()	Get the eighteenth field.
@NotNull Field<T18>	Record22.field18()	Get the eighteenth field.
@NotNull Field<T18>	Row18.field18()	Get the eighteenth field.
@NotNull Field<T18>	Row19.field18()	Get the eighteenth field.
@NotNull Field<T18>	Row20.field18()	Get the eighteenth field.
@NotNull Field<T18>	Row21.field18()	Get the eighteenth field.
@NotNull Field<T18>	Row22.field18()	Get the eighteenth field.
@NotNull Field<T19>	Record19.field19()	Get the ninteenth field.
@NotNull Field<T19>	Record20.field19()	Get the ninteenth field.
@NotNull Field<T19>	Record21.field19()	Get the ninteenth field.
@NotNull Field<T19>	Record22.field19()	Get the ninteenth field.
@NotNull Field<T19>	Row19.field19()	Get the ninteenth field.
@NotNull Field<T19>	Row20.field19()	Get the ninteenth field.
@NotNull Field<T19>	Row21.field19()	Get the ninteenth field.
@NotNull Field<T19>	Row22.field19()	Get the ninteenth field.
@NotNull Field<T2>	Record10.field2()	Get the second field.
@NotNull Field<T2>	Record11.field2()	Get the second field.
@NotNull Field<T2>	Record12.field2()	Get the second field.
@NotNull Field<T2>	Record13.field2()	Get the second field.
@NotNull Field<T2>	Record14.field2()	Get the second field.
@NotNull Field<T2>	Record15.field2()	Get the second field.
@NotNull Field<T2>	Record16.field2()	Get the second field.
@NotNull Field<T2>	Record17.field2()	Get the second field.
@NotNull Field<T2>	Record18.field2()	Get the second field.
@NotNull Field<T2>	Record19.field2()	Get the second field.
@NotNull Field<T2>	Record2.field2()	Get the second field.
@NotNull Field<T2>	Record20.field2()	Get the second field.
@NotNull Field<T2>	Record21.field2()	Get the second field.
@NotNull Field<T2>	Record22.field2()	Get the second field.
@NotNull Field<T2>	Record3.field2()	Get the second field.
@NotNull Field<T2>	Record4.field2()	Get the second field.
@NotNull Field<T2>	Record5.field2()	Get the second field.
@NotNull Field<T2>	Record6.field2()	Get the second field.
@NotNull Field<T2>	Record7.field2()	Get the second field.
@NotNull Field<T2>	Record8.field2()	Get the second field.
@NotNull Field<T2>	Record9.field2()	Get the second field.
@NotNull Field<T2>	Row10.field2()	Get the second field.
@NotNull Field<T2>	Row11.field2()	Get the second field.
@NotNull Field<T2>	Row12.field2()	Get the second field.
@NotNull Field<T2>	Row13.field2()	Get the second field.
@NotNull Field<T2>	Row14.field2()	Get the second field.
@NotNull Field<T2>	Row15.field2()	Get the second field.
@NotNull Field<T2>	Row16.field2()	Get the second field.
@NotNull Field<T2>	Row17.field2()	Get the second field.
@NotNull Field<T2>	Row18.field2()	Get the second field.
@NotNull Field<T2>	Row19.field2()	Get the second field.
@NotNull Field<T2>	Row2.field2()	Get the second field.
@NotNull Field<T2>	Row20.field2()	Get the second field.
@NotNull Field<T2>	Row21.field2()	Get the second field.
@NotNull Field<T2>	Row22.field2()	Get the second field.
@NotNull Field<T2>	Row3.field2()	Get the second field.
@NotNull Field<T2>	Row4.field2()	Get the second field.
@NotNull Field<T2>	Row5.field2()	Get the second field.
@NotNull Field<T2>	Row6.field2()	Get the second field.
@NotNull Field<T2>	Row7.field2()	Get the second field.
@NotNull Field<T2>	Row8.field2()	Get the second field.
@NotNull Field<T2>	Row9.field2()	Get the second field.
@NotNull Field<T20>	Record20.field20()	Get the twentieth field.
@NotNull Field<T20>	Record21.field20()	Get the twentieth field.
@NotNull Field<T20>	Record22.field20()	Get the twentieth field.
@NotNull Field<T20>	Row20.field20()	Get the twentieth field.
@NotNull Field<T20>	Row21.field20()	Get the twentieth field.
@NotNull Field<T20>	Row22.field20()	Get the twentieth field.
@NotNull Field<T21>	Record21.field21()	Get the twenty-first field.
@NotNull Field<T21>	Record22.field21()	Get the twenty-first field.
@NotNull Field<T21>	Row21.field21()	Get the twenty-first field.
@NotNull Field<T21>	Row22.field21()	Get the twenty-first field.
@NotNull Field<T22>	Record22.field22()	Get the twenty-second field.
@NotNull Field<T22>	Row22.field22()	Get the twenty-second field.
@NotNull Field<T3>	Record10.field3()	Get the third field.
@NotNull Field<T3>	Record11.field3()	Get the third field.
@NotNull Field<T3>	Record12.field3()	Get the third field.
@NotNull Field<T3>	Record13.field3()	Get the third field.
@NotNull Field<T3>	Record14.field3()	Get the third field.
@NotNull Field<T3>	Record15.field3()	Get the third field.
@NotNull Field<T3>	Record16.field3()	Get the third field.
@NotNull Field<T3>	Record17.field3()	Get the third field.
@NotNull Field<T3>	Record18.field3()	Get the third field.
@NotNull Field<T3>	Record19.field3()	Get the third field.
@NotNull Field<T3>	Record20.field3()	Get the third field.
@NotNull Field<T3>	Record21.field3()	Get the third field.
@NotNull Field<T3>	Record22.field3()	Get the third field.
@NotNull Field<T3>	Record3.field3()	Get the third field.
@NotNull Field<T3>	Record4.field3()	Get the third field.
@NotNull Field<T3>	Record5.field3()	Get the third field.
@NotNull Field<T3>	Record6.field3()	Get the third field.
@NotNull Field<T3>	Record7.field3()	Get the third field.
@NotNull Field<T3>	Record8.field3()	Get the third field.
@NotNull Field<T3>	Record9.field3()	Get the third field.
@NotNull Field<T3>	Row10.field3()	Get the third field.
@NotNull Field<T3>	Row11.field3()	Get the third field.
@NotNull Field<T3>	Row12.field3()	Get the third field.
@NotNull Field<T3>	Row13.field3()	Get the third field.
@NotNull Field<T3>	Row14.field3()	Get the third field.
@NotNull Field<T3>	Row15.field3()	Get the third field.
@NotNull Field<T3>	Row16.field3()	Get the third field.
@NotNull Field<T3>	Row17.field3()	Get the third field.
@NotNull Field<T3>	Row18.field3()	Get the third field.
@NotNull Field<T3>	Row19.field3()	Get the third field.
@NotNull Field<T3>	Row20.field3()	Get the third field.
@NotNull Field<T3>	Row21.field3()	Get the third field.
@NotNull Field<T3>	Row22.field3()	Get the third field.
@NotNull Field<T3>	Row3.field3()	Get the third field.
@NotNull Field<T3>	Row4.field3()	Get the third field.
@NotNull Field<T3>	Row5.field3()	Get the third field.
@NotNull Field<T3>	Row6.field3()	Get the third field.
@NotNull Field<T3>	Row7.field3()	Get the third field.
@NotNull Field<T3>	Row8.field3()	Get the third field.
@NotNull Field<T3>	Row9.field3()	Get the third field.
@NotNull Field<T4>	Record10.field4()	Get the fourth field.
@NotNull Field<T4>	Record11.field4()	Get the fourth field.
@NotNull Field<T4>	Record12.field4()	Get the fourth field.
@NotNull Field<T4>	Record13.field4()	Get the fourth field.
@NotNull Field<T4>	Record14.field4()	Get the fourth field.
@NotNull Field<T4>	Record15.field4()	Get the fourth field.
@NotNull Field<T4>	Record16.field4()	Get the fourth field.
@NotNull Field<T4>	Record17.field4()	Get the fourth field.
@NotNull Field<T4>	Record18.field4()	Get the fourth field.
@NotNull Field<T4>	Record19.field4()	Get the fourth field.
@NotNull Field<T4>	Record20.field4()	Get the fourth field.
@NotNull Field<T4>	Record21.field4()	Get the fourth field.
@NotNull Field<T4>	Record22.field4()	Get the fourth field.
@NotNull Field<T4>	Record4.field4()	Get the fourth field.
@NotNull Field<T4>	Record5.field4()	Get the fourth field.
@NotNull Field<T4>	Record6.field4()	Get the fourth field.
@NotNull Field<T4>	Record7.field4()	Get the fourth field.
@NotNull Field<T4>	Record8.field4()	Get the fourth field.
@NotNull Field<T4>	Record9.field4()	Get the fourth field.
@NotNull Field<T4>	Row10.field4()	Get the fourth field.
@NotNull Field<T4>	Row11.field4()	Get the fourth field.
@NotNull Field<T4>	Row12.field4()	Get the fourth field.
@NotNull Field<T4>	Row13.field4()	Get the fourth field.
@NotNull Field<T4>	Row14.field4()	Get the fourth field.
@NotNull Field<T4>	Row15.field4()	Get the fourth field.
@NotNull Field<T4>	Row16.field4()	Get the fourth field.
@NotNull Field<T4>	Row17.field4()	Get the fourth field.
@NotNull Field<T4>	Row18.field4()	Get the fourth field.
@NotNull Field<T4>	Row19.field4()	Get the fourth field.
@NotNull Field<T4>	Row20.field4()	Get the fourth field.
@NotNull Field<T4>	Row21.field4()	Get the fourth field.
@NotNull Field<T4>	Row22.field4()	Get the fourth field.
@NotNull Field<T4>	Row4.field4()	Get the fourth field.
@NotNull Field<T4>	Row5.field4()	Get the fourth field.
@NotNull Field<T4>	Row6.field4()	Get the fourth field.
@NotNull Field<T4>	Row7.field4()	Get the fourth field.
@NotNull Field<T4>	Row8.field4()	Get the fourth field.
@NotNull Field<T4>	Row9.field4()	Get the fourth field.
@NotNull Field<T5>	Record10.field5()	Get the fifth field.
@NotNull Field<T5>	Record11.field5()	Get the fifth field.
@NotNull Field<T5>	Record12.field5()	Get the fifth field.
@NotNull Field<T5>	Record13.field5()	Get the fifth field.
@NotNull Field<T5>	Record14.field5()	Get the fifth field.
@NotNull Field<T5>	Record15.field5()	Get the fifth field.
@NotNull Field<T5>	Record16.field5()	Get the fifth field.
@NotNull Field<T5>	Record17.field5()	Get the fifth field.
@NotNull Field<T5>	Record18.field5()	Get the fifth field.
@NotNull Field<T5>	Record19.field5()	Get the fifth field.
@NotNull Field<T5>	Record20.field5()	Get the fifth field.
@NotNull Field<T5>	Record21.field5()	Get the fifth field.
@NotNull Field<T5>	Record22.field5()	Get the fifth field.
@NotNull Field<T5>	Record5.field5()	Get the fifth field.
@NotNull Field<T5>	Record6.field5()	Get the fifth field.
@NotNull Field<T5>	Record7.field5()	Get the fifth field.
@NotNull Field<T5>	Record8.field5()	Get the fifth field.
@NotNull Field<T5>	Record9.field5()	Get the fifth field.
@NotNull Field<T5>	Row10.field5()	Get the fifth field.
@NotNull Field<T5>	Row11.field5()	Get the fifth field.
@NotNull Field<T5>	Row12.field5()	Get the fifth field.
@NotNull Field<T5>	Row13.field5()	Get the fifth field.
@NotNull Field<T5>	Row14.field5()	Get the fifth field.
@NotNull Field<T5>	Row15.field5()	Get the fifth field.
@NotNull Field<T5>	Row16.field5()	Get the fifth field.
@NotNull Field<T5>	Row17.field5()	Get the fifth field.
@NotNull Field<T5>	Row18.field5()	Get the fifth field.
@NotNull Field<T5>	Row19.field5()	Get the fifth field.
@NotNull Field<T5>	Row20.field5()	Get the fifth field.
@NotNull Field<T5>	Row21.field5()	Get the fifth field.
@NotNull Field<T5>	Row22.field5()	Get the fifth field.
@NotNull Field<T5>	Row5.field5()	Get the fifth field.
@NotNull Field<T5>	Row6.field5()	Get the fifth field.
@NotNull Field<T5>	Row7.field5()	Get the fifth field.
@NotNull Field<T5>	Row8.field5()	Get the fifth field.
@NotNull Field<T5>	Row9.field5()	Get the fifth field.
@NotNull Field<T6>	Record10.field6()	Get the sixth field.
@NotNull Field<T6>	Record11.field6()	Get the sixth field.
@NotNull Field<T6>	Record12.field6()	Get the sixth field.
@NotNull Field<T6>	Record13.field6()	Get the sixth field.
@NotNull Field<T6>	Record14.field6()	Get the sixth field.
@NotNull Field<T6>	Record15.field6()	Get the sixth field.
@NotNull Field<T6>	Record16.field6()	Get the sixth field.
@NotNull Field<T6>	Record17.field6()	Get the sixth field.
@NotNull Field<T6>	Record18.field6()	Get the sixth field.
@NotNull Field<T6>	Record19.field6()	Get the sixth field.
@NotNull Field<T6>	Record20.field6()	Get the sixth field.
@NotNull Field<T6>	Record21.field6()	Get the sixth field.
@NotNull Field<T6>	Record22.field6()	Get the sixth field.
@NotNull Field<T6>	Record6.field6()	Get the sixth field.
@NotNull Field<T6>	Record7.field6()	Get the sixth field.
@NotNull Field<T6>	Record8.field6()	Get the sixth field.
@NotNull Field<T6>	Record9.field6()	Get the sixth field.
@NotNull Field<T6>	Row10.field6()	Get the sixth field.
@NotNull Field<T6>	Row11.field6()	Get the sixth field.
@NotNull Field<T6>	Row12.field6()	Get the sixth field.
@NotNull Field<T6>	Row13.field6()	Get the sixth field.
@NotNull Field<T6>	Row14.field6()	Get the sixth field.
@NotNull Field<T6>	Row15.field6()	Get the sixth field.
@NotNull Field<T6>	Row16.field6()	Get the sixth field.
@NotNull Field<T6>	Row17.field6()	Get the sixth field.
@NotNull Field<T6>	Row18.field6()	Get the sixth field.
@NotNull Field<T6>	Row19.field6()	Get the sixth field.
@NotNull Field<T6>	Row20.field6()	Get the sixth field.
@NotNull Field<T6>	Row21.field6()	Get the sixth field.
@NotNull Field<T6>	Row22.field6()	Get the sixth field.
@NotNull Field<T6>	Row6.field6()	Get the sixth field.
@NotNull Field<T6>	Row7.field6()	Get the sixth field.
@NotNull Field<T6>	Row8.field6()	Get the sixth field.
@NotNull Field<T6>	Row9.field6()	Get the sixth field.
@NotNull Field<T7>	Record10.field7()	Get the seventh field.
@NotNull Field<T7>	Record11.field7()	Get the seventh field.
@NotNull Field<T7>	Record12.field7()	Get the seventh field.
@NotNull Field<T7>	Record13.field7()	Get the seventh field.
@NotNull Field<T7>	Record14.field7()	Get the seventh field.
@NotNull Field<T7>	Record15.field7()	Get the seventh field.
@NotNull Field<T7>	Record16.field7()	Get the seventh field.
@NotNull Field<T7>	Record17.field7()	Get the seventh field.
@NotNull Field<T7>	Record18.field7()	Get the seventh field.
@NotNull Field<T7>	Record19.field7()	Get the seventh field.
@NotNull Field<T7>	Record20.field7()	Get the seventh field.
@NotNull Field<T7>	Record21.field7()	Get the seventh field.
@NotNull Field<T7>	Record22.field7()	Get the seventh field.
@NotNull Field<T7>	Record7.field7()	Get the seventh field.
@NotNull Field<T7>	Record8.field7()	Get the seventh field.
@NotNull Field<T7>	Record9.field7()	Get the seventh field.
@NotNull Field<T7>	Row10.field7()	Get the seventh field.
@NotNull Field<T7>	Row11.field7()	Get the seventh field.
@NotNull Field<T7>	Row12.field7()	Get the seventh field.
@NotNull Field<T7>	Row13.field7()	Get the seventh field.
@NotNull Field<T7>	Row14.field7()	Get the seventh field.
@NotNull Field<T7>	Row15.field7()	Get the seventh field.
@NotNull Field<T7>	Row16.field7()	Get the seventh field.
@NotNull Field<T7>	Row17.field7()	Get the seventh field.
@NotNull Field<T7>	Row18.field7()	Get the seventh field.
@NotNull Field<T7>	Row19.field7()	Get the seventh field.
@NotNull Field<T7>	Row20.field7()	Get the seventh field.
@NotNull Field<T7>	Row21.field7()	Get the seventh field.
@NotNull Field<T7>	Row22.field7()	Get the seventh field.
@NotNull Field<T7>	Row7.field7()	Get the seventh field.
@NotNull Field<T7>	Row8.field7()	Get the seventh field.
@NotNull Field<T7>	Row9.field7()	Get the seventh field.
@NotNull Field<T8>	Record10.field8()	Get the eighth field.
@NotNull Field<T8>	Record11.field8()	Get the eighth field.
@NotNull Field<T8>	Record12.field8()	Get the eighth field.
@NotNull Field<T8>	Record13.field8()	Get the eighth field.
@NotNull Field<T8>	Record14.field8()	Get the eighth field.
@NotNull Field<T8>	Record15.field8()	Get the eighth field.
@NotNull Field<T8>	Record16.field8()	Get the eighth field.
@NotNull Field<T8>	Record17.field8()	Get the eighth field.
@NotNull Field<T8>	Record18.field8()	Get the eighth field.
@NotNull Field<T8>	Record19.field8()	Get the eighth field.
@NotNull Field<T8>	Record20.field8()	Get the eighth field.
@NotNull Field<T8>	Record21.field8()	Get the eighth field.
@NotNull Field<T8>	Record22.field8()	Get the eighth field.
@NotNull Field<T8>	Record8.field8()	Get the eighth field.
@NotNull Field<T8>	Record9.field8()	Get the eighth field.
@NotNull Field<T8>	Row10.field8()	Get the eighth field.
@NotNull Field<T8>	Row11.field8()	Get the eighth field.
@NotNull Field<T8>	Row12.field8()	Get the eighth field.
@NotNull Field<T8>	Row13.field8()	Get the eighth field.
@NotNull Field<T8>	Row14.field8()	Get the eighth field.
@NotNull Field<T8>	Row15.field8()	Get the eighth field.
@NotNull Field<T8>	Row16.field8()	Get the eighth field.
@NotNull Field<T8>	Row17.field8()	Get the eighth field.
@NotNull Field<T8>	Row18.field8()	Get the eighth field.
@NotNull Field<T8>	Row19.field8()	Get the eighth field.
@NotNull Field<T8>	Row20.field8()	Get the eighth field.
@NotNull Field<T8>	Row21.field8()	Get the eighth field.
@NotNull Field<T8>	Row22.field8()	Get the eighth field.
@NotNull Field<T8>	Row8.field8()	Get the eighth field.
@NotNull Field<T8>	Row9.field8()	Get the eighth field.
@NotNull Field<T9>	Record10.field9()	Get the ninth field.
@NotNull Field<T9>	Record11.field9()	Get the ninth field.
@NotNull Field<T9>	Record12.field9()	Get the ninth field.
@NotNull Field<T9>	Record13.field9()	Get the ninth field.
@NotNull Field<T9>	Record14.field9()	Get the ninth field.
@NotNull Field<T9>	Record15.field9()	Get the ninth field.
@NotNull Field<T9>	Record16.field9()	Get the ninth field.
@NotNull Field<T9>	Record17.field9()	Get the ninth field.
@NotNull Field<T9>	Record18.field9()	Get the ninth field.
@NotNull Field<T9>	Record19.field9()	Get the ninth field.
@NotNull Field<T9>	Record20.field9()	Get the ninth field.
@NotNull Field<T9>	Record21.field9()	Get the ninth field.
@NotNull Field<T9>	Record22.field9()	Get the ninth field.
@NotNull Field<T9>	Record9.field9()	Get the ninth field.
@NotNull Field<T9>	Row10.field9()	Get the ninth field.
@NotNull Field<T9>	Row11.field9()	Get the ninth field.
@NotNull Field<T9>	Row12.field9()	Get the ninth field.
@NotNull Field<T9>	Row13.field9()	Get the ninth field.
@NotNull Field<T9>	Row14.field9()	Get the ninth field.
@NotNull Field<T9>	Row15.field9()	Get the ninth field.
@NotNull Field<T9>	Row16.field9()	Get the ninth field.
@NotNull Field<T9>	Row17.field9()	Get the ninth field.
@NotNull Field<T9>	Row18.field9()	Get the ninth field.
@NotNull Field<T9>	Row19.field9()	Get the ninth field.
@NotNull Field<T9>	Row20.field9()	Get the ninth field.
@NotNull Field<T9>	Row21.field9()	Get the ninth field.
@NotNull Field<T9>	Row22.field9()	Get the ninth field.
@NotNull Field<T9>	Row9.field9()	Get the ninth field.
@NotNull Field<?>[]	Fields.fields()	Get all fields known to this type.
@NotNull Field<?>[]	Fields.fields(int... indexes)	Get all fields known to this type, filtering by some field indexes.
@NotNull Field<?>[]	Fields.fields(String... names)	Get all fields known to this type, filtering by some unqualified field names.
@NotNull Field<?>[]	Fields.fields(Field<?>... fields)	Get all fields, filtering by some fields.
@NotNull Field<?>[]	Fields.fields(Name... names)	Get all fields known to this type, filtering by some qualified field names.
@NotNull Field<T>	Field.floor()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.floor(Field) instead.
@Nullable Field<T>	Sequence.getCache()	Get the number of sequence values to cache for this sequence or null, if no such value is specified.
@Nullable Field<T>	Period.getEnd()	The expression specifying the end of the period.
@Nullable Field<T>	Sequence.getIncrementBy()	Get the increment for this sequence or null, if no such value is specified.
@Nullable Field<T>	Sequence.getMaxvalue()	Get the maximum value for this sequence or null, if no such value is specified.
@Nullable Field<T>	Sequence.getMinvalue()	Get the minimum value for this sequence or null, if no such value is specified.
@Nullable Field<T>	Period.getStart()	The expression specifying the start of the period.
@Nullable Field<T>	Sequence.getStartWith()	Get the start value for this sequence or null, if no such value is specified.
@NotNull Field<T>	Field.greatest(Field<?>... others)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.greatest(Field, Field...) instead.
@NotNull Field<T>	Field.greatest(T... others)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.greatest(Field, Field...) instead.
@NotNull Field<String>	JSONEntry.key()	The JSON entry key.
@NotNull Field<T>	Field.least(Field<?>... others)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.least(Field, Field...) instead.
@NotNull Field<T>	Field.least(T... others)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.least(Field, Field...) instead.
@NotNull Field<Integer>	Field.length()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.length(Field) instead.
@NotNull Field<BigDecimal>	Field.ln()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.ln(Field) instead.
@NotNull Field<BigDecimal>	Field.log(int base)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.log(Field, int) instead.
@NotNull Field<String>	Field.lower()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.lower(Field) instead.
@NotNull Field<String>	Field.lpad(int length)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.lpad(Field, int) instead.
@NotNull Field<String>	Field.lpad(int length, char character)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.lpad(Field, int, char) instead.
@NotNull Field<String>	Field.lpad(Field<? extends Number> length)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.lpad(Field, Field) instead.
@NotNull Field<String>	Field.lpad(Field<? extends Number> length, Field<String> character)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.lpad(Field, Field, Field) instead.
@NotNull Field<String>	Field.ltrim()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.ltrim(Field) instead.
Field<?>	LoaderFieldMapper.map(LoaderFieldMapper.LoaderFieldContext ctx)	Map a Field from the loader source onto a target table Field.
@NotNull Field<T>	Field.max()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.max(Field) instead.
@NotNull Field<BigDecimal>	Field.median()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.median(Field) instead.
@NotNull Field<T>	Field.min()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.min(Field) instead.
@NotNull Field<T>	Field.minus(Number value)	An alias for sub(Number).
@NotNull Field<T>	Field.minus(Field<?> value)	An alias for sub(Field).
@NotNull Field<T>	Field.mod(Number value)	An arithmetic expression getting the modulo of this divided by value.
@NotNull Field<T>	Field.mod(Field<? extends Number> value)	An arithmetic expression getting the modulo of this divided by value.
@NotNull Field<T>	Field.modulo(Number value)	An alias for mod(Number).
@NotNull Field<T>	Field.modulo(Field<? extends Number> value)	An alias for mod(Field).
@NotNull Field<T>	Field.mul(Number value)	An arithmetic expression multiplying this with value.
@NotNull Field<T>	Field.mul(Field<? extends Number> value)	An arithmetic expression multiplying this with value.
@NotNull Field<T>	Field.multiply(Number value)	An alias for mul(Number).
@NotNull Field<T>	Field.multiply(Field<? extends Number> value)	An alias for mul(Field).
@NotNull Field<T>	Field.neg()	Negate this field to get its negative value.
@NotNull Field<T>	Sequence.nextval()	An expression to increment the sequence and get the next value.
@NotNull Field<T>	Field.nullif(Field<T> other)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.nullif(Field, Field) instead.
@NotNull Field<T>	Field.nullif(T other)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.nullif(Field, Object) instead.
@NotNull Field<T>	Field.nvl(Field<T> defaultValue)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.nvl(Field, Field) instead.
@NotNull Field<T>	Field.nvl(T defaultValue)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.nvl(Field, Object) instead.
<Z> @NotNull Field<Z>	Field.nvl2(Field<Z> valueIfNotNull, Field<Z> valueIfNull)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.nvl2(Field, Field, Field) instead.
<Z> @NotNull Field<Z>	Field.nvl2(Z valueIfNotNull, Z valueIfNull)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.nvl2(Field, Object, Object) instead.
@NotNull Field<Integer>	Field.octetLength()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.octetLength(Field) instead.
@NotNull Field<T>	CaseConditionStep.otherwise(Field<T> result)	Add an else clause to the already constructed case statement
@NotNull Field<T>	CaseConditionStep.otherwise(Select<? extends Record1<T>> result)	Add an else clause to the already constructed case statement
@NotNull Field<T>	CaseConditionStep.otherwise(T result)	Add an else clause to the already constructed case statement
@NotNull Field<T>	CaseWhenStep.otherwise(Field<T> result)	Add an else clause to the already constructed case statement
@NotNull Field<T>	CaseWhenStep.otherwise(T result)	Add an else clause to the already constructed case statement
@NotNull Field<?>	ParseContext.parseField()	Parse a Field expression or fail if the current expression is not a field.
@Nullable Field<?>	ParseListener.parseField(ParseContext ctx)	Attempt to parse a Field expression.
@NotNull Field<?>	Parser.parseField(String sql)	Parse a SQL string to a field.
@NotNull Field<?>	Parser.parseField(String sql, Object... bindings)	Parse a SQL string with bind variables to a field.
@NotNull Field<XML>	XMLQueryPassingStep.passing(Field<XML> xml)	Add the PASSING clause to the XMLQUERY expression.
@NotNull Field<XML>	XMLQueryPassingStep.passing(XML xml)	Add the PASSING clause to the XMLQUERY expression.
@NotNull Field<XML>	XMLQueryPassingStep.passingByRef(Field<XML> xml)	Add the PASSING BY REF clause to the XMLQUERY expression.
@NotNull Field<XML>	XMLQueryPassingStep.passingByRef(XML xml)	Add the PASSING BY REF clause to the XMLQUERY expression.
@NotNull Field<XML>	XMLQueryPassingStep.passingByValue(Field<XML> xml)	Add the PASSING BY VALUE clause to the XMLQUERY expression.
@NotNull Field<XML>	XMLQueryPassingStep.passingByValue(XML xml)	Add the PASSING BY VALUE clause to the XMLQUERY expression.
@NotNull Field<T>	Field.plus()	Turn this field into an Oracle-specific field for use in outer-join predicates.
@NotNull Field<T>	Field.plus(Number value)	An alias for add(Number).
@NotNull Field<T>	Field.plus(Field<?> value)	An alias for add(Field).
@NotNull Field<Integer>	Field.position(String search)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.position(Field, String) instead.
@NotNull Field<Integer>	Field.position(Field<String> search)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.position(Field, Field) instead.
@NotNull Field<BigDecimal>	Field.pow(Number exponent)	An arithmetic expression getting this value raised to the power of exponent.
@NotNull Field<BigDecimal>	Field.pow(Field<? extends Number> exponent)	An arithmetic expression getting this value raised to the power of exponent.
@NotNull Field<BigDecimal>	Field.power(Number exponent)	An alias for power(Number).
@NotNull Field<BigDecimal>	Field.power(Field<? extends Number> exponent)	An alias for power(Field).
@NotNull Field<BigDecimal>	Field.rad()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.rad(Field) instead.
@NotNull Field<T>	Field.rem(Number value)	An alias for mod(Number).
@NotNull Field<T>	Field.rem(Field<? extends Number> value)	An alias for mod(Field).
@NotNull Field<String>	Field.repeat(Number count)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.repeat(Field, int) instead.
@NotNull Field<String>	Field.repeat(Field<? extends Number> count)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.repeat(Field, Field) instead.
@NotNull Field<String>	Field.replace(String search)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.replace(Field, String) instead.
@NotNull Field<String>	Field.replace(String search, String replace)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.replace(Field, String, String) instead.
@NotNull Field<String>	Field.replace(Field<String> search)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.replace(Field, Field) instead.
@NotNull Field<String>	Field.replace(Field<String> search, Field<String> replace)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.replace(Field, Field, Field) instead.
@NotNull Field<T>	JSONArrayReturningStep.returning(DataType<?> returning)	Add the RETURNING clause to the JSON ARRAY function.
@NotNull Field<T>	JSONObjectReturningStep.returning(DataType<?> returning)	Add the RETURNING clause to the JSON OBJECT function.
@NotNull Field<T>	JSONValueReturningStep.returning(DataType<?> returning)	Add the RETURNING clause to the JSON VALUE function.
@NotNull Field<T>	Field.round()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.round(Field) instead.
@NotNull Field<T>	Field.round(int decimals)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.round(Field, int) instead.
@NotNull Field<RowId>	Table.rowid()	Get a table.rowid reference from this table.
@NotNull Field<String>	Field.rpad(int length)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.rpad(Field, int) instead.
@NotNull Field<String>	Field.rpad(int length, char character)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.rpad(Field, int, char) instead.
@NotNull Field<String>	Field.rpad(Field<? extends Number> length)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.rpad(Field, Field) instead.
@NotNull Field<String>	Field.rpad(Field<? extends Number> length, Field<String> character)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.rpad(Field, Field, Field) instead.
@NotNull Field<String>	Field.rtrim()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.rtrim(Field) instead.
@NotNull Field<T>	Field.shl(Number value)	The bitwise left shift operator.
@NotNull Field<T>	Field.shl(Field<? extends Number> value)	The bitwise left shift operator.
@NotNull Field<T>	Field.shr(Number value)	The bitwise right shift operator.
@NotNull Field<T>	Field.shr(Field<? extends Number> value)	The bitwise right shift operator.
@NotNull Field<Integer>	Field.sign()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.sign(Field) instead.
@NotNull Field<BigDecimal>	Field.sin()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.sin(Field) instead.
@NotNull Field<BigDecimal>	Field.sinh()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.sinh(Field) instead.
@NotNull Field<BigDecimal>	Field.sqrt()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.sqrt(Field) instead.
@NotNull Field<BigDecimal>	Field.stddevPop()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.stddevPop(Field) instead.
@NotNull Field<BigDecimal>	Field.stddevSamp()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.stddevSamp(Field) instead.
@NotNull Field<T>	Field.sub(Number value)	An arithmetic expression subtracting value from this.
@NotNull Field<T>	Field.sub(Field<?> value)	An arithmetic expression subtracting value from this.
@NotNull Field<String>	Field.substring(int startingPosition)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.substring(Field, int) instead.
@NotNull Field<String>	Field.substring(int startingPosition, int length)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.substring(Field, int, int) instead.
@NotNull Field<String>	Field.substring(Field<? extends Number> startingPosition)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.substring(Field, Field) instead.
@NotNull Field<String>	Field.substring(Field<? extends Number> startingPosition, Field<? extends Number> length)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.substring(Field, Field, Field) instead.
@NotNull Field<T>	Field.subtract(Number value)	An alias for sub(Number).
@NotNull Field<T>	Field.subtract(Field<?> value)	An alias for sub(Field).
@NotNull Field<BigDecimal>	Field.sum()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.sum(Field) instead.
@NotNull Field<BigDecimal>	Field.tan()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.tan(Field) instead.
@NotNull Field<BigDecimal>	Field.tanh()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.tanh(Field) instead.
@NotNull Field<T>	Field.times(Number value)	An alias for mul(Number).
@NotNull Field<T>	Field.times(Field<? extends Number> value)	An alias for mul(Field).
@NotNull Field<String>	Field.trim()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.trim(Field) instead.
@NotNull Field<T>	Field.unaryMinus()	Negate this field to get its negative value.
@NotNull Field<T>	Field.unaryPlus()	Get this field as its positive value (no effect on SQL).
@NotNull Field<String>	Field.upper()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.13 - [#9407] - Use DSL.upper(Field) instead.
@NotNull Field<T>	JSONEntry.value()	The JSON entry value.
@NotNull Field<BigDecimal>	Field.varPop()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.varPop(Field) instead.
@NotNull Field<BigDecimal>	Field.varSamp()	Deprecated, for removal: This API element is subject to removal in a future version. - 3.11 - [#7538] - Use DSL.varSamp(Field) instead.

Methods in org.jooq that return types with arguments of type Field

Modifier and Type	Method	Description
@NotNull Stream<Field<?>>	Fields.fieldStream()	Get all fields known to this type as a Stream.
@NotNull List<Field<?>>	Select.getSelect()	All fields selected in this query

Methods in org.jooq with parameters of type Field

Modifier and Type	Method	Description
@NotNull AlterTableAddStep	AlterTableStep.add(Field<?> field)	Add an ADD COLUMN clause to the ALTER TABLE statement.
<T> @NotNull AlterTableAddStep	AlterTableStep.add(Field<T> field, DataType<T> type)	Add an ADD COLUMN clause to the ALTER TABLE statement.
@NotNull Field<T>	Field.add(Field<?> value)	An arithmetic expression to add value to this.
@NotNull AlterTableAddStep	AlterTableStep.addColumn(Field<?> field)	Add an ADD COLUMN clause to the ALTER TABLE statement.
<T> @NotNull AlterTableAddStep	AlterTableStep.addColumn(Field<T> field, DataType<T> type)	Add an ADD COLUMN clause to the ALTER TABLE statement.
@NotNull AlterTableAddStep	AlterTableStep.addColumnIfNotExists(Field<?> field)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
<T> @NotNull AlterTableAddStep	AlterTableStep.addColumnIfNotExists(Field<T> field, DataType<T> type)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
@NotNull AlterTableAddStep	AlterTableStep.addIfNotExists(Field<?> field)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
<T> @NotNull AlterTableAddStep	AlterTableStep.addIfNotExists(Field<T> field, DataType<T> type)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
void	SelectQuery.addJoin(TableLike<?> table, JoinType type, Condition[] conditions, Field<?>[] partitionBy)	Joins the existing table product to a new table using conditions, connecting them with each other with Operator.AND.
void	SelectQuery.addJoin(TableLike<?> table, JoinType type, Condition conditions, Field<?>[] partitionBy)	Joins the existing table product to a new table using conditions, connecting them with each other with Operator.AND.
void	SelectQuery.addSeekAfter(Field<?>... fields)	Adds seeking fields.
void	SelectQuery.addSeekBefore(Field<?>... fields)	Deprecated. - [#7461] - SEEK BEFORE is not implemented correctly
@NotNull AlterTypeFinalStep	AlterTypeStep.addValue(Field<String> addValue)	Add the ADD VALUE clause to the ALTER TYPE statement.
<T> void	StoreQuery.addValue(Field<T> field, Field<T> value)	Add a value to the store statement
<T> void	StoreQuery.addValue(Field<T> field, T value)	Add a value to the store statement
<T> void	InsertQuery.addValueForUpdate(Field<T> field, Field<T> value)	Add a value to the ON DUPLICATE KEY UPDATE clause of this INSERT statement, where this is supported.
<T> void	InsertQuery.addValueForUpdate(Field<T> field, T value)	Add a value to the ON DUPLICATE KEY UPDATE clause of this INSERT statement, where this is supported.
@NotNull AlterTableFinalStep	AlterTableAddStep.after(Field<?> columnName)	Add a AFTER clause to ALTER TABLE ..

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

Modifier and Type	Method	Description
void	SelectQuery.addJoinUsing(TableLike<?> table, Collection<? extends Field<?>> fields)	Joins the existing table product to a new table with a USING clause.
void	SelectQuery.addJoinUsing(TableLike<?> table, JoinType type, Collection<? extends Field<?>> fields)	Joins the existing table product to a new table with a USING clause.
void	SelectQuery.addSeekAfter(Collection<? extends Field<?>> fields)	Adds seeking fields.
void	SelectQuery.addSeekBefore(Collection<? extends Field<?>> fields)	Deprecated. - [#7461] - SEEK BEFORE is not implemented correctly
@NotNull Query	CallArgsStep.args(Collection<? extends Field<?>> args)	Add the ARGS clause to the CALL statement.
@NotNull Field<T>	Field.as(Function<? super Field<T>,? extends String> aliasFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull Table<R>	Table.as(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull Table<R>	Table.as(String alias, Function<? super Field<?>,? extends String> aliasFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull Table<R>	Table.as(Name alias, BiFunction<? super Field<?>,? super Integer,? extends Name> aliasFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull Table<R>	Table.as(Name alias, Function<? super Field<?>,? extends Name> aliasFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull Table<R>	Table.as(Table<?> otherTable, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> aliasFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull Table<R>	Table.as(Table<?> otherTable, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> aliasFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull Table<R>	Table.as(Table<?> otherTable, Function<? super Field<?>,? extends Field<?>> aliasFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull Table<R>	Table.as(Table<?> otherTable, Function<? super Field<?>,? extends Field<?>> aliasFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
<T> @NotNull Field<T>	FieldLike.asField(Function<? super Field<T>,? extends String> aliasFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull Table<R>	TableLike.asTable(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull Table<R>	TableLike.asTable(String alias, Function<? super Field<?>,? extends String> aliasFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull ResultQuery<Record>	ResultQuery.coerce(Collection<? extends Field<?>> fields)	Coerce the result record type of this query to that of a set of fields.
@NotNull CreateTableColumnStep	CreateTableColumnStep.columns(Collection<? extends Field<?>> fields)	Add several columns to the column list of the CREATE TABLE statement.
@NotNull InsertValuesStepN<R>	InsertSetStep.columns(Collection<? extends Field<?>> fields)	Set the columns for insert.
@NotNull MergeKeyStepN<R>	MergeUsingStep.columns(Collection<? extends Field<?>> fields)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull CreateViewAsStep<Record>	DSLContext.createOrReplaceView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createOrReplaceView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createOrReplaceView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createOrReplaceView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createViewIfNotExists(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createViewIfNotExists(String view, Function<? super Field<?>,? extends String> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createViewIfNotExists(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createViewIfNotExists(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull CreateViewAsStep<Record>	DSLContext.createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull AlterTableDropStep	AlterTableStep.drop(Collection<? extends Field<?>> fields)	Add an DROP COLUMN clause to the ALTER TABLE statement.
@NotNull AlterTableDropStep	AlterTableStep.dropColumns(Collection<? extends Field<?>> fields)	Add an DROP COLUMN clause to the ALTER TABLE statement.
@NotNull LoaderCSVOptionsStep<R>	LoaderCSVStep.fields(Collection<? extends Field<?>> fields)	Specify the the fields to be loaded into the table in the correct order.
@NotNull LoaderJSONOptionsStep<R>	LoaderJSONStep.fields(Collection<? extends Field<?>> fields)	Specify the fields to be loaded into the table in the correct order.
@NotNull LoaderListenerStep<R>	LoaderRowsStep.fields(Collection<? extends Field<?>> fields)	Specify the the fields to be loaded into the table in the correct order.
@NotNull DerivedColumnList	Name.fields(BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull DerivedColumnList	Name.fields(Function<? super Field<?>,? extends String> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull ConstraintForeignKeyReferencesStepN	ConstraintTypeStep.foreignKey(Collection<? extends Field<?>> fields)	Add a FOREIGN KEY clause to the CONSTRAINT.
@NotNull Table<Record>	PivotInStep.in(Collection<? extends Field<T>> fields)	Specify the acceptable values for pivoting
@NotNull CreateIndexWhereStep	CreateIndexIncludeStep.include(Collection<? extends Field<?>> include)	Add the INCLUDE clause to the CREATE INDEX statement.
int	TableRecord.insert(Collection<? extends Field<?>> fields)	Store parts of this record to the database using an INSERT statement.
int	UpdatableRecord.insert(Collection<? extends Field<?>> fields)	Store parts of this record to the database using an INSERT statement.
<R extends Record> @NotNull InsertValuesStepN<R>	DSLContext.insertInto(Table<R> into, Collection<? extends Field<?>> fields)	Create a new DSL insert statement.
<R extends Record> @NotNull InsertValuesStepN<R>	WithStep.insertInto(Table<R> into, Collection<? extends Field<?>> fields)	Create a new DSL insert statement.
@NotNull MergeValuesStep1<R,T1>	MergeKeyStep1.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	MergeKeyStep10.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	MergeKeyStep11.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	MergeKeyStep12.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	MergeKeyStep13.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	MergeKeyStep14.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	MergeKeyStep15.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	MergeKeyStep16.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	MergeKeyStep17.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	MergeKeyStep18.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	MergeKeyStep19.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep2<R,T1,T2>	MergeKeyStep2.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	MergeKeyStep20.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>	MergeKeyStep21.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>	MergeKeyStep22.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep3<R,T1,T2,T3>	MergeKeyStep3.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep4<R,T1,T2,T3,T4>	MergeKeyStep4.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep5<R,T1,T2,T3,T4,T5>	MergeKeyStep5.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep6<R,T1,T2,T3,T4,T5,T6>	MergeKeyStep6.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>	MergeKeyStep7.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>	MergeKeyStep8.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>	MergeKeyStep9.key(Collection<? extends Field<?>> keys)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeValuesStepN<R>	MergeKeyStepN.key(Collection<? extends Field<?>> keys)	Specify an optional KEY clause.
<T> @NotNull CaseWhenStep<V,T>	CaseValueStep.mapFields(Map<? extends Field<V>,? extends Field<T>> fields)	Create WHEN ..

Uses of Field in org.jooq.impl

Classes in org.jooq.impl that implement Field

Modifier and Type	Class	Description
class	CustomField<T>	A base class for custom Field implementations in client code.

Fields in org.jooq.impl declared as Field

Modifier and Type	Field	Description
protected Field<?>[]	TableImpl.parameters

Methods in org.jooq.impl that return Field

Modifier and Type	Method	Description
static <T extends Number> @NotNull Field<T>	DSL.abs(Field<T> number)	The ABS function.
static <T extends Number> @NotNull Field<T>	DSL.abs(T number)	The ABS function.
static @NotNull Field<BigDecimal>	DSL.acos(Number number)	The ACOS function.
static @NotNull Field<BigDecimal>	DSL.acos(Field<? extends Number> number)	The ACOS function.
static <T> @NotNull Field<T[]>	DSL.array(Collection<? extends Field<T>> fields)	Create an array literal.
static <T> @NotNull Field<T[]>	DSL.array(Field<T>... fields)	Create an array literal.
static <T> @NotNull Field<T[]>	DSL.array(Select<? extends Record1<T>> select)	The PostgreSQL array(select) function.
static <T> @NotNull Field<T[]>	DSL.array(T... values)	Create an array literal.
static <T> @NotNull Field<T>	DSL.arrayGet(Field<T[]> field, int index)	Get an array element at a given index (1 based)
static <T> @NotNull Field<T>	DSL.arrayGet(Field<T[]> field, Field<Integer> index)	Get an array element at a given index (1 based)
Field<T>	CustomField.as(Name alias)
static @NotNull Field<Integer>	DSL.ascii(String string)	The ASCII function.
static @NotNull Field<Integer>	DSL.ascii(Field<String> string)	The ASCII function.
Field<T>	AbstractRoutine.asField()
Field<T>	AbstractRoutine.asField(String alias)
static @NotNull Field<BigDecimal>	DSL.asin(Number number)	The ASIN function.
static @NotNull Field<BigDecimal>	DSL.asin(Field<? extends Number> number)	The ASIN function.
static @NotNull Field<BigDecimal>	DSL.atan(Number number)	The ATAN function.
static @NotNull Field<BigDecimal>	DSL.atan(Field<? extends Number> number)	The ATAN function.
static @NotNull Field<BigDecimal>	DSL.atan2(Number x, Number y)	The ATAN2 function.
static @NotNull Field<BigDecimal>	DSL.atan2(Number x, Field<? extends Number> y)	The ATAN2 function.
static @NotNull Field<BigDecimal>	DSL.atan2(Field<? extends Number> x, Number y)	The ATAN2 function.
static @NotNull Field<BigDecimal>	DSL.atan2(Field<? extends Number> x, Field<? extends Number> y)	The ATAN2 function.
static <T extends Number> @NotNull Field<T>	DSL.bitAnd(Field<T> field1, Field<T> field2)	The bitwise and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitAnd(Field<T> value1, T value2)	The bitwise and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitAnd(T value1, Field<T> value2)	The bitwise and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitAnd(T value1, T value2)	The bitwise and operator.
static @NotNull Field<Integer>	DSL.bitCount(Number value)	The MySQL BIT_COUNT(field) function, counting the number of bits that are set in this number.
static @NotNull Field<Integer>	DSL.bitCount(Field<? extends Number> field)	The MySQL BIT_COUNT(field) function, counting the number of bits that are set in this number.
static @NotNull Field<Integer>	DSL.bitLength(String string)	The BIT_LENGTH function.
static @NotNull Field<Integer>	DSL.bitLength(Field<String> string)	The BIT_LENGTH function.
static <T extends Number> @NotNull Field<T>	DSL.bitNand(Field<T> field1, Field<T> field2)	The bitwise not and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNand(Field<T> value1, T value2)	The bitwise not and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNand(T value1, Field<T> value2)	The bitwise not and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNand(T value1, T value2)	The bitwise not and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNor(Field<T> field1, Field<T> field2)	The bitwise not or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNor(Field<T> value1, T value2)	The bitwise not or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNor(T value1, Field<T> value2)	The bitwise not or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNor(T value1, T value2)	The bitwise not or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNot(Field<T> field)	The bitwise not operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNot(T value)	The bitwise not operator.
static <T extends Number> @NotNull Field<T>	DSL.bitOr(Field<T> field1, Field<T> field2)	The bitwise or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitOr(Field<T> value1, T value2)	The bitwise or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitOr(T value1, Field<T> value2)	The bitwise or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitOr(T value1, T value2)	The bitwise or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXNor(Field<T> field1, Field<T> field2)	The bitwise not xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXNor(Field<T> value1, T value2)	The bitwise not xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXNor(T value1, Field<T> value2)	The bitwise not xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXNor(T value1, T value2)	The bitwise not xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXor(Field<T> field1, Field<T> field2)	The bitwise xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXor(Field<T> value1, T value2)	The bitwise xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXor(T value1, Field<T> value2)	The bitwise xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXor(T value1, T value2)	The bitwise xor operator.
static @NotNull Field<Integer>	DSL.cardinality(Field<? extends Object[]> field)	Calculate the cardinality of an array field.
static <T> @NotNull Field<T>	DSL.cast(Object value, Class<T> type)	Cast a value to another type.
static <T> @NotNull Field<T>	DSL.cast(Object value, DataType<T> type)	Cast a value to another type.
static <T> @NotNull Field<T>	DSL.cast(Object value, Field<T> as)	Cast a value to the type of another field.
static <T> @NotNull Field<T>	DSL.cast(Field<?> field, Class<T> type)	Cast a field to another type.
static <T> @NotNull Field<T>	DSL.cast(Field<?> field, DataType<T> type)	Cast a field to another type.
static <T> @NotNull Field<T>	DSL.cast(Field<?> field, Field<T> as)	Cast a field to the type of another field.
static <T> @NotNull Field<T>	DSL.castNull(Class<T> type)	Cast null to a type.
static <T> @NotNull Field<T>	DSL.castNull(DataType<T> type)	Cast null to a type.
static <T> @NotNull Field<T>	DSL.castNull(Field<T> as)	Cast null to the type of another field.
static <T extends Number> @NotNull Field<T>	DSL.ceil(Field<T> value)	The CEIL function.
static <T extends Number> @NotNull Field<T>	DSL.ceil(T value)	The CEIL function.
static @NotNull Field<Integer>	DSL.century(Temporal value)	Get the century of a date.
static @NotNull Field<Integer>	DSL.century(Date value)	Get the century of a date.
static @NotNull Field<Integer>	DSL.century(Field<?> field)	Get the century of a date.
static @NotNull Field<Integer>	DSL.charLength(String string)	The CHAR_LENGTH function.
static @NotNull Field<Integer>	DSL.charLength(Field<String> string)	The CHAR_LENGTH function.
static <T> @NotNull Field<T>	DSL.choose(int index, Field<T>... values)	The T-SQL CHOOSE() function.
static <T> @NotNull Field<T>	DSL.choose(int index, T... values)	The T-SQL CHOOSE() function.
static <T> @NotNull Field<T>	DSL.choose(Field<Integer> index, Field<T>... values)	The T-SQL CHOOSE() function.
static <T> @NotNull Field<T>	DSL.choose(Field<Integer> index, T... values)	The T-SQL CHOOSE() function.
static @NotNull Field<String>	DSL.chr(Number number)	The CHR function.
static @NotNull Field<String>	DSL.chr(Field<? extends Number> number)	The CHR function.
static <T> @NotNull Field<T>	DSL.coalesce(Field<T> field, Field<?>... fields)	The COALESCE(field1, field2, ...

Methods in org.jooq.impl that return types with arguments of type Field

Modifier and Type	Method	Description
protected Map<Parameter<?>,Field<?>>	AbstractRoutine.getInValues()
protected static List<Field<?>>	DSL.nullSafeList(Field<?>... fields)	Deprecated, for removal: This API element is subject to removal in a future version. - [#11092] - 3.15.0 - This method will be removed without public replacement.
protected static List<Field<?>>	DSL.nullSafeList(Field<?>[] fields, DataType<?> type)	Deprecated, for removal: This API element is subject to removal in a future version. - [#11092] - 3.15.0 - This method will be removed without public replacement.

Methods in org.jooq.impl with parameters of type Field

Modifier and Type	Method	Description
static <T extends Number> @NotNull Field<T>	DSL.abs(Field<T> number)	The ABS function.
static @NotNull Field<BigDecimal>	DSL.acos(Field<? extends Number> number)	The ACOS function.
static <T> @NotNull AggregateFunction<T>	DSL.aggregate(String name, Class<T> type, Field<?>... arguments)	aggregate() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregate(String name, DataType<T> type, Field<?>... arguments)	aggregate() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregate(Name name, Class<T> type, Field<?>... arguments)	aggregate() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregate(Name name, DataType<T> type, Field<?>... arguments)	aggregate() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregateDistinct(String name, Class<T> type, Field<?>... arguments)	aggregateDistinct() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregateDistinct(String name, DataType<T> type, Field<?>... arguments)	aggregateDistinct() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregateDistinct(Name name, Class<T> type, Field<?>... arguments)	aggregateDistinct() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregateDistinct(Name name, DataType<T> type, Field<?>... arguments)	aggregateDistinct() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.all(Field<T[]> array)	Create an ALL quantified select to be used in quantified comparison predicate expressions.
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.all(Field<T>... fields)	Create an ALL quantified select to be used in quantified comparison predicate expressions.
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.any(Field<T[]> array)	Create an ANY quantified select to be used in quantified comparison predicate expressions.
static <T> @NotNull QuantifiedSelect<Record1<T>>	DSL.any(Field<T>... fields)	Create an ANY quantified select to be used in quantified comparison predicate expressions.
static <T> @NotNull AggregateFunction<T>	DSL.anyValue(Field<T> value)	The ANY_VALUE function.
static <T> @NotNull Field<T[]>	DSL.array(Field<T>... fields)	Create an array literal.
static <T> @NotNull ArrayAggOrderByStep<T[]>	DSL.arrayAgg(Field<T> field)	Get the array_agg() aggregate function.
static <T> @NotNull ArrayAggOrderByStep<T[]>	DSL.arrayAggDistinct(Field<T> field)	Get the array_agg() aggregate function.
static <T> @NotNull Field<T>	DSL.arrayGet(Field<T[]> field, int index)	Get an array element at a given index (1 based)
static <T> @NotNull Field<T>	DSL.arrayGet(Field<T[]> field, Field<Integer> index)	Get an array element at a given index (1 based)
static @NotNull Field<Integer>	DSL.ascii(Field<String> string)	The ASCII function.
static @NotNull Field<BigDecimal>	DSL.asin(Field<? extends Number> number)	The ASIN function.
static @NotNull Field<BigDecimal>	DSL.atan(Field<? extends Number> number)	The ATAN function.
static @NotNull Field<BigDecimal>	DSL.atan2(Number x, Field<? extends Number> y)	The ATAN2 function.
static @NotNull Field<BigDecimal>	DSL.atan2(Field<? extends Number> x, Number y)	The ATAN2 function.
static @NotNull Field<BigDecimal>	DSL.atan2(Field<? extends Number> x, Field<? extends Number> y)	The ATAN2 function.
static @NotNull AggregateFunction<BigDecimal>	DSL.avg(Field<? extends Number> field)	Get the average over a numeric field: avg(field).
static @NotNull AggregateFunction<BigDecimal>	DSL.avgDistinct(Field<? extends Number> field)	Get the average over a numeric field: avg(distinct field).
static <T extends Number> @NotNull Field<T>	DSL.bitAnd(Field<T> field1, Field<T> field2)	The bitwise and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitAnd(Field<T> value1, T value2)	The bitwise and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitAnd(T value1, Field<T> value2)	The bitwise and operator.
static <T extends Number> @NotNull AggregateFunction<T>	DSL.bitAndAgg(Field<T> value)	The BIT_AND_AGG function.
static @NotNull Field<Integer>	DSL.bitCount(Field<? extends Number> field)	The MySQL BIT_COUNT(field) function, counting the number of bits that are set in this number.
static @NotNull Field<Integer>	DSL.bitLength(Field<String> string)	The BIT_LENGTH function.
static <T extends Number> @NotNull Field<T>	DSL.bitNand(Field<T> field1, Field<T> field2)	The bitwise not and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNand(Field<T> value1, T value2)	The bitwise not and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNand(T value1, Field<T> value2)	The bitwise not and operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNor(Field<T> field1, Field<T> field2)	The bitwise not or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNor(Field<T> value1, T value2)	The bitwise not or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNor(T value1, Field<T> value2)	The bitwise not or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitNot(Field<T> field)	The bitwise not operator.
static <T extends Number> @NotNull Field<T>	DSL.bitOr(Field<T> field1, Field<T> field2)	The bitwise or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitOr(Field<T> value1, T value2)	The bitwise or operator.
static <T extends Number> @NotNull Field<T>	DSL.bitOr(T value1, Field<T> value2)	The bitwise or operator.
static <T extends Number> @NotNull AggregateFunction<T>	DSL.bitOrAgg(Field<T> value)	The BIT_OR_AGG function.
static <T extends Number> @NotNull Field<T>	DSL.bitXNor(Field<T> field1, Field<T> field2)	The bitwise not xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXNor(Field<T> value1, T value2)	The bitwise not xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXNor(T value1, Field<T> value2)	The bitwise not xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXor(Field<T> field1, Field<T> field2)	The bitwise xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXor(Field<T> value1, T value2)	The bitwise xor operator.
static <T extends Number> @NotNull Field<T>	DSL.bitXor(T value1, Field<T> value2)	The bitwise xor operator.
static <T extends Number> @NotNull AggregateFunction<T>	DSL.bitXorAgg(Field<T> value)	The BIT_XOR_AGG function.
static @NotNull AggregateFunction<Boolean>	DSL.boolAnd(Field<Boolean> field)	Get the every value over a field: bool_and(field).
static @NotNull AggregateFunction<Boolean>	DSL.boolOr(Field<Boolean> field)	Get the every value over a field: bool_and(field).
static @NotNull Field<Integer>	DSL.cardinality(Field<? extends Object[]> field)	Calculate the cardinality of an array field.
static <V> @NotNull CaseValueStep<V>	DSL.case_(Field<V> value)	Initialise a Case statement.
static <T> @NotNull Field<T>	DSL.cast(Object value, Field<T> as)	Cast a value to the type of another field.
static <T> @NotNull Field<T>	DSL.cast(Field<?> field, Class<T> type)	Cast a field to another type.
static <T> @NotNull Field<T>	DSL.cast(Field<?> field, DataType<T> type)	Cast a field to another type.
static <T> @NotNull Field<T>	DSL.cast(Field<?> field, Field<T> as)	Cast a field to the type of another field.
static <T> @NotNull Field<T>	DSL.castNull(Field<T> as)	Cast null to the type of another field.
static <T extends Number> @NotNull Field<T>	DSL.ceil(Field<T> value)	The CEIL function.
static @NotNull Field<Integer>	DSL.century(Field<?> field)	Get the century of a date.
static @NotNull Field<Integer>	DSL.charLength(Field<String> string)	The CHAR_LENGTH function.
static <T> @NotNull Field<T>	DSL.choose(int index, Field<T>... values)	The T-SQL CHOOSE() function.
static <T> @NotNull Field<T>	DSL.choose(Field<Integer> index, Field<T>... values)	The T-SQL CHOOSE() function.
static <T> @NotNull Field<T>	DSL.choose(Field<Integer> index, T... values)	The T-SQL CHOOSE() function.
static <V> @NotNull CaseValueStep<V>	DSL.choose(Field<V> value)	Initialise a Case statement.
static @NotNull Field<String>	DSL.chr(Field<? extends Number> number)	The CHR function.
static <T> @NotNull Field<T>	DSL.coalesce(Field<T> field, Field<?>... fields)	The COALESCE(field1, field2, ...

Method parameters in org.jooq.impl with type arguments of type Field

Modifier and Type	Method	Description
static <T> @NotNull Field<T[]>	DSL.array(Collection<? extends Field<T>> fields)	Create an array literal.
static @NotNull Condition	DSL.condition(Map<Field<?>,?> map)	Create a condition from a map.
CreateViewAsStep<Record>	DefaultDSLContext.createOrReplaceView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createOrReplaceView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createOrReplaceView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createOrReplaceView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
static @NotNull CreateViewAsStep	DSL.createOrReplaceView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
static @NotNull CreateViewAsStep	DSL.createOrReplaceView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
static @NotNull CreateViewAsStep	DSL.createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
static @NotNull CreateViewAsStep	DSL.createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
CreateViewAsStep<Record>	DefaultDSLContext.createView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
static @NotNull CreateViewAsStep	DSL.createView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
static @NotNull CreateViewAsStep	DSL.createView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
static @NotNull CreateViewAsStep	DSL.createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
static @NotNull CreateViewAsStep	DSL.createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
CreateViewAsStep<Record>	DefaultDSLContext.createViewIfNotExists(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createViewIfNotExists(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createViewIfNotExists(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createViewIfNotExists(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>	DefaultDSLContext.createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
static @NotNull CreateViewAsStep	DSL.createViewIfNotExists(String view, Function<? super Field<?>,? extends String> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
static @NotNull CreateViewAsStep	DSL.createViewIfNotExists(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
static @NotNull CreateViewAsStep	DSL.createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
static @NotNull CreateViewAsStep	DSL.createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
static @NotNull OrderedAggregateFunction<BigDecimal>	DSL.cumeDist(Collection<? extends Field<?>> fields)	The cume_dist(expr) within group (order by [order clause]) ordered-set aggregate function.
static @NotNull OrderedAggregateFunction<Integer>	DSL.denseRank(Collection<? extends Field<?>> fields)	The dense_rank(expr) within group (order by [order clause]) ordered-set aggregate function.
static @NotNull ConstraintForeignKeyReferencesStepN	DSL.foreignKey(Collection<? extends Field<?>> fields)	Add a FOREIGN KEY clause to the CONSTRAINT.
int	TableRecordImpl.insert(Collection<? extends Field<?>> storeFields)
<R extends Record> InsertValuesStepN<R>	DefaultDSLContext.insertInto(Table<R> into, Collection<? extends Field<?>> fields)
static <R extends Record> @NotNull InsertValuesStepN<R>	DSL.insertInto(Table<R> into, Collection<? extends Field<?>> fields)	Create a new DSL insert statement.
static @NotNull JSONArrayNullStep<JSON>	DSL.jsonArray(Collection<? extends Field<?>> fields)	The JSON_ARRAY function.
static @NotNull JSONArrayNullStep<JSONB>	DSL.jsonbArray(Collection<? extends Field<?>> fields)	The JSONB_ARRAY function.
int	UpdatableRecordImpl.merge(Collection<? extends Field<?>> storeFields)
<R extends Record> MergeKeyStepN<R>	DefaultDSLContext.mergeInto(Table<R> table, Collection<? extends Field<?>> fields)
static <R extends Record> @NotNull MergeKeyStepN<R>	DSL.mergeInto(Table<R> table, Collection<? extends Field<?>> fields)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSL.mergeInto(Table)
static @NotNull ArrayAggOrderByStep<Result<Record>>	DSL.multisetAgg(Collection<? extends Field<?>> fields)	Get the MULTISET_AGG aggregate function to nest group contents.
Record	DefaultDSLContext.newRecord(Collection<? extends Field<?>> fields)
Result<Record>	DefaultDSLContext.newResult(Collection<? extends Field<?>> fields)
CallbackParseListener	CallbackParseListener.onParseField(Function<? super ParseContext,? extends Field<?>> newOnParseField)
static @NotNull WindowSpecificationOrderByStep	DSL.partitionBy(Collection<? extends Field<?>> fields)	Create a WindowSpecification with a PARTITION BY clause.
static @NotNull OrderedAggregateFunction<Integer>	DSL.percentRank(Collection<? extends Field<?>> fields)	The percent_rank(expr) within group (order by [order clause]) ordered-set aggregate function.
static @NotNull ConstraintEnforcementStep	DSL.primaryKey(Collection<? extends Field<?>> fields)	Create an unnamed (system named) PRIMARY KEY constraint.
static @NotNull OrderedAggregateFunction<Integer>	DSL.rank(Collection<? extends Field<?>> fields)	The rank(expr) within group (order by [order clause]) ordered-set aggregate function.
static <T1> @NotNull RecordType<Record>	DSL.recordType(Collection<? extends Field<?>> fields)	Create a RecordType of an arbitrary degree.
void	UpdatableRecordImpl.refresh(Collection<? extends Field<?>> refreshFields)
int	UpdatableRecordImpl.store(Collection<? extends Field<?>> storeFields)
static @NotNull ConstraintEnforcementStep	DSL.unique(Collection<? extends Field<?>> fields)	Create an unnamed (system named) UNIQUE constraint.
int	UpdatableRecordImpl.update(Collection<? extends Field<?>> storeFields)
WithAsStep	DefaultDSLContext.with(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
WithAsStep	DefaultDSLContext.with(String alias, Function<? super Field<?>,? extends String> fieldNameFunction)
static @NotNull WithAsStep	DSL.with(String alias, Function<? super Field<?>,? extends String> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
WithAsStep	DefaultDSLContext.withRecursive(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
WithAsStep	DefaultDSLContext.withRecursive(String alias, Function<? super Field<?>,? extends String> fieldNameFunction)
static @NotNull WithAsStep	DSL.withRecursive(String alias, Function<? super Field<?>,? extends String> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
static @NotNull XMLAttributes	DSL.xmlattributes(Collection<? extends Field<?>> attributes)	The XML attributes constructor.
static @NotNull Field<XML>	DSL.xmlconcat(Collection<? extends Field<?>> fields)	The XML concat function.
static @NotNull Field<XML>	DSL.xmlelement(String name, Collection<? extends Field<?>> content)	The XML element constructor.
static @NotNull Field<XML>	DSL.xmlelement(String name, XMLAttributes attributes, Collection<? extends Field<?>> content)	The XML element constructor.
static @NotNull Field<XML>	DSL.xmlelement(Name name, Collection<? extends Field<?>> content)	The XML element constructor.
static @NotNull Field<XML>	DSL.xmlelement(Name name, XMLAttributes attributes, Collection<? extends Field<?>> content)	The XML element constructor.
static @NotNull Field<XML>	DSL.xmlforest(Collection<? extends Field<?>> fields)	The XMLFOREST function.

Constructors in org.jooq.impl with parameters of type Field

Modifier	Constructor	Description
	EmbeddableRecordImpl(Field<?>... fields)	Deprecated. - [#11058] - 3.14.5 - Please re-generate your code.
	TableImpl(String name, Schema schema, Table<R> aliased, Field<?>[] parameters)	Deprecated. - 3.10 - [#5996] - Use TableImpl(Name, Schema, Table, Field[]) instead (or re-generated your code).
	TableImpl(String name, Schema schema, Table<R> aliased, Field<?>[] parameters, String comment)	Deprecated. - 3.10 - [#5996] - Use TableImpl(Name, Schema, Table, Field[], String) instead (or re-generated your code).
	TableImpl(Name name, Schema schema, Table<?> child, ForeignKey<?,R> path, Table<R> aliased, Field<?>[] parameters, Comment comment)
	TableImpl(Name name, Schema schema, Table<?> child, ForeignKey<?,R> path, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options)
	TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters)
	TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, String comment)	Deprecated. - 3.11 - [#7027] - Use TableImpl(Name, Schema, Table, Field[], Comment) instead.
	TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, Comment comment)
	TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options)

Uses of Field in org.jooq.tools

Methods in org.jooq.tools with parameters of type Field

Modifier and Type	Method	Description
static Object[]	Convert.convert(Object[] values, Field<?>[] fields)	Deprecated, for removal: This API element is subject to removal in a future version. Convert an array of values to a matching data type

Uses of Field in org.jooq.util.cubrid

Methods in org.jooq.util.cubrid that return Field

Modifier and Type	Method	Description
static <T> Field<T>	CUBRIDDSL.decr(Field<T> field)	Deprecated, for removal: This API element is subject to removal in a future version. Use the CUBRID-specific DECR() function.
static <T> Field<T>	CUBRIDDSL.incr(Field<T> field)	Deprecated, for removal: This API element is subject to removal in a future version. Use the CUBRID-specific INCR() function.

Methods in org.jooq.util.cubrid with parameters of type Field

Modifier and Type	Method	Description
static <T> Field<T>	CUBRIDDSL.decr(Field<T> field)	Deprecated, for removal: This API element is subject to removal in a future version. Use the CUBRID-specific DECR() function.
static <T> Field<T>	CUBRIDDSL.incr(Field<T> field)	Deprecated, for removal: This API element is subject to removal in a future version. Use the CUBRID-specific INCR() function.

Uses of Field in org.jooq.util.mariadb

Methods in org.jooq.util.mariadb that return Field

Modifier and Type	Method	Description
static Field<String>	MariaDBDSL.aesDecrypt(String cryptString, String keyString)	Get the MariaDB-specific AES_DECRYPT() function
static Field<String>	MariaDBDSL.aesDecrypt(Field<String> cryptString, Field<String> keyString)	Get the MariaDB-specific AES_DECRYPT() function
static Field<String>	MariaDBDSL.aesEncrypt(String string, String keyString)	Get the MariaDB-specific AES_ENCRYPT() function
static Field<String>	MariaDBDSL.aesEncrypt(Field<String> string, Field<String> keyString)	Get the MariaDB-specific AES_ENCRYPT() function
static Field<String>	MariaDBDSL.compress(String string)	Get the MariaDB-specific COMPRESS() function
static Field<String>	MariaDBDSL.compress(Field<String> string)	Get the MariaDB-specific COMPRESS() function
static Field<String>	MariaDBDSL.decode(String cryptString, String keyString)	Get the MariaDB-specific DECODE() function
static Field<String>	MariaDBDSL.decode(Field<String> cryptString, Field<String> keyString)	Get the MariaDB-specific DECODE() function
static Field<String>	MariaDBDSL.desDecrypt(String cryptString)	Get the MariaDB-specific DES_DECRYPT() function
static Field<String>	MariaDBDSL.desDecrypt(String cryptString, String keyString)	Get the MariaDB-specific DES_DECRYPT() function
static Field<String>	MariaDBDSL.desDecrypt(Field<String> cryptString)	Get the MariaDB-specific DES_DECRYPT() function
static Field<String>	MariaDBDSL.desDecrypt(Field<String> cryptString, Field<String> keyString)	Get the MariaDB-specific DES_DECRYPT() function
static Field<String>	MariaDBDSL.desEncrypt(String string)	Get the MariaDB-specific DES_ENCRYPT() function
static Field<String>	MariaDBDSL.desEncrypt(String string, String keyString)	Get the MariaDB-specific DES_ENCRYPT() function
static Field<String>	MariaDBDSL.desEncrypt(Field<String> string)	Get the MariaDB-specific DES_ENCRYPT() function
static Field<String>	MariaDBDSL.desEncrypt(Field<String> string, Field<String> keyString)	Get the MariaDB-specific DES_ENCRYPT() function
static Field<String>	MariaDBDSL.encode(String string, String keyString)	Get the MariaDB-specific ENCODE() function
static Field<String>	MariaDBDSL.encode(Field<String> string, Field<String> keyString)	Get the MariaDB-specific ENCODE() function
static Field<String>	MariaDBDSL.password(String string)	Get the MariaDB-specific PASSWORD() function
static Field<String>	MariaDBDSL.password(Field<String> string)	Get the MariaDB-specific PASSWORD() function
static Field<String>	MariaDBDSL.sha1(String string)	Get the MariaDB-specific SHA1() function
static Field<String>	MariaDBDSL.sha1(Field<String> string)	Get the MariaDB-specific SHA1() function
static Field<String>	MariaDBDSL.uncompress(String string)	Get the MariaDB-specific UNCOMPRESS() function
static Field<String>	MariaDBDSL.uncompress(Field<String> string)	Get the MariaDB-specific UNCOMPRESS() function
static Field<Integer>	MariaDBDSL.uncompressedLength(String string)	Get the MariaDB-specific UNCOMPRESSED_LENGTH() function
static Field<Integer>	MariaDBDSL.uncompressedLength(Field<String> string)	Get the MariaDB-specific UNCOMPRESSED_LENGTH() function

Methods in org.jooq.util.mariadb with parameters of type Field

Modifier and Type	Method	Description
static Field<String>	MariaDBDSL.aesDecrypt(Field<String> cryptString, Field<String> keyString)	Get the MariaDB-specific AES_DECRYPT() function
static Field<String>	MariaDBDSL.aesEncrypt(Field<String> string, Field<String> keyString)	Get the MariaDB-specific AES_ENCRYPT() function
static Field<String>	MariaDBDSL.compress(Field<String> string)	Get the MariaDB-specific COMPRESS() function
static Field<String>	MariaDBDSL.decode(Field<String> cryptString, Field<String> keyString)	Get the MariaDB-specific DECODE() function
static Field<String>	MariaDBDSL.desDecrypt(Field<String> cryptString)	Get the MariaDB-specific DES_DECRYPT() function
static Field<String>	MariaDBDSL.desDecrypt(Field<String> cryptString, Field<String> keyString)	Get the MariaDB-specific DES_DECRYPT() function
static Field<String>	MariaDBDSL.desEncrypt(Field<String> string)	Get the MariaDB-specific DES_ENCRYPT() function
static Field<String>	MariaDBDSL.desEncrypt(Field<String> string, Field<String> keyString)	Get the MariaDB-specific DES_ENCRYPT() function
static Field<String>	MariaDBDSL.encode(Field<String> string, Field<String> keyString)	Get the MariaDB-specific ENCODE() function
static Field<String>	MariaDBDSL.password(Field<String> string)	Get the MariaDB-specific PASSWORD() function
static Field<String>	MariaDBDSL.sha1(Field<String> string)	Get the MariaDB-specific SHA1() function
static Field<String>	MariaDBDSL.uncompress(Field<String> string)	Get the MariaDB-specific UNCOMPRESS() function
static Field<Integer>	MariaDBDSL.uncompressedLength(Field<String> string)	Get the MariaDB-specific UNCOMPRESSED_LENGTH() function

Uses of Field in org.jooq.util.mysql

Methods in org.jooq.util.mysql that return Field

Modifier and Type	Method	Description
static @NotNull Field<byte[]>	MySQLDSL.aesDecrypt(byte[] cryptString, byte[] keyString)	Get the MySQL-specific AES_DECRYPT() function.
static @NotNull Field<String>	MySQLDSL.aesDecrypt(String cryptString, String keyString)	Get the MySQL-specific AES_DECRYPT() function.
static <T> @NotNull Field<T>	MySQLDSL.aesDecrypt(Field<T> cryptString, Field<T> keyString)	Get the MySQL-specific AES_DECRYPT() function.
static @NotNull Field<byte[]>	MySQLDSL.aesEncrypt(byte[] string, byte[] keyString)	Get the MySQL-specific AES_ENCRYPT() function.
static @NotNull Field<String>	MySQLDSL.aesEncrypt(String string, String keyString)	Get the MySQL-specific AES_ENCRYPT() function.
static <T> @NotNull Field<T>	MySQLDSL.aesEncrypt(Field<T> string, Field<T> keyString)	Get the MySQL-specific AES_ENCRYPT() function.
static @NotNull Field<byte[]>	MySQLDSL.compress(byte[] string)	Get the MySQL-specific COMPRESS() function.
static @NotNull Field<String>	MySQLDSL.compress(String string)	Get the MySQL-specific COMPRESS() function.
static <T> @NotNull Field<T>	MySQLDSL.compress(Field<T> string)	Get the MySQL-specific COMPRESS() function.
static @NotNull Field<byte[]>	MySQLDSL.decode(byte[] cryptString, byte[] keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<String>	MySQLDSL.decode(String cryptString, String keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.decode(Field<T> cryptString, Field<T> keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<byte[]>	MySQLDSL.desDecrypt(byte[] cryptString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<byte[]>	MySQLDSL.desDecrypt(byte[] cryptString, byte[] keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<String>	MySQLDSL.desDecrypt(String cryptString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<String>	MySQLDSL.desDecrypt(String cryptString, String keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.desDecrypt(Field<T> cryptString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.desDecrypt(Field<T> cryptString, Field<T> keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<byte[]>	MySQLDSL.desEncrypt(byte[] string)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<byte[]>	MySQLDSL.desEncrypt(byte[] string, byte[] keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<String>	MySQLDSL.desEncrypt(String string)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<String>	MySQLDSL.desEncrypt(String string, String keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.desEncrypt(Field<T> string)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.desEncrypt(Field<T> string, Field<T> keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<byte[]>	MySQLDSL.encode(byte[] string, byte[] keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<String>	MySQLDSL.encode(String string, String keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.encode(Field<T> string, Field<T> keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<byte[]>	MySQLDSL.password(byte[] string)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<String>	MySQLDSL.password(String string)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.password(Field<T> string)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static @NotNull Field<byte[]>	MySQLDSL.sha1(byte[] string)	Get the MySQL-specific SHA1() function.
static @NotNull Field<String>	MySQLDSL.sha1(String string)	Get the MySQL-specific SHA1() function.
static <T> @NotNull Field<T>	MySQLDSL.sha1(Field<T> string)	Get the MySQL-specific SHA1() function.
static @NotNull Field<byte[]>	MySQLDSL.sha2(byte[] string, int hashLength)	Get the MySQL-specific SHA2() function.
static @NotNull Field<String>	MySQLDSL.sha2(String string, int hashLength)	Get the MySQL-specific SHA2() function.
static <T> @NotNull Field<T>	MySQLDSL.sha2(Field<T> string, Field<Integer> hashLength)	Get the MySQL-specific SHA2() function.
static @NotNull Field<byte[]>	MySQLDSL.uncompress(byte[] string)	Get the MySQL-specific UNCOMPRESS() function.
static @NotNull Field<String>	MySQLDSL.uncompress(String string)	Get the MySQL-specific UNCOMPRESS() function.
static <T> @NotNull Field<T>	MySQLDSL.uncompress(Field<T> string)	Get the MySQL-specific UNCOMPRESS() function.
static @NotNull Field<Integer>	MySQLDSL.uncompressedLength(byte[] string)	Get the MySQL-specific UNCOMPRESSED_LENGTH() function.
static @NotNull Field<Integer>	MySQLDSL.uncompressedLength(String string)	Get the MySQL-specific UNCOMPRESSED_LENGTH() function.
static <T> @NotNull Field<Integer>	MySQLDSL.uncompressedLength(Field<T> string)	Get the MySQL-specific UNCOMPRESSED_LENGTH() function.
static <T> @NotNull Field<T>	MySQLDSL.values(Field<T> values)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#12099] - MySQL 8.0.20 has deprecated this clause and replaced it by something new, which we'll support soon, see https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html/ and https://github.com/jOOQ/jOOQ/issues/12099

Methods in org.jooq.util.mysql with parameters of type Field

Modifier and Type	Method	Description
static <T> @NotNull Field<T>	MySQLDSL.aesDecrypt(Field<T> cryptString, Field<T> keyString)	Get the MySQL-specific AES_DECRYPT() function.
static <T> @NotNull Field<T>	MySQLDSL.aesEncrypt(Field<T> string, Field<T> keyString)	Get the MySQL-specific AES_ENCRYPT() function.
static <T> @NotNull Field<T>	MySQLDSL.compress(Field<T> string)	Get the MySQL-specific COMPRESS() function.
static <T> @NotNull Field<T>	MySQLDSL.decode(Field<T> cryptString, Field<T> keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.desDecrypt(Field<T> cryptString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.desDecrypt(Field<T> cryptString, Field<T> keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.desEncrypt(Field<T> string)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.desEncrypt(Field<T> string, Field<T> keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.encode(Field<T> string, Field<T> keyString)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.password(Field<T> string)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
static <T> @NotNull Field<T>	MySQLDSL.sha1(Field<T> string)	Get the MySQL-specific SHA1() function.
static <T> @NotNull Field<T>	MySQLDSL.sha2(Field<T> string, Field<Integer> hashLength)	Get the MySQL-specific SHA2() function.
static <T> @NotNull Field<T>	MySQLDSL.uncompress(Field<T> string)	Get the MySQL-specific UNCOMPRESS() function.
static <T> @NotNull Field<Integer>	MySQLDSL.uncompressedLength(Field<T> string)	Get the MySQL-specific UNCOMPRESSED_LENGTH() function.
static <T> @NotNull Field<T>	MySQLDSL.values(Field<T> values)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.15.0 - [#12099] - MySQL 8.0.20 has deprecated this clause and replaced it by something new, which we'll support soon, see https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html/ and https://github.com/jOOQ/jOOQ/issues/12099

Uses of Field in org.jooq.util.oracle

Methods in org.jooq.util.oracle that return Field

Modifier and Type	Method	Description
static @NotNull Field<BigDecimal>	OracleDSL.catsearch(Field<String> field, String textQuery, String structuredQuery)	The Oracle-Text specific CATSEARCH function.
static @NotNull Field<BigDecimal>	OracleDSL.contains(Field<String> field, String query)	The Oracle-Text specific CONTAINS function.
static @NotNull Field<BigDecimal>	OracleDSL.contains(Field<String> field, String query, int label)	The Oracle-Text specific CONTAINS function.
static @NotNull Field<BigDecimal>	OracleDSL.matches(Field<String> field, String query)	The Oracle-Text specific MATCHES function.
static @NotNull Field<BigDecimal>	OracleDSL.matches(Field<String> field, String query, int label)	The Oracle-Text specific CONTAINS function.
static @NotNull Field<BigDecimal>	OracleDSL.matchScore(int label)	The Oracle-Text specific MATCH_SCORE function.
static @NotNull Field<Long>	OracleDSL.oraRowscn()	The Oracle-specific ORA_ROWSCN pseudo-field.
static @NotNull Field<String>	OracleDSL.rowid()	The Oracle-specific ROWID pseudo-field.
static @NotNull Field<Integer>	OracleDSL.rownum()	The Oracle-specific ROWNUM pseudo-field.
static @NotNull Field<Long>	OracleDSL.rowscn()	The Oracle-specific ORA_ROWSCN pseudo-field.
static @NotNull Field<Timestamp>	OracleDSL.scnToTimestamp(Number scn)	The Oracle-specific SCN_TO_TIMESTAMP function.
static @NotNull Field<Timestamp>	OracleDSL.scnToTimestamp(Field<? extends Number> scn)	The Oracle-specific SCN_TO_TIMESTAMP function.
static @NotNull Field<BigDecimal>	OracleDSL.score(int label)	The Oracle-Text specific SCORE function.
static @NotNull Field<String>	OracleDSL.sysContext(String namespace, String parameter)	The Oracle-specific SYS_CONTEXT function.
static @NotNull Field<String>	OracleDSL.sysContext(String namespace, String parameter, int length)	The Oracle-specific SYS_CONTEXT function.
static @NotNull Field<Long>	OracleDSL.timestampToScn(Date timestamp)	The Oracle-specific TIMESTAMP_TO_SCN function.
static @NotNull Field<Long>	OracleDSL.timestampToScn(Field<? extends Date> scn)	The Oracle-specific TIMESTAMP_TO_SCN function.
static @NotNull Field<String>	OracleDSL.toChar(Object value)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	OracleDSL.toChar(Object value, String formatMask)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	OracleDSL.toChar(Object value, Field<String> formatMask)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	OracleDSL.toChar(Field<?> value)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	OracleDSL.toChar(Field<?> value, String formatMask)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	OracleDSL.toChar(Field<?> value, Field<String> formatMask)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(String value)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(String value, String formatMask)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(String value, Field<String> formatMask)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(Field<String> value)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(Field<String> value, String formatMask)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(Field<String> value, Field<String> formatMask)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<Long>	OracleDSL.versionsEndscn()	The Oracle-specific VERSIONS_ENDSCN pseudo-field.
static @NotNull Field<Timestamp>	OracleDSL.versionsEndtime()	The Oracle-specific VERSIONS_ENDTIME pseudo-field.
static @NotNull Field<String>	OracleDSL.versionsOperation()	The Oracle-specific VERSIONS_OPERATION pseudo-field.
static @NotNull Field<Long>	OracleDSL.versionsStartscn()	The Oracle-specific VERSIONS_STARTSCN pseudo-field.
static @NotNull Field<Timestamp>	OracleDSL.versionsStarttime()	The Oracle-specific VERSIONS_STARTTIME pseudo-field.
static @NotNull Field<String>	OracleDSL.versionsXid()	The Oracle-specific VERSIONS_XID pseudo-field.

Methods in org.jooq.util.oracle with parameters of type Field

Modifier and Type	Method	Description
static @NotNull Field<BigDecimal>	OracleDSL.catsearch(Field<String> field, String textQuery, String structuredQuery)	The Oracle-Text specific CATSEARCH function.
static @NotNull Field<BigDecimal>	OracleDSL.contains(Field<String> field, String query)	The Oracle-Text specific CONTAINS function.
static @NotNull Field<BigDecimal>	OracleDSL.contains(Field<String> field, String query, int label)	The Oracle-Text specific CONTAINS function.
static @NotNull Field<BigDecimal>	OracleDSL.matches(Field<String> field, String query)	The Oracle-Text specific MATCHES function.
static @NotNull Field<BigDecimal>	OracleDSL.matches(Field<String> field, String query, int label)	The Oracle-Text specific CONTAINS function.
static @NotNull Field<Timestamp>	OracleDSL.scnToTimestamp(Field<? extends Number> scn)	The Oracle-specific SCN_TO_TIMESTAMP function.
static @NotNull Field<Long>	OracleDSL.timestampToScn(Field<? extends Date> scn)	The Oracle-specific TIMESTAMP_TO_SCN function.
static @NotNull Field<String>	OracleDSL.toChar(Object value, Field<String> formatMask)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	OracleDSL.toChar(Field<?> value)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	OracleDSL.toChar(Field<?> value, String formatMask)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	OracleDSL.toChar(Field<?> value, Field<String> formatMask)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(String value, Field<String> formatMask)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(Field<String> value)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(Field<String> value, String formatMask)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	OracleDSL.toNumber(Field<String> value, Field<String> formatMask)	The Oracle-specific TO_NUMBER function.

Uses of Field in org.jooq.util.postgres

Methods in org.jooq.util.postgres that return Field

Modifier and Type	Method	Description
static <T> @NotNull Field<T[]>	PostgresDSL.arrayAppend(Field<T[]> array, Field<T> value)	The PostgreSQL array_append(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayAppend(Field<T[]> array, T value)	The PostgreSQL array_append(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayAppend(T[] array, Field<T> value)	The PostgreSQL array_append(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayAppend(T[] array, T value)	The PostgreSQL array_append(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayCat(Field<T[]> array1, Field<T[]> array2)	The PostgreSQL array_cat(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayCat(Field<T[]> array1, T[] array2)	The PostgreSQL array_cat(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayCat(T[] array1, Field<T[]> array2)	The PostgreSQL array_cat(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayCat(T[] array1, T[] array2)	The PostgreSQL array_cat(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(Field<T> value, Integer[] dimensions)	The PostgreSQL array_fill(anyelement, int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(Field<T> value, Integer[] dimensions, Integer[] bounds)	The PostgreSQL array_fill(anyelement, int[], int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(Field<T> value, Field<Integer[]> dimensions)	The PostgreSQL array_fill(anyelement, int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(Field<T> value, Field<Integer[]> dimensions, Field<Integer[]> bounds)	The PostgreSQL array_fill(anyelement, int[], int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(T value, Integer[] dimensions)	The PostgreSQL array_fill(anyelement, int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(T value, Integer[] dimensions, Integer[] bounds)	The PostgreSQL array_fill(anyelement, int[], int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(T value, Field<Integer[]> dimensions)	The PostgreSQL array_fill(anyelement, int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(T value, Field<Integer[]> dimensions, Field<Integer[]> bounds)	The PostgreSQL array_fill(anyelement, int[], int[]) function.
static @NotNull Field<Integer>	PostgresDSL.arrayLength(Object[] array)	The PostgreSQL array_length(anyarray, int) function.
static @NotNull Field<Integer>	PostgresDSL.arrayLength(Field<? extends Object[]> array)	The PostgreSQL array_length(anyarray, int) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayPrepend(Field<T> value, Field<T[]> array)	The PostgreSQL array_prepend(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayPrepend(Field<T> value, T[] array)	The PostgreSQL array_prepend(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayPrepend(T value, Field<T[]> array)	The PostgreSQL array_prepend(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayPrepend(T value, T[] array)	The PostgreSQL array_prepend(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayRemove(Field<T[]> array, Field<T> element)	The PostgreSQL array_remove(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayRemove(Field<T[]> array, T element)	The PostgreSQL array_remove(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayRemove(T[] array, Field<T> element)	The PostgreSQL array_remove(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayRemove(T[] array, T element)	The PostgreSQL array_remove(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayReplace(Field<T[]> array, Field<T> search, Field<T> replace)	The PostgreSQL array_replace(anyarray, anyelement, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayReplace(Field<T[]> array, T search, T replace)	The PostgreSQL array_replace(anyarray, anyelement, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayReplace(T[] array, Field<T> search, Field<T> replace)	The PostgreSQL array_replace(anyarray, anyelement, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayReplace(T[] array, T search, T replace)	The PostgreSQL array_replace(anyarray, anyelement, anyelement) function.
static @NotNull Field<String>	PostgresDSL.arrayToString(Object[] array, String delimiter)	The PostgreSQL array_to_string(anyarray, delimiter) function.
static @NotNull Field<String>	PostgresDSL.arrayToString(Object[] array, Field<String> delimiter)	The PostgreSQL array_to_string(anyarray, delimiter) function.
static @NotNull Field<String>	PostgresDSL.arrayToString(Field<? extends Object[]> array, String delimiter)	The PostgreSQL array_to_string(anyarray, delimiter) function.
static @NotNull Field<String>	PostgresDSL.arrayToString(Field<? extends Object[]> array, Field<String> delimiter)	The PostgreSQL array_to_string(anyarray, delimiter) function.
static @NotNull Field<Long>	PostgresDSL.oid(Table<?> table)	Get the PostgreSQL-specific [table].oid column from any table.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(String string, String delimiter)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(String string, String delimiter, String nullString)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(String string, Field<String> delimiter)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(String string, Field<String> delimiter, Field<String> nullString)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(Field<String> string, String delimiter)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(Field<String> string, String delimiter, String nullString)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(Field<String> string, Field<String> delimiter)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(Field<String> string, Field<String> delimiter, Field<String> nullString)	The PostgreSQL string_to_array(anyarray, delimiter) function.

Methods in org.jooq.util.postgres with parameters of type Field

Modifier and Type	Method	Description
static <T> @NotNull Field<T[]>	PostgresDSL.arrayAppend(Field<T[]> array, Field<T> value)	The PostgreSQL array_append(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayAppend(Field<T[]> array, T value)	The PostgreSQL array_append(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayAppend(T[] array, Field<T> value)	The PostgreSQL array_append(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayCat(Field<T[]> array1, Field<T[]> array2)	The PostgreSQL array_cat(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayCat(Field<T[]> array1, T[] array2)	The PostgreSQL array_cat(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayCat(T[] array1, Field<T[]> array2)	The PostgreSQL array_cat(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(Field<T> value, Integer[] dimensions)	The PostgreSQL array_fill(anyelement, int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(Field<T> value, Integer[] dimensions, Integer[] bounds)	The PostgreSQL array_fill(anyelement, int[], int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(Field<T> value, Field<Integer[]> dimensions)	The PostgreSQL array_fill(anyelement, int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(Field<T> value, Field<Integer[]> dimensions, Field<Integer[]> bounds)	The PostgreSQL array_fill(anyelement, int[], int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(T value, Field<Integer[]> dimensions)	The PostgreSQL array_fill(anyelement, int[]) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayFill(T value, Field<Integer[]> dimensions, Field<Integer[]> bounds)	The PostgreSQL array_fill(anyelement, int[], int[]) function.
static @NotNull Field<Integer>	PostgresDSL.arrayLength(Field<? extends Object[]> array)	The PostgreSQL array_length(anyarray, int) function.
static <T> @NotNull Condition	PostgresDSL.arrayOverlap(Field<T[]> left, Field<T[]> right)	The PostgreSQL array1 && array2 overlap operator.
static <T> @NotNull Condition	PostgresDSL.arrayOverlap(Field<T[]> left, T[] right)	The PostgreSQL array1 && array2 overlap operator.
static <T> @NotNull Condition	PostgresDSL.arrayOverlap(T[] left, Field<T[]> right)	The PostgreSQL array1 && array2 overlap operator.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayPrepend(Field<T> value, Field<T[]> array)	The PostgreSQL array_prepend(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayPrepend(Field<T> value, T[] array)	The PostgreSQL array_prepend(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayPrepend(T value, Field<T[]> array)	The PostgreSQL array_prepend(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayRemove(Field<T[]> array, Field<T> element)	The PostgreSQL array_remove(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayRemove(Field<T[]> array, T element)	The PostgreSQL array_remove(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayRemove(T[] array, Field<T> element)	The PostgreSQL array_remove(anyarray, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayReplace(Field<T[]> array, Field<T> search, Field<T> replace)	The PostgreSQL array_replace(anyarray, anyelement, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayReplace(Field<T[]> array, T search, T replace)	The PostgreSQL array_replace(anyarray, anyelement, anyelement) function.
static <T> @NotNull Field<T[]>	PostgresDSL.arrayReplace(T[] array, Field<T> search, Field<T> replace)	The PostgreSQL array_replace(anyarray, anyelement, anyelement) function.
static @NotNull Field<String>	PostgresDSL.arrayToString(Object[] array, Field<String> delimiter)	The PostgreSQL array_to_string(anyarray, delimiter) function.
static @NotNull Field<String>	PostgresDSL.arrayToString(Field<? extends Object[]> array, String delimiter)	The PostgreSQL array_to_string(anyarray, delimiter) function.
static @NotNull Field<String>	PostgresDSL.arrayToString(Field<? extends Object[]> array, Field<String> delimiter)	The PostgreSQL array_to_string(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(String string, Field<String> delimiter)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(String string, Field<String> delimiter, Field<String> nullString)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(Field<String> string, String delimiter)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(Field<String> string, String delimiter, String nullString)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(Field<String> string, Field<String> delimiter)	The PostgreSQL string_to_array(anyarray, delimiter) function.
static @NotNull Field<String[]>	PostgresDSL.stringToArray(Field<String> string, Field<String> delimiter, Field<String> nullString)	The PostgreSQL string_to_array(anyarray, delimiter) function.

Uses of Field in org.jooq.util.sqlite

Methods in org.jooq.util.sqlite that return Field

Modifier and Type	Method	Description
static Field<Long>	SQLiteDSL.rowid()	Deprecated, for removal: This API element is subject to removal in a future version. Retrieve the SQLite-specific _rowid_ pseudo-field.

Uses of Field in org.jooq.util.sqlserver

Methods in org.jooq.util.sqlserver that return Field

Modifier and Type	Method	Description
static @NotNull Field<Integer>	SQLServerDSL.difference(String value1, String value2)	The SQL Server specific DIFFERENCE() function.
static @NotNull Field<Integer>	SQLServerDSL.difference(String value1, Field<String> value2)	The SQL Server specific DIFFERENCE() function.
static @NotNull Field<Integer>	SQLServerDSL.difference(Field<String> value1, String value2)	The SQL Server specific DIFFERENCE() function.
static @NotNull Field<Integer>	SQLServerDSL.difference(Field<String> value1, Field<String> value2)	The SQL Server specific DIFFERENCE() function.
static @NotNull Field<String>	SQLServerDSL.soundex(String string)	The SQL Server specific SOUNDEX() function.
static @NotNull Field<String>	SQLServerDSL.soundex(Field<String> field)	The SQL Server specific SOUNDEX() function.

Methods in org.jooq.util.sqlserver with parameters of type Field

Modifier and Type	Method	Description
static @NotNull Field<Integer>	SQLServerDSL.difference(String value1, Field<String> value2)	The SQL Server specific DIFFERENCE() function.
static @NotNull Field<Integer>	SQLServerDSL.difference(Field<String> value1, String value2)	The SQL Server specific DIFFERENCE() function.
static @NotNull Field<Integer>	SQLServerDSL.difference(Field<String> value1, Field<String> value2)	The SQL Server specific DIFFERENCE() function.
static @NotNull Field<String>	SQLServerDSL.soundex(Field<String> field)	The SQL Server specific SOUNDEX() function.