Top Description Methods
org.jooq

public Interface Result<R extends org.jooq.Record>

extends Fields, List<R extends Record>, Attachable, Formattable
Known Direct Implementers
org.jooq.impl.ResultImpl
Type Parameters
<R>
The record type contained in this result
Imports
java.sql.ResultSet, .Statement, java.util.List, .Map, .Set, java.util.function.Consumer, java.util.stream.Collector, .Stream, org.jooq.exception.DataAccessException, .DataTypeException, .InvalidResultException, .MappingException, org.jooq.impl.DefaultRecordMapper, org.jetbrains.annotations.Blocking, .NotNull, .Nullable
A wrapper for database results returned by SelectQuery.
Author
Lukas Eder
See Also
SelectQuery#getResult()

Method Summary

Modifier and TypeMethod and Description
public void
attach(Configuration
A configuration or null, if you wish to detach this Attachable from its previous configuration.
configuration)

Redeclares org.jooq.Attachable.attach.

Attach this result and all of its contained records to a new Configuration.
public <O extends TableRecord<O>> @NotNull Table<O>
children(ForeignKey<O, R> key)

Get a table expression representing the children of all of this result's records, given a foreign key.

public <X, A> X
collect(Collector<? super R, A, X> collector)

Collect all records of this result.

public void
detach()

Redeclares org.jooq.Attachable.detach.

Detach this result and all of its contained records from their current Configuration.
public <O extends TableRecord<O>> @NotNull Result<O>
fetchChildren(ForeignKey<O, R> key)

Fetch child records of this record, given a foreign key, as if fetching from children(ForeignKey).

public <O extends UpdatableRecord<O>> @NotNull Result<O>
fetchParents(ForeignKey<R, O> key)

Fetch parent records of this record, given a foreign key, as if fetching from parents(ForeignKey).

public <
The value's field's generic type parameter
T> T

Returns:

The value
getValue(int
The record's 0-based index in the record list
index, Field<T>
The value's field
field)

Deprecated as a consequence of Field being deprecated.
Convenience method to fetch a value at a given position in the result, using field(Field) for lookup.
public @Nullable Object

Returns:

The value
getValue(int
The record's 0-based index in the record list
index, int
The value's field index
fieldIndex)

Convenience method to fetch a value at a given position in the result.

public @Nullable Object

Returns:

The value
getValue(int
The record's 0-based index in the record list
index, String
The value's field name
fieldName)

Convenience method to fetch a value at a given position in the result, using field(String) for lookup.

public <
The values' field's generic type parameter
T> @NotNull List<T>

Returns:

The values
getValues(Field<T>
The values' field
field)

Deprecated as a consequence of Field being deprecated.
Convenience method to fetch all values for a given field.
public <U> @NotNull List<U>

Returns:

The values
getValues(Field<?>
The values' field
field, Class<? extends U>
The type used for type conversion
type)

Deprecated as a consequence of Field being deprecated.
Convenience method to fetch all values for a given field.
public <T, U> @NotNull List<U>

Returns:

The values
getValues(Field<T>
The values' field
field, Converter<? super T, ? extends U>
The data type converter used for type conversion
converter)

Deprecated as a consequence of Field being deprecated.
Convenience method to fetch all values for a given field.
public @NotNull List<?>

Returns:

The values
getValues(int
The values' 0-based field index
index)

Convenience method to fetch all values for a given field.

public <U> @NotNull List<U>

Returns:

The values
getValues(int
The values' 0-based field index
index, Class<? extends U>
The type used for type conversion
type)

Convenience method to fetch all values for a given field.

public <U> @NotNull List<U>

Returns:

The values
getValues(int
The values' 0-based field index
index, Converter<?, ? extends U>
The data type converter used for type conversion
converter)

Convenience method to fetch all values for a given field.

public @NotNull List<?>

Returns:

The values
getValues(String
The values' field name
fieldName)

Convenience method to fetch all values for a given field.

public <U> @NotNull List<U>

Returns:

The values
getValues(String
The values' field name
fieldName, Class<? extends U>
The type used for type conversion
type)

Convenience method to fetch all values for a given field.

public <U> @NotNull List<U>

Returns:

The values
getValues(String
The values' field name
fieldName, Converter<?, ? extends U>
The data type converter used for type conversion
converter)

Convenience method to fetch all values for a given field.

public @NotNull List<?>

Returns:

The values
getValues(Name
The values' field name
fieldName)

Convenience method to fetch all values for a given field.

public <U> @NotNull List<U>

Returns:

The values
getValues(Name
The values' field name
fieldName, Class<? extends U>
The type used for type conversion
type)

Convenience method to fetch all values for a given field.

public <U> @NotNull List<U>

Returns:

The values
getValues(Name
The values' field name
fieldName, Converter<?, ? extends U>
The data type converter used for type conversion
converter)

Convenience method to fetch all values for a given field.

public @NotNull Result<R>

Returns:

The same result
intern(Field<?>...
The fields whose values should be interned
fields)

Deprecated for removal since 3.10. - 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0
Specify a set of fields whose values should be interned.
public @NotNull Result<R>

Returns:

The same result
intern(int...
The 0-based field indexes whose values should be interned
fieldIndexes)

Deprecated for removal since 3.10. - 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0
Specify a set of field indexes whose values should be interned.
public @NotNull Result<R>

Returns:

The same result
intern(String...
The field names whose values should be interned
fieldNames)

Deprecated for removal since 3.10. - 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0
Specify a set of field names whose values should be interned.
public @NotNull Result<R>

Returns:

The same result
intern(Name...
The field names whose values should be interned
fieldNames)

Deprecated for removal since 3.10. - 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0
Specify a set of field names whose values should be interned.
public @NotNull Result<Record>

Returns:

The new result
into(Field<?>...
The fields of the new records
fields)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1> @NotNull Result<Record1<T1>>

Returns:

The new result
into(Field<T1> field1)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2> @NotNull Result<Record2<T1, T2>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3> @NotNull Result<Record3<T1, T2, T3>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4> @NotNull Result<Record4<T1, T2, T3, T4>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5> @NotNull Result<Record5<T1, T2, T3, T4, T5>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6> @NotNull Result<Record6<T1, T2, T3, T4, T5, T6>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7> @NotNull Result<Record7<T1, T2, T3, T4, T5, T6, T7>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8> @NotNull Result<Record8<T1, T2, T3, T4, T5, T6, T7, T8>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull Result<Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull Result<Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull Result<Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull Result<Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull Result<Record13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull Result<Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull Result<Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull Result<Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull Result<Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull Result<Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull Result<Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull Result<Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull Result<Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> @NotNull Result<Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>>

Returns:

The new result
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Deprecated as a consequence of Field being deprecated.
Copy all records from this result into a new result with new records holding only a subset of the previous fields, using field(Field) for lookup.
public <
The generic entity type.
E> @NotNull List<E>
into(Class<? extends E>
The entity type.
type)

Map resulting records onto a custom type.

public <
The generic table record type.
Z extends Record> @NotNull Result<Z>
into(Table<Z>
The table type.
table)

Map resulting records onto a custom record.

public <H extends RecordHandler<? super R>> H

Returns:

Convenience result, returning the parameter handler itself
into(H
The handler callback
handler)

Deprecated for removal since 3.15. - 3.15.0 - [#11902] - Use Iterable#forEach(Consumer) based methods, instead.
Map results into a custom handler callback.
public @NotNull @Nullable Object[]

Returns:

The resulting values. This may be an array type more concrete than Object[], depending on whether jOOQ has any knowledge about fieldIndex's actual type.
intoArray(int
The 0-based field index
fieldIndex)

Return all values for a field index from the result.

public <U> @NotNull U[]

Returns:

The resulting values.
intoArray(int
The 0-based field index
fieldIndex, Class<? extends U> type)

Return all values for a field index from the result.

public <U> @NotNull U[]

Returns:

The resulting values.
intoArray(int
The 0-based field index
fieldIndex, Converter<?, ? extends U> converter)

Return all values for a field index from the result.

public @NotNull @Nullable Object[]

Returns:

The resulting values. This may be an array type more concrete than Object[], depending on whether jOOQ has any knowledge about fieldName's actual type.
intoArray(String fieldName)

Return all values for a field name from the result, using field(String) for lookup.

public <U> @NotNull U[]

Returns:

The resulting values.
intoArray(String fieldName, Class<? extends U> type)

Return all values for a field name from the result, using field(String) for lookup.

public <U> @NotNull U[]

Returns:

The resulting values.
intoArray(String fieldName, Converter<?, ? extends U> converter)

Return all values for a field name from the result, using field(String) for lookup.

public @NotNull @Nullable Object[]

Returns:

The resulting values. This may be an array type more concrete than Object[], depending on whether jOOQ has any knowledge about fieldName's actual type.
intoArray(Name fieldName)

Return all values for a field name from the result, using field(Name) for lookup.

public <U> @NotNull U[]

Returns:

The resulting values.
intoArray(Name fieldName, Class<? extends U> type)

Return all values for a field name from the result, using field(Name) for lookup.

public <U> @NotNull U[]

Returns:

The resulting values.
intoArray(Name fieldName, Converter<?, ? extends U> converter)

Return all values for a field name from the result, using field(Name) for lookup.

public <T> @NotNull T[]

Returns:

The resulting values.
intoArray(Field<T> field)

Deprecated as a consequence of Field being deprecated.
Return all values for a field from the result, using field(Field) for lookup.
public <U> @NotNull U[]

Returns:

The resulting values.
intoArray(Field<?> field, Class<? extends U> type)

Deprecated as a consequence of Field being deprecated.
Return all values for a field from the result, using field(Field) for lookup.
public <T, U> @NotNull U[]

Returns:

The resulting values.
intoArray(Field<T> field, Converter<? super T, ? extends U> converter)

Deprecated as a consequence of Field being deprecated.
Return all values for a field from the result, using field(Field) for lookup.
public @NotNull @NotNull @Nullable Object[][]

Returns:

This result as an array of arrays
intoArrays()

Convert this result into an array of arrays.

public <
The key's generic field type
K> @NotNull Map<K, Result<R>>

Returns:

A Map containing the results
intoGroups(Field<K>
The key field.
key)

Deprecated as a consequence of Field being deprecated.
Return a Map with one of the result's columns as key and a list of corresponding records as value, using field(Field) for lookup.
public @NotNull Map<?, Result<R>>

Returns:

A Map containing the results
intoGroups(int
The 0-based key field index.
keyFieldIndex)

Return a Map with one of the result's columns as key and a list of corresponding records as value.

public @NotNull Map<?, Result<R>>

Returns:

A Map containing the results
intoGroups(String
The key field name.
keyFieldName)

Return a Map with one of the result's columns as key and a list of corresponding records as value, using field(String) for lookup.

public @NotNull Map<?, Result<R>>

Returns:

A Map containing the results
intoGroups(Name
The key field name.
keyFieldName)

Return a Map with one of the result's columns as key and a list of corresponding records as value, using field(Name) for lookup.

public <
The key's generic field type
K,
The value's generic field type
V> @NotNull Map<K, List<V>>

Returns:

A Map containing the results
intoGroups(Field<K>
The key field.
key, Field<V>
The value field
value)

Deprecated as a consequence of Field being deprecated.
Return a Map with one of the result's columns as key and another one of the result's columns as value, using field(Field) for lookup.
public @NotNull Map<?, List<?>>

Returns:

A Map containing the results
intoGroups(int
The 0-based key field index.
keyFieldIndex, int
The 0-based value field index.
valueFieldIndex)

Return a Map with one of the result's columns as key and another one of the result's columns as value.

public @NotNull Map<?, List<?>>

Returns:

A Map containing the results
intoGroups(String
The key field name.
keyFieldName, String
The value field name.
valueFieldName)

Return a Map with one of the result's columns as key and another one of the result's columns as value, using field(String) for lookup.

public @NotNull Map<?, List<?>>

Returns:

A Map containing the results
intoGroups(Name
The key field name.
keyFieldName, Name
The value field name.
valueFieldName)

Return a Map with one of the result's columns as key and another one of the result's columns as value, using field(Name) for lookup.

public <
The key's generic field type
K,
The generic entity type.
E> @NotNull Map<K, List<E>>
intoGroups(Field<K>
The key field.
key, Class<? extends E>
The entity type.
type)

Deprecated as a consequence of Field being deprecated.
Return a Map with results grouped by the given key and mapped into the given entity type, using field(Field) for lookup.
public <E> @NotNull Map<?, List<E>>
intoGroups(int
The 0-based key field index.
keyFieldIndex, Class<? extends E>
The entity type.
type)

Return a Map with results grouped by the given key and mapped into the given entity type.

public <E> @NotNull Map<?, List<E>>
intoGroups(String
The key field name.
keyFieldName, Class<? extends E>
The entity type.
type)

Return a Map with results grouped by the given key and mapped into the given entity type, using field(String) for lookup.

public <E> @NotNull Map<?, List<E>>
intoGroups(Name
The key field name.
keyFieldName, Class<? extends E>
The entity type.
type)

Return a Map with results grouped by the given key and mapped into the given entity type, using field(Name) for lookup.

public <
The key's generic field type
K,
The generic entity type.
E> @NotNull Map<K, List<E>>
intoGroups(Field<K>
The key field.
key, RecordMapper<? super R, E>
The mapper callback.
mapper)

Deprecated as a consequence of Field being deprecated.
Return a Map with results grouped by the given key and mapped by the given mapper, using field(Field) for lookup.
public <E> @NotNull Map<?, List<E>>
intoGroups(int
The 0-based key field index.
keyFieldIndex, RecordMapper<? super R, E>
The mapper callback.
mapper)

Return a Map with results grouped by the given key and mapped by the given mapper.

public <E> @NotNull Map<?, List<E>>
intoGroups(String
The key field name.
keyFieldName, RecordMapper<? super R, E>
The mapper callback.
mapper)

Return a Map with results grouped by the given key and mapped by the given mapper, using field(String) for lookup.

public <E> @NotNull Map<?, List<E>>
intoGroups(Name
The key field name.
keyFieldName, RecordMapper<? super R, E>
The mapper callback.
mapper)

Return a Map with results grouped by the given key and mapped by the given mapper, using field(Name) for lookup.

public @NotNull Map<Record, Result<R>>

Returns:

A Map containing grouped results
intoGroups(Field<?>[]
The keys. If this is null or an empty array, the resulting map will contain at most one entry.
keys)

Deprecated as a consequence of Field being deprecated.
Return a Map with the result grouped by the given keys, using field(Field) for lookup.
public @NotNull Map<Record, Result<R>>

Returns:

A Map containing grouped results
intoGroups(int[]
The 0-based key field indexes. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldIndexes)

Return a Map with the result grouped by the given keys.

public @NotNull Map<Record, Result<R>>

Returns:

A Map containing grouped results
intoGroups(String[]
The keys. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames)

Return a Map with the result grouped by the given keys, using field(String) for lookup.

public @NotNull Map<Record, Result<R>>

Returns:

A Map containing grouped results
intoGroups(Name[]
The keys. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames)

Return a Map with the result grouped by the given keys, using field(Name) for lookup.

public @NotNull Map<Record, Result<Record>>

Returns:

A Map containing grouped results
intoGroups(Field<?>[]
The keys. If this is null or an empty array, the resulting map will contain at most one entry.
keys, Field<?>[]
The values.
values)

Deprecated as a consequence of Field being deprecated.
Return a Map with the result grouped by the given keys, using field(Field) for lookup.
public @NotNull Map<Record, Result<Record>>

Returns:

A Map containing grouped results
intoGroups(int[]
The 0-based key field indexes. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldIndexes, int[]
The 0-based value field indexes.
valueFieldIndexes)

Return a Map with the result grouped by the given keys.

public @NotNull Map<Record, Result<Record>>

Returns:

A Map containing grouped results
intoGroups(String[]
The keys. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames, String[]
The values.
valueFieldNames)

Return a Map with the result grouped by the given keys, using field(String) for lookup.

public @NotNull Map<Record, Result<Record>>

Returns:

A Map containing grouped results
intoGroups(Name[]
The keys. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames, Name[]
The values.
valueFieldNames)

Return a Map with the result grouped by the given keys, using field(Name) for lookup.

public <E> @NotNull Map<Record, List<E>>

Returns:

A Map containing grouped results
intoGroups(Field<?>[]
The keys. If this is null or an empty array, the resulting map will contain at most one entry.
keys, Class<? extends E>
The entity type.
type)

Deprecated as a consequence of Field being deprecated.
Return a Map with results grouped by the given keys and mapped into the given entity type, using field(Field) for lookup.
public <E> @NotNull Map<Record, List<E>>

Returns:

A Map containing grouped results
intoGroups(int[]
The 0-based key field indexes. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldIndexes, Class<? extends E>
The entity type.
type)

Return a Map with results grouped by the given keys and mapped into the given entity type.

public <E> @NotNull Map<Record, List<E>>

Returns:

A Map containing grouped results
intoGroups(String[]
The keys. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames, Class<? extends E>
The entity type.
type)

Return a Map with results grouped by the given keys and mapped into the given entity type, using field(String) for lookup.

public <E> @NotNull Map<Record, List<E>>

Returns:

A Map containing grouped results
intoGroups(Name[]
The keys. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames, Class<? extends E>
The entity type.
type)

Return a Map with results grouped by the given keys and mapped into the given entity type, using field(Name) for lookup.

public <E> @NotNull Map<Record, List<E>>

Returns:

A Map containing grouped results
intoGroups(Field<?>[]
The keys. If this is null or an empty array, the resulting map will contain at most one entry.
keys, RecordMapper<? super R, E>
The mapper callback.
mapper)

Deprecated as a consequence of Field being deprecated.
Return a Map with results grouped by the given keys and mapped into the given entity type, using field(Field) for lookup.
public <E> @NotNull Map<Record, List<E>>

Returns:

A Map containing grouped results
intoGroups(int[]
The 0-based key field indexes. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldIndexes, RecordMapper<? super R, E>
The mapper callback.
mapper)

Return a Map with results grouped by the given keys and mapped into the given entity type.

public <E> @NotNull Map<Record, List<E>>

Returns:

A Map containing grouped results
intoGroups(String[]
The keys. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames, RecordMapper<? super R, E>
The mapper callback.
mapper)

Return a Map with results grouped by the given keys and mapped into the given entity type, using field(String) for lookup.

public <E> @NotNull Map<Record, List<E>>

Returns:

A Map containing grouped results
intoGroups(Name[]
The keys. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames, RecordMapper<? super R, E>
The mapper callback.
mapper)

Return a Map with results grouped by the given keys and mapped into the given entity type, using field(Name) for lookup.

public <K> @NotNull Map<K, Result<R>>

Returns:

A Map containing grouped results
intoGroups(Class<? extends K>
The key type. If this is null, the resulting map will contain at most one entry.
keyType)

Return a Map with results grouped by the given key entity.

public <K, V> @NotNull Map<K, List<V>>

Returns:

A Map containing grouped results
intoGroups(Class<? extends K>
The key type. If this is null, the resulting map will contain at most one entry.
keyType, Class<? extends V>
The value type.
valueType)

Return a Map with results grouped by the given key entity and mapped into the given entity type.

public <K, V> @NotNull Map<K, List<V>>

Returns:

A Map containing grouped results
intoGroups(Class<? extends K>
The key type. If this is null, the resulting map will contain at most one entry.
keyType, RecordMapper<? super R, V>
The value mapper.
valueMapper)

Return a Map with results grouped by the given key entity and mapped into the given entity type.

public <K> @NotNull Map<K, Result<R>>

Returns:

A Map containing grouped results
intoGroups(RecordMapper<? super R, K>
The key mapper.
keyMapper)

Return a Map with results grouped by the given key entity and mapped into the given entity type.

public <K, V> @NotNull Map<K, List<V>>

Returns:

A Map containing grouped results
intoGroups(RecordMapper<? super R, K>
The key mapper.
keyMapper, Class<V>
The value type.
valueType)

Return a Map with results grouped by the given key entity and mapped into the given entity type.

public <K, V> @NotNull Map<K, List<V>>

Returns:

A Map containing grouped results
intoGroups(RecordMapper<? super R, K>
The key mapper.
keyMapper, RecordMapper<? super R, V>
The value mapper.
valueMapper)

Return a Map with results grouped by the given key entity and mapped into the given entity type.

public <S extends Record> @NotNull Map<S, Result<R>>

Returns:

A Map containing grouped results
intoGroups(Table<S>
The key table. May not be null.
table)

Return a Map with the result grouped by the given key table.

public <S extends Record, T extends Record> @NotNull Map<S, Result<T>>

Returns:

A Map containing grouped results
intoGroups(Table<S>
The key table. May not be null.
keyTable, Table<T>
The value table. May not be null.
valueTable)

Return a Map with the result grouped by the given key table.

public <E, S extends Record> @NotNull Map<S, List<E>>

Returns:

A Map containing grouped results
intoGroups(Table<S>
The key table. May not be null.
table, Class<? extends E>
The entity type.
type)

Return a Map with results grouped by the given key table and mapped into the given entity type.

public <E, S extends Record> @NotNull Map<S, List<E>>

Returns:

A Map containing grouped results
intoGroups(Table<S>
The key table. May not be null.
table, RecordMapper<? super R, E>
The mapper callback.
mapper)

Return a Map with results grouped by the given key table and mapped into the given entity type.

public <
The key's generic field type.
K> @NotNull Map<K, R>

Returns:

A Map containing the results.
intoMap(Field<K>
The key field. Client code must assure that this field is unique in the result set.
key)

Deprecated as a consequence of Field being deprecated.
Return a Map with one of the result's columns as key and the corresponding records as value, using field(Field) for lookup.
public @NotNull Map<?, R>

Returns:

A Map containing the results
intoMap(int
The 0-based key field index. Client code must assure that this field is unique in the result set.
keyFieldIndex)

Return a Map with one of the result's columns as key and the corresponding records as value.

public @NotNull Map<?, R>

Returns:

A Map containing the results
intoMap(String
The key field name. Client code must assure that this field is unique in the result set.
keyFieldName)

Return a Map with one of the result's columns as key and the corresponding records as value, using field(String) for lookup.

public @NotNull Map<?, R>

Returns:

A Map containing the results
intoMap(Name
The key field name. Client code must assure that this field is unique in the result set.
keyFieldName)

Return a Map with one of the result's columns as key and the corresponding records as value, using field(Name) for lookup.

public <
The key's generic field type
K,
The value's generic field type
V> @NotNull Map<K, V>

Returns:

A Map containing the results
intoMap(Field<K>
The key field. Client code must assure that this field is unique in the result set.
key, Field<V>
The value field
value)

Deprecated as a consequence of Field being deprecated.
Return a Map with one of the result's columns as key and another one of the result's columns as value, using field(Field) for lookup.
public @NotNull Map<?, ?>

Returns:

A Map containing the results
intoMap(int
The 0-based key field index. Client code must assure that this field is unique in the result set.
keyFieldIndex, int
The 0-based value field index
valueFieldIndex)

Return a Map with one of the result's columns as key and another one of the result's columns as value

An InvalidResultException is thrown, if the key turns out to be non-unique in the result set.

public @NotNull Map<?, ?>

Returns:

A Map containing the results
intoMap(String
The key field name. Client code must assure that this field is unique in the result set.
keyFieldName, String
The value field name
valueFieldName)

Return a Map with one of the result's columns as key and another one of the result's columns as value, using field(String) for lookup.

public @NotNull Map<?, ?>

Returns:

A Map containing the results
intoMap(Name
The key field name. Client code must assure that this field is unique in the result set.
keyFieldName, Name
The value field name
valueFieldName)

Return a Map with one of the result's columns as key and another one of the result's columns as value, using field(Name) for lookup.

public <K, E> @NotNull Map<K, E>

Returns:

A Map containing the result.
intoMap(Field<K>
The key. Client code must assure that key is unique in the result set.
key, Class<? extends E>
The entity type.
type)

Deprecated as a consequence of Field being deprecated.
Return a Map with results grouped by the given key and mapped into the given entity type, using field(Field) for lookup.
public <E> @NotNull Map<?, E>

Returns:

A Map containing the result.
intoMap(int
The 0-based key field index. Client code must assure that key is unique in the result set.
keyFieldIndex, Class<? extends E>
The entity type.
type)

Return a Map with results grouped by the given key and mapped into the given entity type.

public <E> @NotNull Map<?, E>

Returns:

A Map containing the result.
intoMap(String
The key. Client code must assure that key is unique in the result set.
keyFieldName, Class<? extends E>
The entity type.
type)

Return a Map with results grouped by the given key and mapped into the given entity type, using field(String) for lookup.

public <E> @NotNull Map<?, E>

Returns:

A Map containing the result.
intoMap(Name
The key. Client code must assure that key is unique in the result set.
keyFieldName, Class<? extends E>
The entity type.
type)

Return a Map with results grouped by the given key and mapped into the given entity type, using field(Name) for lookup.

public <K, E> @NotNull Map<K, E>

Returns:

A Map containing the result.
intoMap(Field<K>
The key. Client code must assure that key is unique in the result set.
key, RecordMapper<? super R, E>
The mapper callback.
mapper)

Deprecated as a consequence of Field being deprecated.
Return a Map with results grouped by the given key and mapped by the given mapper, using field(Field) for lookup.
public <E> @NotNull Map<?, E>

Returns:

A Map containing the result.
intoMap(int
The 0-based key field index. Client code must assure that key is unique in the result set.
keyFieldIndex, RecordMapper<? super R, E>
The mapper callback.
mapper)

Return a Map with results grouped by the given key and mapped by the given mapper.

public <E> @NotNull Map<?, E>

Returns:

A Map containing the result.
intoMap(String
The key. Client code must assure that key is unique in the result set.
keyFieldName, RecordMapper<? super R, E>
The mapper callback.
mapper)

Return a Map with results grouped by the given key and mapped by the given mapper, using field(String) for lookup.

public <E> @NotNull Map<?, E>

Returns:

A Map containing the result.
intoMap(Name
The key. Client code must assure that key is unique in the result set.
keyFieldName, RecordMapper<? super R, E>
The mapper callback.
mapper)

Return a Map with results grouped by the given key and mapped by the given mapper, using field(Name) for lookup.

public @NotNull Map<Record, R>

Returns:

A Map containing the results.
intoMap(Field<?>[]
The keys. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keys)

Deprecated as a consequence of Field being deprecated.
Return a Map with the given keys as a map key and the corresponding record as value, using field(Field) for lookup.
public @NotNull Map<Record, R>

Returns:

A Map containing the results.
intoMap(int[]
The 0-based key field indexes. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldIndexes)

Return a Map with the given keys as a map key and the corresponding record as value.

public @NotNull Map<Record, R>

Returns:

A Map containing the results.
intoMap(String[]
The keys. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames)

Return a Map with the given keys as a map key and the corresponding record as value, using field(String) for lookup.

public @NotNull Map<Record, R>

Returns:

A Map containing the results.
intoMap(Name[]
The keys. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames)

Return a Map with the given keys as a map key and the corresponding record as value, using field(Name) for lookup.

public @NotNull Map<Record, Record>

Returns:

A Map containing the results.
intoMap(Field<?>[]
The keys. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keys, Field<?>[]
The values.
values)

Deprecated as a consequence of Field being deprecated.
Return a Map with the given keys as a map key and the corresponding record as value, using field(Field) for lookup.
public @NotNull Map<Record, Record>

Returns:

A Map containing the results.
intoMap(int[]
The 0-based key field indexes. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldIndexes, int[]
The values.
valueFieldIndexes)

Return a Map with the given keys as a map key and the corresponding record as value.

public @NotNull Map<Record, Record>

Returns:

A Map containing the results.
intoMap(String[]
The keys. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames, String[]
The values.
valueFieldNames)

Return a Map with the given keys as a map key and the corresponding record as value, using field(String) for lookup.

public @NotNull Map<Record, Record>

Returns:

A Map containing the results.
intoMap(Name[]
The keys. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames, Name[]
The values.
valueFieldNames)

Return a Map with the given keys as a map key and the corresponding record as value, using field(Name) for lookup.

public <E> @NotNull Map<List<?>, E>

Returns:

A Map containing the results.
intoMap(Field<?>[]
The keys. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keys, Class<? extends E>
The entity type.
type)

Deprecated as a consequence of Field being deprecated.
Return a Map with results grouped by the given keys and mapped into the given entity type, using field(Field) for lookup.
public <E> @NotNull Map<List<?>, E>

Returns:

A Map containing the results.
intoMap(int[]
The 0-based key field indexes. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldIndexes, Class<? extends E>
The entity type.
type)

Return a Map with results grouped by the given keys and mapped into the given entity type.

public <E> @NotNull Map<List<?>, E>

Returns:

A Map containing the results.
intoMap(String[]
The keys. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames, Class<? extends E>
The entity type.
type)

Return a Map with results grouped by the given keys and mapped into the given entity type, using field(String) for lookup.

public <E> @NotNull Map<List<?>, E>

Returns:

A Map containing the results.
intoMap(Name[]
The keys. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames, Class<? extends E>
The entity type.
type)

Return a Map with results grouped by the given keys and mapped into the given entity type, using field(Name) for lookup.

public <E> @NotNull Map<List<?>, E>

Returns:

A Map containing the results.
intoMap(Field<?>[]
The keys. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keys, RecordMapper<? super R, E>
The mapper callback.
mapper)

Deprecated as a consequence of Field being deprecated.
Return a Map with results grouped by the given keys and mapped by the given mapper, using field(Field) for lookup.
public <E> @NotNull Map<List<?>, E>

Returns:

A Map containing the results.
intoMap(int[]
The 0-based key field indexes. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldIndexes, RecordMapper<? super R, E>
The mapper callback.
mapper)

Return a Map with results grouped by the given keys and mapped by the given mapper.

public <E> @NotNull Map<List<?>, E>

Returns:

A Map containing the results.
intoMap(String[]
The keys. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames, RecordMapper<? super R, E>
The mapper callback.
mapper)

Return a Map with results grouped by the given keys and mapped by the given mapper, using field(String) for lookup.

public <E> @NotNull Map<List<?>, E>

Returns:

A Map containing the results.
intoMap(Name[]
The keys. Client code must assure that keys are unique in the result set. If this is null or an empty array, the resulting map will contain at most one entry.
keyFieldNames, RecordMapper<? super R, E>
The mapper callback.
mapper)

Return a Map with results grouped by the given keys and mapped by the given mapper, using field(Name) for lookup.

public <K> @NotNull Map<K, R>

Returns:

A Map containing grouped results
intoMap(Class<? extends K>
The key type. If this is null, the resulting map will contain at most one entry.
keyType)

Return a Map with results grouped by the given key entity.

public <K, V> @NotNull Map<K, V>

Returns:

A Map containing grouped results
intoMap(Class<? extends K>
The key type. If this is null, the resulting map will contain at most one entry.
keyType, Class<? extends V>
The value type.
valueType)

Return a Map with results grouped by the given key entity and mapped into the given entity type.

public <K, V> @NotNull Map<K, V>

Returns:

A Map containing grouped results
intoMap(Class<? extends K>
The key type. If this is null, the resulting map will contain at most one entry.
keyType, RecordMapper<? super R, V>
The value mapper.
valueMapper)

Return a Map with results grouped by the given key entity and mapped into the given entity type.

public <K> @NotNull Map<K, R>

Returns:

A Map containing grouped results
intoMap(RecordMapper<? super R, K>
The key mapper.
keyMapper)

Return a Map with results grouped by the given key entity and mapped into the given entity type.

public <K, V> @NotNull Map<K, V>

Returns:

A Map containing grouped results
intoMap(RecordMapper<? super R, K>
The key mapper.
keyMapper, Class<V>
The value type.
valueType)

Return a Map with results grouped by the given key entity and mapped into the given entity type.

public <K, V> @NotNull Map<K, V>

Returns:

A Map containing grouped results
intoMap(RecordMapper<? super R, K>
The key mapper.
keyMapper, RecordMapper<? super R, V>
The value mapper.
valueMapper)

Return a Map with results grouped by the given key entity and mapped into the given entity type.

public <S extends Record> @NotNull Map<S, R>

Returns:

A Map containing the results.
intoMap(Table<S>
The key table. Client code must assure that keys are unique in the result set. May not be null.
table)

Return a Map with the given key table as a map key and the corresponding record as value.

public <S extends Record, T extends Record> @NotNull Map<S, T>

Returns:

A Map containing the results.
intoMap(Table<S>
The key table. Client code must assure that keys are unique in the result set. May not be null.
keyTable, Table<T>
The value table. May not be null.
valueTable)

Return a Map with the given key table as a map key and the corresponding record as value.

public <E, S extends Record> @NotNull Map<S, E>

Returns:

A Map containing the results.
intoMap(Table<S>
The key table. Client code must assure that keys are unique in the result set. May not be null.
table, Class<? extends E>
The entity type.
type)

Return a Map with results grouped by the given key table and mapped into the given entity type.

public <E, S extends Record> @NotNull Map<S, E>

Returns:

A Map containing the results.
intoMap(Table<S>
The key table. Client code must assure that keys are unique in the result set. May not be null.
table, RecordMapper<? super R, E>
The mapper callback.
mapper)

Return a Map with results grouped by the given key table and mapped by the given mapper.

public @NotNull List<Map<String, Object>>

Returns:

The result.
intoMaps()

Return the generated result as a list of name/value maps.

public @NotNull ResultSet

Returns:

A wrapper JDBC ResultSet
intoResultSet()

Generate an in-memory JDBC ResultSet containing the data of this Result.

public <E> @NotNull Set<E>

Returns:

The custom mapped records
intoSet(RecordMapper<? super R, E>
The mapper callback
mapper)

Map results into a custom mapper callback.

public @NotNull Set<?>

Returns:

The resulting values. This may be an array type more concrete than Object[], depending on whether jOOQ has any knowledge about fieldIndex's actual type.
intoSet(int
The 0-based field index
fieldIndex)

Return all values for a field index from the result.

public <U> @NotNull Set<U>

Returns:

The resulting values.
intoSet(int
The 0-based field index
fieldIndex, Class<? extends U> type)

Return all values for a field index from the result.

public <U> @NotNull Set<U>

Returns:

The resulting values.
intoSet(int
The 0-based field index
fieldIndex, Converter<?, ? extends U> converter)

Return all values for a field index from the result.

public @NotNull Set<?>

Returns:

The resulting values. This may be an array type more concrete than Object[], depending on whether jOOQ has any knowledge about fieldName's actual type.
intoSet(String fieldName)

Return all values for a field name from the result, using field(String) for lookup.

public <U> @NotNull Set<U>

Returns:

The resulting values.
intoSet(String fieldName, Class<? extends U> type)

Return all values for a field name from the result, using field(String) for lookup.

public <U> @NotNull Set<U>

Returns:

The resulting values.
intoSet(String fieldName, Converter<?, ? extends U> converter)

Return all values for a field name from the result, using field(String) for lookup.

public @NotNull Set<?>

Returns:

The resulting values. This may be an array type more concrete than Object[], depending on whether jOOQ has any knowledge about fieldName's actual type.
intoSet(Name fieldName)

Return all values for a field name from the result, using field(Name) for lookup.

public <U> @NotNull Set<U>

Returns:

The resulting values.
intoSet(Name fieldName, Class<? extends U> type)

Return all values for a field name from the result, using field(Name) for lookup.

public <U> @NotNull Set<U>

Returns:

The resulting values.
intoSet(Name fieldName, Converter<?, ? extends U> converter)

Return all values for a field name from the result, using field(Name) for lookup.

public <T> @NotNull Set<T>

Returns:

The resulting values.
intoSet(Field<T> field)

Deprecated as a consequence of Field being deprecated.
Return all values for a field from the result, using field(Field) for lookup.
public <U> @NotNull Set<U>

Returns:

The resulting values.
intoSet(Field<?> field, Class<? extends U> type)

Deprecated as a consequence of Field being deprecated.
Return all values for a field from the result, using field(Field) for lookup.
public <T, U> @NotNull Set<U>

Returns:

The resulting values.
intoSet(Field<T> field, Converter<? super T, ? extends U> converter)

Deprecated as a consequence of Field being deprecated.
Return all values for a field from the result, using field(Field) for lookup.
public boolean
isEmpty()

Redeclares java.util.List.isEmpty.

Whether there are any records contained in this Result.
public boolean
isNotEmpty()

Whether there are any records contained in this Result.

public <E> @NotNull List<E>

Returns:

The custom mapped records
map(RecordMapper<? super R, E>
The mapper callback
mapper)

Map results into a custom mapper callback.

public <O extends UpdatableRecord<O>> @NotNull Table<O>
parents(ForeignKey<R, O> key)

Get a table expression representing the parents of all of this result's records, given a foreign key.

public @NotNull RecordType<R>
recordType()

Get this result's record type.

public <T extends Comparable<? super T>> @NotNull Result<R>

Returns:

The result itself
sortAsc(Field<T>
The sort field
field)

Deprecated as a consequence of Field being deprecated.
Sort this result by one of its contained fields, using field(Field) for lookup.
public @NotNull Result<R>

Returns:

The result itself
sortAsc(int
The 0-based sort field index
fieldIndex)

Sort this result by one of its contained fields.

public @NotNull Result<R>

Returns:

The result itself
sortAsc(String
The sort field name
fieldName)

Sort this result by one of its contained fields, using field(String) for lookup.

public @NotNull Result<R>

Returns:

The result itself
sortAsc(Name
The sort field name
fieldName)

Sort this result by one of its contained fields, using field(Name) for lookup.

public <T> @NotNull Result<R>

Returns:

The result itself
sortAsc(Field<T>
The sort field
field, Comparator<? super T>
The comparator used to sort this result.
comparator)

Deprecated as a consequence of Field being deprecated.
Sort this result by one of its contained fields using a comparator, using field(Field) for lookup.
public @NotNull Result<R>

Returns:

The result itself
sortAsc(int
The 0-based sort field index
fieldIndex, Comparator<?>
The comparator used to sort this result.
comparator)

Sort this result by one of its contained fields using a comparator.

public @NotNull Result<R>

Returns:

The result itself
sortAsc(String
The sort field name
fieldName, Comparator<?>
The comparator used to sort this result.
comparator)

Sort this result by one of its contained fields using a comparator, using field(String) for lookup.

public @NotNull Result<R>

Returns:

The result itself
sortAsc(Name
The sort field name
fieldName, Comparator<?>
The comparator used to sort this result.
comparator)

Sort this result by one of its contained fields using a comparator, using field(Name) for lookup.

public @NotNull Result<R>

Returns:

The result itself
sortAsc(Comparator<? super R>
The comparator used to sort this result.
comparator)

Sort this result using a comparator that can compare records.

public <T extends Comparable<? super T>> @NotNull Result<R>

Returns:

The result itself
sortDesc(Field<T>
The sort field
field)

Deprecated as a consequence of Field being deprecated.
Reverse-sort this result by one of its contained fields, using field(Field) for lookup.
public @NotNull Result<R>

Returns:

The result itself
sortDesc(int
The 0-based sort field index
fieldIndex)

Reverse-sort this result by one of its contained fields.

public @NotNull Result<R>

Returns:

The result itself
sortDesc(String
The sort field name
fieldName)

Reverse-sort this result by one of its contained fields, using field(String) for lookup.

public @NotNull Result<R>

Returns:

The result itself
sortDesc(Name
The sort field name
fieldName)

Reverse-sort this result by one of its contained fields, using field(Name) for lookup.

public <T> @NotNull Result<R>

Returns:

The result itself
sortDesc(Field<T>
The sort field
field, Comparator<? super T>
The comparator used to sort this result.
comparator)

Deprecated as a consequence of Field being deprecated.
Reverse-sort this result by one of its contained fields using a comparator, using field(Field) for lookup.
public @NotNull Result<R>

Returns:

The result itself
sortDesc(int
The 0-based sort field index
fieldIndex, Comparator<?>
The comparator used to sort this result.
comparator)

Reverse-sort this result by one of its contained fields using a comparator.

public @NotNull Result<R>

Returns:

The result itself
sortDesc(String
The sort field name
fieldName, Comparator<?>
The comparator used to sort this result.
comparator)

Reverse-sort this result by one of its contained fields using a comparator, using field(String) for lookup.

public @NotNull Result<R>

Returns:

The result itself
sortDesc(Name
The sort field name
fieldName, Comparator<?>
The comparator used to sort this result.
comparator)

Reverse-sort this result by one of its contained fields using a comparator, using field(Name) for lookup.

public @NotNull Result<R>

Returns:

The result itself
sortDesc(Comparator<? super R>
The comparator used to sort this result.
comparator)

Reverse-sort this result using a comparator that can compare records.

Inherited from java.util.List:
addaddaddAlladdAlladdFirstaddLastclearcontainscontainsAllcopyOfequalsgetgetFirstgetLasthashCodeindexOfiteratorlastIndexOflistIteratorlistIteratorofofofofofofofofofofofofremoveremoveremoveAllremoveFirstremoveLastreplaceAllretainAllreversedsetsizesortspliteratorsubListtoArraytoArray
Inherited from org.jooq.Attachable:
configuration
Inherited from org.jooq.Fields:
dataTypedataTypedataTypedataTypesfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldsfieldsfieldsfieldsfieldsfieldsRowfieldStreamindexOfindexOfindexOftypetypetypetypes
Inherited from org.jooq.Formattable:
formatformatformatformatformatformatformatformatformatformatChartformatChartformatChartformatChartformatChartformatChartformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatHTMLformatHTMLformatHTMLformatInsertformatInsertformatInsertformatInsertformatInsertformatInsertformatJSONformatJSONformatJSONformatJSONformatJSONformatJSONformatXMLformatXMLformatXMLformatXMLformatXMLformatXMLintoXMLintoXMLintoXMLintoXML