Uses of Interface
org.jooq.Record5

Packages that use Record5

Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.impl	This package contains jOOQ's implementation classes.

Uses of Record5 in org.jooq

Methods in org.jooq with type parameters of type Record5

Modifier and Type	Method	Description
<R extends Record5<?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList5.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record5<?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList5.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record5<?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList5.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
static final <T1, T2, T3, T4, T5, R extends Record5<T1, T2, T3, T4, T5>, U> RecordMapper<R,U>	Records.mapping(Function5<? super T1,? super T2,? super T3,? super T4,? super T5,? extends U> function)	Create a RecordMapper that can map from Record5 to a user type in a type safe way.

Methods in org.jooq that return Record5

Modifier and Type	Method	Description
<T1, T2, T3, T4, T5> @NotNull Record5<T1,T2,T3,T4,T5>	DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)	Execute and return exactly one record for
<T1, T2, T3, T4, T5> @NotNull Record5<T1,T2,T3,T4,T5>	Record.into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)	Copy this record into a new record holding only a subset of the previous fields, using Fields.field(Field) for lookup.
<T1, T2, T3, T4, T5> @NotNull Record5<T1,T2,T3,T4,T5>	DSLContext.newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)	Create a new empty Record.
@NotNull Record5<T1,T2,T3,T4,T5>	Record5.value1(T1 value)	Set the first value.
@NotNull Record5<T1,T2,T3,T4,T5>	Record5.value2(T2 value)	Set the second value.
@NotNull Record5<T1,T2,T3,T4,T5>	Record5.value3(T3 value)	Set the third value.
@NotNull Record5<T1,T2,T3,T4,T5>	Record5.value4(T4 value)	Set the fourth value.
@NotNull Record5<T1,T2,T3,T4,T5>	Record5.value5(T5 value)	Set the fifth value.
@NotNull Record5<T1,T2,T3,T4,T5>	Record5.values(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5)	Set all values.
<T> @NotNull Record5<T1,T2,T3,T4,T5>	Record5.with(Field<T> field, T value)	Set a value into this record, using Fields.field(Field) for lookup.
<T, U> @NotNull Record5<T1,T2,T3,T4,T5>	Record5.with(Field<T> field, U value, Converter<? extends T,? super U> converter)	Set a value into this record, using Fields.field(Field) for lookup.

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

Modifier and Type	Method	Description
<T1, T2, T3, T4, T5> @NotNull CloseableResultQuery<Record5<T1,T2,T3,T4,T5>>	CloseableResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
<T1, T2, T3, T4, T5> @NotNull ResultQuery<Record5<T1,T2,T3,T4,T5>>	ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)	Coerce the result record type of this query to that of a set of fields.
<T1, T2, T3, T4, T5> @NotNull Result<Record5<T1,T2,T3,T4,T5>>	Result.into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)	Copy all records from this result into a new result with new records holding only a subset of the previous fields, using Fields.field(Field) for lookup.
<T1, T2, T3, T4, T5> @NotNull Result<Record5<T1,T2,T3,T4,T5>>	DSLContext.newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)	Create a new empty Result.
<T1, T2, T3, T4, T5> @NotNull DeleteResultStep<Record5<T1,T2,T3,T4,T5>>	DeleteReturningStep.returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)	Configure the DELETE statement to return a list of fields in R.
<T1, T2, T3, T4, T5> @NotNull InsertResultStep<Record5<T1,T2,T3,T4,T5>>	InsertReturningStep.returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)	Configure the INSERT statement to return a list of fields in R.
<T1, T2, T3, T4, T5> @NotNull UpdateResultStep<Record5<T1,T2,T3,T4,T5>>	UpdateReturningStep.returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)	Configure the UPDATE statement to return a list of fields in R.
<T1, T2, T3, T4, T5> @NotNull SelectSelectStep<Record5<T1,T2,T3,T4,T5>>	DSLContext.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)	Create a new DSL select statement.
<T1, T2, T3, T4, T5> @NotNull SelectSelectStep<Record5<T1,T2,T3,T4,T5>>	WithStep.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)	Create a new DSL select statement.
<T1, T2, T3, T4, T5> @NotNull SelectSelectStep<Record5<T1,T2,T3,T4,T5>>	DSLContext.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)	Create a new DSL select statement.
<T1, T2, T3, T4, T5> @NotNull SelectSelectStep<Record5<T1,T2,T3,T4,T5>>	WithStep.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)	Create a new DSL select statement.

Methods in org.jooq with parameters of type Record5

Modifier and Type	Method	Description
@NotNull Condition	BetweenAndStep5.and(Record5<T1,T2,T3,T4,T5> maxValue)	Create a condition to check this field against some bounds
@NotNull BetweenAndStep5<T1,T2,T3,T4,T5>	Row5.between(Record5<T1,T2,T3,T4,T5> minValue)	Check if this row value expression is within a range of two records.
@NotNull Condition	Row5.between(Record5<T1,T2,T3,T4,T5> minValue, Record5<T1,T2,T3,T4,T5> maxValue)	Check if this row value expression is within a range of two records.
@NotNull BetweenAndStep5<T1,T2,T3,T4,T5>	Row5.betweenSymmetric(Record5<T1,T2,T3,T4,T5> minValue)	Check if this row value expression is within a symmetric range of two records.
@NotNull Condition	Row5.betweenSymmetric(Record5<T1,T2,T3,T4,T5> minValue, Record5<T1,T2,T3,T4,T5> maxValue)	Check if this row value expression is within a symmetric range of two records.
@NotNull Condition	Row5.compare(Comparator comparator, Record5<T1,T2,T3,T4,T5> record)	Compare this row value expression with a record using a dynamic comparator.
@NotNull Condition	Row5.eq(Record5<T1,T2,T3,T4,T5> record)	Compare this row value expression with a record for equality.
@NotNull Condition	Row5.equal(Record5<T1,T2,T3,T4,T5> record)	Compare this row value expression with a record for equality.
@NotNull Condition	Row5.ge(Record5<T1,T2,T3,T4,T5> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row5.greaterOrEqual(Record5<T1,T2,T3,T4,T5> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row5.greaterThan(Record5<T1,T2,T3,T4,T5> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row5.gt(Record5<T1,T2,T3,T4,T5> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row5.in(Record5<T1,T2,T3,T4,T5>... record)	Compare this row value expression with a set of records for equality.
@NotNull Condition	Row5.isDistinctFrom(Record5<T1,T2,T3,T4,T5> record)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row5.isNotDistinctFrom(Record5<T1,T2,T3,T4,T5> record)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row5.le(Record5<T1,T2,T3,T4,T5> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row5.lessOrEqual(Record5<T1,T2,T3,T4,T5> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row5.lessThan(Record5<T1,T2,T3,T4,T5> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row5.lt(Record5<T1,T2,T3,T4,T5> record)	Compare this row value expression with a record for order.
@NotNull Condition	Row5.ne(Record5<T1,T2,T3,T4,T5> record)	Compare this row value expression with a record for non-equality.
@NotNull BetweenAndStep5<T1,T2,T3,T4,T5>	Row5.notBetween(Record5<T1,T2,T3,T4,T5> minValue)	Check if this row value expression is within a range of two records.
@NotNull Condition	Row5.notBetween(Record5<T1,T2,T3,T4,T5> minValue, Record5<T1,T2,T3,T4,T5> maxValue)	Check if this row value expression is within a range of two records.
@NotNull BetweenAndStep5<T1,T2,T3,T4,T5>	Row5.notBetweenSymmetric(Record5<T1,T2,T3,T4,T5> minValue)	Check if this row value expression is not within a symmetric range of two records.
@NotNull Condition	Row5.notBetweenSymmetric(Record5<T1,T2,T3,T4,T5> minValue, Record5<T1,T2,T3,T4,T5> maxValue)	Check if this row value expression is not within a symmetric range of two records.
@NotNull Condition	Row5.notEqual(Record5<T1,T2,T3,T4,T5> record)	Compare this row value expression with a record for non-equality
@NotNull Condition	Row5.notIn(Record5<T1,T2,T3,T4,T5>... record)	Compare this row value expression with a set of records for non-equality.
@NotNull Statement	Row5.set(Record5<T1,T2,T3,T4,T5> record)	Assign a value to this set of variables.
@NotNull InsertValuesStep5<R,T1,T2,T3,T4,T5>	InsertValuesStep5.values(Record5<T1,T2,T3,T4,T5> values)	Add a single row of values to the insert statement.
@NotNull InsertValuesStep5<R,T1,T2,T3,T4,T5>	InsertValuesStep5.valuesOfRecords(Record5<T1,T2,T3,T4,T5>... values)	Add multiple rows of values to the insert statement.

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

Modifier and Type	Method	Description
<T1, T2, T3, T4, T5> void	UpdateQuery.addValues(Row5<T1,T2,T3,T4,T5> row, Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Specify a multi-column set clause for the UPDATE statement.
@NotNull WithStep	WithAsStep5.as(ResultQuery<? extends Record5<?,?,?,?,?>> query)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep5.asMaterialized(ResultQuery<? extends Record5<?,?,?,?,?>> query)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep5.asNotMaterialized(ResultQuery<? extends Record5<?,?,?,?,?>> query)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull Condition	Row5.compare(Comparator comparator, QuantifiedSelect<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row5.compare(Comparator comparator, Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row5.eq(QuantifiedSelect<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row5.eq(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row5.equal(QuantifiedSelect<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row5.equal(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row5.ge(QuantifiedSelect<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.ge(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.greaterOrEqual(QuantifiedSelect<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.greaterOrEqual(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.greaterThan(QuantifiedSelect<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.greaterThan(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.gt(QuantifiedSelect<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.gt(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.in(Result<? extends Record5<T1,T2,T3,T4,T5>> result)	Compare this row value expression with a set of records for equality.
@NotNull Condition	Row5.in(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row5.isDistinctFrom(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row5.isNotDistinctFrom(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row5.le(QuantifiedSelect<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.le(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.lessOrEqual(QuantifiedSelect<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.lessOrEqual(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.lessThan(QuantifiedSelect<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.lessThan(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.lt(QuantifiedSelect<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.lt(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.ne(QuantifiedSelect<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row5.ne(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row5.notEqual(QuantifiedSelect<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row5.notEqual(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row5.notIn(Result<? extends Record5<T1,T2,T3,T4,T5>> result)	Compare this row value expression with a set of records for equality.
@NotNull Condition	Row5.notIn(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull InsertOnDuplicateStep<R>	InsertValuesStep5.select(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Use a SELECT statement as the source of values for the INSERT statement
@NotNull Merge<R>	MergeValuesStep5.select(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	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 Statement	Row5.set(Select<? extends Record5<T1,T2,T3,T4,T5>> value)	Assign a value to this set of variables.
<T1, T2, T3, T4, T5> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row5<T1,T2,T3,T4,T5> row, Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Specify a multi-column set clause for the UPDATE statement.
@NotNull InsertValuesStep5<R,T1,T2,T3,T4,T5>	InsertValuesStep5.valuesOfRecords(Collection<? extends Record5<T1,T2,T3,T4,T5>> values)	Add multiple rows of values to the insert statement.

Uses of Record5 in org.jooq.impl

Methods in org.jooq.impl that return Record5

Modifier and Type	Method	Description
<T1, T2, T3, T4, T5> Record5<T1,T2,T3,T4,T5>	DefaultDSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)
<T1, T2, T3, T4, T5> Record5<T1,T2,T3,T4,T5>	DefaultDSLContext.newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

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

Modifier and Type	Method	Description
static <T1, T2, T3, T4, T5> @NotNull ArrayAggOrderByStep<Result<Record5<T1,T2,T3,T4,T5>>>	DSL.multisetAgg(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)	Get the MULTISET_AGG aggregate function to nest group contents.
static <T1, T2, T3, T4, T5> @NotNull ArrayAggOrderByStep<Result<Record5<T1,T2,T3,T4,T5>>>	DSL.multisetAggDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)	Get the MULTISET_AGG(DISTINCT) aggregate function to nest group contents.
<T1, T2, T3, T4, T5> Result<Record5<T1,T2,T3,T4,T5>>	DefaultDSLContext.newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
static <T1, T2, T3, T4, T5> @NotNull RecordType<Record5<T1,T2,T3,T4,T5>>	DSL.recordType(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)	Create a RecordType of degree 5.
static <T1, T2, T3, T4, T5> @NotNull Field<Record5<T1,T2,T3,T4,T5>>	DSL.rowField(Row5<T1,T2,T3,T4,T5> row)	Deprecated, for removal: This API element is subject to removal in a future version. - [#11812] - 3.15.0 - Use Row5 as a SelectField directly, instead.
<T1, T2, T3, T4, T5> SelectSelectStep<Record5<T1,T2,T3,T4,T5>>	DefaultDSLContext.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)
static <T1, T2, T3, T4, T5> @NotNull SelectSelectStep<Record5<T1,T2,T3,T4,T5>>	DSL.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)	Create a new DSL subselect statement.
<T1, T2, T3, T4, T5> SelectSelectStep<Record5<T1,T2,T3,T4,T5>>	DefaultDSLContext.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)
static <T1, T2, T3, T4, T5> @NotNull SelectSelectStep<Record5<T1,T2,T3,T4,T5>>	DSL.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)	Create a new DSL subselect statement.
static <T1, T2, T3, T4, T5> @NotNull Table<Record5<T1,T2,T3,T4,T5>>	DSL.values(Row5<T1,T2,T3,T4,T5>... rows)	Create a VALUES() expression of degree 5.