Uses of Interface
org.jooq.Result
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
JDBC tooling.
This package contains classes related to the
SQLDialect.AURORA_POSTGRES
dialect family.This package contains classes related to the
SQLDialect.EXASOL
dialect family.This package contains classes related to the
SQLDialect.H2
dialect family.This package contains classes related to the
SQLDialect.HSQLDB
dialect family.This package contains classes related to the
SQLDialect.ORACLE
dialect family.This package contains classes related to the
SQLDialect.POSTGRES
dialect family.This package contains classes related to the
SQLDialect.REDSHIFT
dialect family.This package contains classes related to the
SQLDialect.VERTICA
dialect family.This package contains classes related to the
SQLDialect.YUGABYTEDB
dialect family.-
Uses of Result in org.jooq
Modifier and TypeMethodDescriptionCursor.fetch()
Fetch all remaining records as a result.Cursor.fetch
(int number) Deprecated, for removal: This API element is subject to removal in a future version.Execute a new query holding plain SQL.Execute a new query holding plain SQL.Execute a new query holding plain SQL.DSLContext.fetch
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return results.Execute a new query holding plain SQL.Execute and return all records forDSLContext.fetch
(Table<R> table, Collection<? extends Condition> conditions) Execute and return all records forExecute and return all records forExecute and return all records forResultQuery.fetch()
Execute the query and return the generated result.<R extends TableRecord<R>>
@NotNull Result<R>DSLContext.fetchByExample
(R example) Execute a "Query by Example" (QBE) based on an example record.ForeignKey.fetchChildren
(Collection<? extends PARENT> records) Fetch child records of a given set of records through this foreign keyForeignKey.fetchChildren
(PARENT record) Fetch child records of a given record through this foreign keyForeignKey.fetchChildren
(PARENT... records) Fetch child records of a given set of records through this foreign key<O extends TableRecord<O>>
@NotNull Result<O>Result.fetchChildren
(ForeignKey<O, R> key) Fetch child records of this record, given a foreign key, as if fetching fromchildren(ForeignKey)
.<O extends TableRecord<O>>
@NotNull Result<O>UpdatableRecord.fetchChildren
(ForeignKey<O, R> key) Fetch child records of this record, given a foreign key.DSLContext.fetchFromCSV
(String string) Fetch all data from a CSV string.DSLContext.fetchFromCSV
(String string, boolean header) Fetch all data from a CSV string.DSLContext.fetchFromCSV
(String string, boolean header, char delimiter) Fetch all data from a CSV string.DSLContext.fetchFromCSV
(String string, char delimiter) Fetch all data from a CSV string.DSLContext.fetchFromHTML
(String string) Convert an HTML table into a jOOQResult
.DSLContext.fetchFromJSON
(String string) Fetch all data from a JSON string.DSLContext.fetchFromStringData
(String[]... data) Fetch all data from a list of strings.DSLContext.fetchFromStringData
(List<String[]> data) Fetch all data from a list of strings.DSLContext.fetchFromStringData
(List<String[]> data, boolean header) Fetch all data from a list of strings.DSLContext.fetchFromTXT
(String string) Fetch all data from a formatted string.DSLContext.fetchFromTXT
(String string, String nullLiteral) Fetch all data from a formatted string.DSLContext.fetchFromXML
(String string) Fetch all data from an XML string.Map resulting records onto a custom record.Map resulting records onto a custom record.Cursor.fetchNext
(int number) Fetch the next couple of records from the cursor.ForeignKey.fetchParents
(CHILD... records) Fetch parent records of a given set of record through this foreign keyForeignKey.fetchParents
(Collection<? extends CHILD> records) Fetch parent records of a given set of record through this foreign key<O extends UpdatableRecord<O>>
@NotNull Result<O>Result.fetchParents
(ForeignKey<R, O> key) Fetch parent records of this record, given a foreign key, as if fetching fromparents(ForeignKey)
.ResultQuery.getResult()
Return the result generated by a previous call to execute().@NotNull Result<?>
StoreQuery.getResult()
The records holding returned values as specified by any of theStoreQuery.setReturning()
methods.DeleteQuery.getReturnedRecords()
The records holding returned values as specified by any of theDeleteQuery.setReturning()
methods.InsertQuery.getReturnedRecords()
The records holding returned values as specified by any of theStoreQuery.setReturning()
methods.StoreQuery.getReturnedRecords()
The records holding returned values as specified by any of theStoreQuery.setReturning()
methods.UpdateQuery.getReturnedRecords()
The records holding returned values as specified by any of theStoreQuery.setReturning()
methods.Result.intern
(int... fieldIndexes) Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.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, usingFields.field(Field)
for lookup.Result.into
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.Result.into
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.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) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.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) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.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) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<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>> 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) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<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>> 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) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<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>> 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) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<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>> 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) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<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>> 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) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<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>> 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) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<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>> 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) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<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>> 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) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<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>> 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) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<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>> 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) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<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>> 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) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<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>> 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) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.Map resulting records onto a custom record.DSLContext.newResult
(Collection<? extends Field<?>> fields) Create a new emptyRecord
.Create a new emptyRecord
.Create a new emptyResult
.Create a new emptyResult
.Create a new emptyResult
.Create a new emptyResult
.DSLContext.newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Create a new emptyResult
.DSLContext.newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Create a new emptyResult
.DSLContext.newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Create a new emptyResult
.DSLContext.newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Create a new emptyResult
.DSLContext.newResult
(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) Create a new emptyResult
.DSLContext.newResult
(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) Create a new emptyResult
.<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>> DSLContext.newResult
(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) Create a new emptyResult
.<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>> DSLContext.newResult
(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) Create a new emptyResult
.<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>> DSLContext.newResult
(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) Create a new emptyResult
.<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>> DSLContext.newResult
(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) Create a new emptyResult
.<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>> DSLContext.newResult
(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) Create a new emptyResult
.<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>> DSLContext.newResult
(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) Create a new emptyResult
.<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>> DSLContext.newResult
(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) Create a new emptyResult
.<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>> DSLContext.newResult
(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) Create a new emptyResult
.<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>> DSLContext.newResult
(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) Create a new emptyResult
.<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>> DSLContext.newResult
(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) Create a new emptyResult
.<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>> DSLContext.newResult
(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) Create a new emptyResult
.<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>> DSLContext.newResult
(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) Create a new emptyResult
.Create a new emptyResult
.@Nullable Result<?>
ExecuteContext.result()
The last result that was fetched from the result set, ornull
if no result has been fetched, including when results do not need to be buffered in aResult
type, such as allResultQuery.collect(Collector)
orResultQuery.iterator()
based fetches.ResultOrRows.result()
The result ornull
if there was no result.Result.sortAsc
(int fieldIndex) Sort this result by one of its contained fields.Result.sortAsc
(int fieldIndex, Comparator<?> comparator) Sort this result by one of its contained fields using a comparator.Sort this result by one of its contained fields, usingFields.field(String)
for lookup.Result.sortAsc
(String fieldName, Comparator<?> comparator) Sort this result by one of its contained fields using a comparator, usingFields.field(String)
for lookup.Result.sortAsc
(Comparator<? super R> comparator) Sort this result using a comparator that can compare records.<T extends Comparable<? super T>>
@NotNull Result<R>Sort this result by one of its contained fields, usingFields.field(Field)
for lookup.Result.sortAsc
(Field<T> field, Comparator<? super T> comparator) Sort this result by one of its contained fields using a comparator, usingFields.field(Field)
for lookup.Sort this result by one of its contained fields, usingFields.field(Name)
for lookup.Result.sortAsc
(Name fieldName, Comparator<?> comparator) Sort this result by one of its contained fields using a comparator, usingFields.field(Name)
for lookup.Result.sortDesc
(int fieldIndex) Reverse-sort this result by one of its contained fields.Result.sortDesc
(int fieldIndex, Comparator<?> comparator) Reverse-sort this result by one of its contained fields using a comparator.Reverse-sort this result by one of its contained fields, usingFields.field(String)
for lookup.Result.sortDesc
(String fieldName, Comparator<?> comparator) Reverse-sort this result by one of its contained fields using a comparator, usingFields.field(String)
for lookup.Result.sortDesc
(Comparator<? super R> comparator) Reverse-sort this result using a comparator that can compare records.<T extends Comparable<? super T>>
@NotNull Result<R>Reverse-sort this result by one of its contained fields, usingFields.field(Field)
for lookup.Result.sortDesc
(Field<T> field, Comparator<? super T> comparator) Reverse-sort this result by one of its contained fields using a comparator, usingFields.field(Field)
for lookup.Reverse-sort this result by one of its contained fields, usingFields.field(Name)
for lookup.Result.sortDesc
(Name fieldName, Comparator<?> comparator) Reverse-sort this result by one of its contained fields using a comparator, usingFields.field(Name)
for lookup.Modifier and TypeMethodDescriptionTableLike.asMultiset()
Turn thisTableLike
expression into aDSL.multiset(TableLike)
.TableLike.asMultiset
(String alias) Turn thisTableLike
expression into aDSL.multiset(TableLike)
.TableLike.asMultiset
(Field<?> alias) Turn thisTableLike
expression into aDSL.multiset(TableLike)
.TableLike.asMultiset
(Name alias) Turn thisTableLike
expression into aDSL.multiset(TableLike)
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(String sql) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(String sql, Object... bindings) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(String sql, QueryPart... parts) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(ResultSet rs) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(ResultSet rs, Class<?>... types) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(ResultSet rs, DataType<?>... types) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(ResultSet rs, Field<?>... fields) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, String sql) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, String sql, Object... bindings) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, String sql, QueryPart... parts) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, ResultSet rs) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, ResultSet rs, Class<?>... types) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, ResultSet rs, DataType<?>... types) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, ResultSet rs, Field<?>... fields) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Executor executor, ResultQuery<R> query) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, SQL sql) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Executor executor, Table<R> table) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Executor executor, Table<R> table, Collection<? extends Condition> conditions) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Executor executor, Table<R> table, Condition condition) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Executor executor, Table<R> table, Condition... conditions) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(ResultQuery<R> query) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(SQL sql) Fetch results in a newCompletionStage
.<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Table<R> table) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Table<R> table, Collection<? extends Condition> condition) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Table<R> table, Condition condition) Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext.fetchAsync
(Table<R> table, Condition... condition) Execute and return all records asynchronously for@NotNull CompletionStage<Result<R>>
ResultQuery.fetchAsync()
Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<R>>
ResultQuery.fetchAsync
(Executor executor) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.ResultQuery.fetchGroups
(int keyFieldIndex) Execute the query and return aMap
with one of the result's columns as key and a list of corresponding records as value.ResultQuery.fetchGroups
(int[] keyFieldIndexes) Execute the query and return aMap
with the result grouped by the given keys.ResultQuery.fetchGroups
(int[] keyFieldIndexes, int[] valueFieldIndexes) Execute the query and return aMap
with the result grouped by the given keys.ResultQuery.fetchGroups
(Class<? extends K> keyType) Execute the query and return aMap
with results grouped by the given key entity.ResultQuery.fetchGroups
(String keyFieldName) Execute the query and return aMap
with one of the result's columns as key and a list of corresponding records as value, usingFields.field(String)
for lookup.ResultQuery.fetchGroups
(String[] keyFieldNames) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(String)
for lookup.ResultQuery.fetchGroups
(String[] keyFieldNames, String[] valueFieldNames) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(String)
for lookup.ResultQuery.fetchGroups
(Field<?>[] keys) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(Field)
for lookup.ResultQuery.fetchGroups
(Field<?>[] keys, Field<?>[] values) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(Field)
for lookup.ResultQuery.fetchGroups
(Field<K> key) Execute the query and return aMap
with one of the result's columns as key and a list of corresponding records as value, usingFields.field(Field)
for lookup.ResultQuery.fetchGroups
(Name keyFieldName) Execute the query and return aMap
with one of the result's columns as key and a list of corresponding records as value, usingFields.field(Name)
for lookup.ResultQuery.fetchGroups
(Name[] keyFieldNames) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(Name)
for lookup.ResultQuery.fetchGroups
(Name[] keyFieldNames, Name[] valueFieldNames) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(Name)
for lookup.ResultQuery.fetchGroups
(RecordMapper<? super R, K> keyMapper) Execute the query and return aMap
with results grouped by the given key entity and mapped into the given entity type.ResultQuery.fetchGroups
(Table<S> table) Execute the query and return aMap
with the result grouped by the given table.ResultQuery.fetchGroups
(Table<S> keyTable, Table<T> valueTable) Execute the query and return aMap
with the result grouped by the given table.Result.intoGroups
(int keyFieldIndex) Return aMap
with one of the result's columns as key and a list of corresponding records as value.Result.intoGroups
(int[] keyFieldIndexes) Return aMap
with the result grouped by the given keys.Result.intoGroups
(int[] keyFieldIndexes, int[] valueFieldIndexes) Return aMap
with the result grouped by the given keys.Result.intoGroups
(Class<? extends K> keyType) Return aMap
with results grouped by the given key entity.Result.intoGroups
(String keyFieldName) Return aMap
with one of the result's columns as key and a list of corresponding records as value, usingFields.field(String)
for lookup.Result.intoGroups
(String[] keyFieldNames) Return aMap
with the result grouped by the given keys, usingFields.field(String)
for lookup.Result.intoGroups
(String[] keyFieldNames, String[] valueFieldNames) Return aMap
with the result grouped by the given keys, usingFields.field(String)
for lookup.Result.intoGroups
(Field<?>[] keys) Return aMap
with the result grouped by the given keys, usingFields.field(Field)
for lookup.Result.intoGroups
(Field<?>[] keys, Field<?>[] values) Return aMap
with the result grouped by the given keys, usingFields.field(Field)
for lookup.Result.intoGroups
(Field<K> key) Return aMap
with one of the result's columns as key and a list of corresponding records as value, usingFields.field(Field)
for lookup.Result.intoGroups
(Name keyFieldName) Return aMap
with one of the result's columns as key and a list of corresponding records as value, usingFields.field(Name)
for lookup.Result.intoGroups
(Name[] keyFieldNames) Return aMap
with the result grouped by the given keys, usingFields.field(Name)
for lookup.Result.intoGroups
(Name[] keyFieldNames, Name[] valueFieldNames) Return aMap
with the result grouped by the given keys, usingFields.field(Name)
for lookup.Result.intoGroups
(RecordMapper<? super R, K> keyMapper) Return aMap
with results grouped by the given key entity and mapped into the given entity type.Result.intoGroups
(Table<S> table) Return aMap
with the result grouped by the given key table.Result.intoGroups
(Table<S> keyTable, Table<T> valueTable) Return aMap
with the result grouped by the given key table.Records.intoResultGroups
(Function<? super R, ? extends K> keyMapper) Create a collector that can collectRecord
resulting from aResultQuery
into aMap
using the result of the argumentRecordMapper
as key collecting the records themselves into aResult
.Records.intoResultGroups
(Function<? super R, ? extends K> keyMapper, Function<? super R, ? extends V> valueMapper) Create a collector that can collectRecord
resulting from aResultQuery
into aMap
using the result of the argumentRecordMapper
as key collecting the result of another argumentRecordMapper
into aResult
of values.Modifier and TypeMethodDescription@NotNull Condition
Create a condition to check this field against several values from a previous query.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Row17.in
(Result<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> result) Compare this row value expression with a set of records for equality.@NotNull Condition
Row18.in
(Result<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> result) Compare this row value expression with a set of records for equality.@NotNull Condition
Row19.in
(Result<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> result) Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Row20.in
(Result<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> result) Compare this row value expression with a set of records for equality.@NotNull Condition
Row21.in
(Result<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> result) Compare this row value expression with a set of records for equality.@NotNull Condition
Row22.in
(Result<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> result) Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Create a condition to check this field against several values from a previous query.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Row16.notIn
(Result<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> result) Compare this row value expression with a set of records for equality.@NotNull Condition
Row17.notIn
(Result<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> result) Compare this row value expression with a set of records for equality.@NotNull Condition
Row18.notIn
(Result<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> result) Compare this row value expression with a set of records for equality.@NotNull Condition
Row19.notIn
(Result<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> result) Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Row20.notIn
(Result<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> result) Compare this row value expression with a set of records for equality.@NotNull Condition
Row21.notIn
(Result<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> result) Compare this row value expression with a set of records for equality.@NotNull Condition
Row22.notIn
(Result<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> result) Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a set of records for equality.void
Set the last result that was fetched from the result set. -
Uses of Result in org.jooq.impl
Modifier and TypeMethodDescriptionDefaultDSLContext.fetch
(ResultQuery<R> query) DefaultDSLContext.fetch
(Table<R> table, Collection<? extends Condition> conditions) <R extends TableRecord<R>>
Result<R>DefaultDSLContext.fetchByExample
(R example) final <O extends TableRecord<O>>
Result<O>UpdatableRecordImpl.fetchChildren
(ForeignKey<O, R> key) DefaultDSLContext.fetchFromCSV
(String string) DefaultDSLContext.fetchFromCSV
(String string, boolean header) DefaultDSLContext.fetchFromCSV
(String string, boolean header, char delimiter) DefaultDSLContext.fetchFromCSV
(String string, char delimiter) DefaultDSLContext.fetchFromHTML
(String string) DefaultDSLContext.fetchFromJSON
(String string) DefaultDSLContext.fetchFromStringData
(String[]... strings) DefaultDSLContext.fetchFromStringData
(List<String[]> strings) DefaultDSLContext.fetchFromStringData
(List<String[]> strings, boolean header) DefaultDSLContext.fetchFromTXT
(String string) DefaultDSLContext.fetchFromTXT
(String string, String nullLiteral) DefaultDSLContext.fetchFromXML
(String string) DefaultDSLContext.newResult
(Collection<? extends Field<?>> fields) DefaultDSLContext.newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) DefaultDSLContext.newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) DefaultDSLContext.newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) DefaultDSLContext.newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) DefaultDSLContext.newResult
(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) DefaultDSLContext.newResult
(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) DefaultDSLContext.newResult
(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) <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
Result<Record12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> DefaultDSLContext.newResult
(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) <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
Result<Record13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> DefaultDSLContext.newResult
(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) <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
Result<Record14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> DefaultDSLContext.newResult
(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) <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
Result<Record15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> DefaultDSLContext.newResult
(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) <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
Result<Record16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> DefaultDSLContext.newResult
(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) <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
Result<Record17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> DefaultDSLContext.newResult
(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) <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
Result<Record18<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> DefaultDSLContext.newResult
(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) <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
Result<Record19<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> DefaultDSLContext.newResult
(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) <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
Result<Record20<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> DefaultDSLContext.newResult
(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) <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
Result<Record21<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> DefaultDSLContext.newResult
(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) <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
Result<Record22<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> DefaultDSLContext.newResult
(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) Internal.result
(R record) Create an empty result from aRecord
using its row type.Modifier and TypeMethodDescriptionDefaultDSLContext.fetchAsync
(String sql) DefaultDSLContext.fetchAsync
(String sql, Object... bindings) DefaultDSLContext.fetchAsync
(String sql, QueryPart... parts) DefaultDSLContext.fetchAsync
(ResultSet rs) DefaultDSLContext.fetchAsync
(ResultSet rs, Class<?>... types) DefaultDSLContext.fetchAsync
(ResultSet rs, DataType<?>... types) DefaultDSLContext.fetchAsync
(ResultSet rs, Field<?>... fields) DefaultDSLContext.fetchAsync
(Executor executor, String sql) DefaultDSLContext.fetchAsync
(Executor executor, String sql, Object... bindings) DefaultDSLContext.fetchAsync
(Executor executor, String sql, QueryPart... parts) DefaultDSLContext.fetchAsync
(Executor executor, ResultSet rs) DefaultDSLContext.fetchAsync
(Executor executor, ResultSet rs, Class<?>... types) DefaultDSLContext.fetchAsync
(Executor executor, ResultSet rs, DataType<?>... types) DefaultDSLContext.fetchAsync
(Executor executor, ResultSet rs, Field<?>... fields) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Executor executor, ResultQuery<R> query) DefaultDSLContext.fetchAsync
(Executor executor, SQL sql) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Executor executor, Table<R> table) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Executor executor, Table<R> table, Collection<? extends Condition> conditions) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Executor executor, Table<R> table, Condition condition) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Executor executor, Table<R> table, Condition... conditions) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(ResultQuery<R> query) DefaultDSLContext.fetchAsync
(SQL sql) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Table<R> table) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Table<R> table, Collection<? extends Condition> conditions) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Table<R> table, Condition condition) <R extends Record>
CompletionStage<Result<R>>DefaultDSLContext.fetchAsync
(Table<R> table, Condition... conditions) Get theMULTISET
operator to nest subqueries.static @NotNull ArrayAggOrderByStep<Result<Record>>
DSL.multisetAgg
(Collection<? extends SelectField<?>> fields) Get theMULTISET_AGG
aggregate function to nest group contents.static @NotNull ArrayAggOrderByStep<Result<Record>>
DSL.multisetAgg
(Field<?>... fields) static @NotNull ArrayAggOrderByStep<Result<Record>>
DSL.multisetAgg
(SelectField<?>... fields) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1> @NotNull ArrayAggOrderByStep<Result<Record1<T1>>>
DSL.multisetAgg
(SelectField<T1> field1) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2> @NotNull ArrayAggOrderByStep<Result<Record2<T1, T2>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3>
@NotNull ArrayAggOrderByStep<Result<Record3<T1,T2, T3>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4>
@NotNull ArrayAggOrderByStep<Result<Record4<T1,T2, T3, T4>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4) Get theMULTISET_AGG
aggregate function to nest group contents.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 theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6>
@NotNull ArrayAggOrderByStep<Result<Record6<T1,T2, T3, T4, T5, T6>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7>
@NotNull ArrayAggOrderByStep<Result<Record7<T1,T2, T3, T4, T5, T6, T7>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull ArrayAggOrderByStep<Result<Record8<T1,T2, T3, T4, T5, T6, T7, T8>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull ArrayAggOrderByStep<Result<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull ArrayAggOrderByStep<Result<Record10<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull ArrayAggOrderByStep<Result<Record11<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull ArrayAggOrderByStep<Result<Record12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull ArrayAggOrderByStep<Result<Record13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull ArrayAggOrderByStep<Result<Record14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull ArrayAggOrderByStep<Result<Record15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull ArrayAggOrderByStep<Result<Record16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull ArrayAggOrderByStep<Result<Record17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull ArrayAggOrderByStep<Result<Record18<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull ArrayAggOrderByStep<Result<Record19<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull ArrayAggOrderByStep<Result<Record20<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull ArrayAggOrderByStep<Result<Record21<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull ArrayAggOrderByStep<Result<Record22<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22) Get theMULTISET_AGG
aggregate function to nest group contents.static @NotNull ArrayAggOrderByStep<Result<Record>>
DSL.multisetAggDistinct
(Collection<? extends Field<?>> fields) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static @NotNull ArrayAggOrderByStep<Result<Record>>
DSL.multisetAggDistinct
(Field<?>... fields) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1> @NotNull ArrayAggOrderByStep<Result<Record1<T1>>>
DSL.multisetAggDistinct
(SelectField<T1> field1) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2> @NotNull ArrayAggOrderByStep<Result<Record2<T1, T2>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3>
@NotNull ArrayAggOrderByStep<Result<Record3<T1,T2, T3>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4>
@NotNull ArrayAggOrderByStep<Result<Record4<T1,T2, T3, T4>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4) Get theMULTISET_AGG(DISTINCT)
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 theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6>
@NotNull ArrayAggOrderByStep<Result<Record6<T1,T2, T3, T4, T5, T6>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7>
@NotNull ArrayAggOrderByStep<Result<Record7<T1,T2, T3, T4, T5, T6, T7>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull ArrayAggOrderByStep<Result<Record8<T1,T2, T3, T4, T5, T6, T7, T8>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull ArrayAggOrderByStep<Result<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull ArrayAggOrderByStep<Result<Record10<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull ArrayAggOrderByStep<Result<Record11<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull ArrayAggOrderByStep<Result<Record12<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull ArrayAggOrderByStep<Result<Record13<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull ArrayAggOrderByStep<Result<Record14<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull ArrayAggOrderByStep<Result<Record15<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull ArrayAggOrderByStep<Result<Record16<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull ArrayAggOrderByStep<Result<Record17<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull ArrayAggOrderByStep<Result<Record18<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull ArrayAggOrderByStep<Result<Record19<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull ArrayAggOrderByStep<Result<Record20<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull ArrayAggOrderByStep<Result<Record21<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull ArrayAggOrderByStep<Result<Record22<T1,T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents. -
Uses of Result in org.jooq.tools.jdbc
Modifier and TypeFieldDescriptionfinal Result<?>
MockResult.data
The result data associated with this execution result.Modifier and TypeMethodDescriptionstatic final MockDataProvider
Create a newMockDataProvider
that always returns the same result for all queries.ModifierConstructorDescriptionMockResult
(int rows, Result<?> data) Create a newMockResult
.MockResultSet
(Result<?> result) MockResultSet
(Result<?> result, int maxRows) -
Uses of Result in org.jooq.util.aurorapostgres
-
Uses of Result in org.jooq.util.exasol
-
Uses of Result in org.jooq.util.h2
-
Uses of Result in org.jooq.util.hsqldb
-
Uses of Result in org.jooq.util.oracle
Modifier and TypeFieldDescriptionOracleDataType.REF_CURSOR
Deprecated, for removal: This API element is subject to removal in a future version. -
Uses of Result in org.jooq.util.postgres
-
Uses of Result in org.jooq.util.redshift
-
Uses of Result in org.jooq.util.vertica
-
Uses of Result in org.jooq.util.yugabytedb
Cursor.fetchNext(int)
instead.