SelectOnStep (jOOQ 3.9.6 API)

All Known Subinterfaces:: SelectJoinPartitionByStep<R>, SelectOptionalOnStep<R>

public interface SelectOnStep<R extends Record>

This type is used for the Select's DSL API when selecting generic Record types.

Example:

 -- get all authors' first and last names, and the number
 -- of books they've written in German, if they have written
 -- more than five books in German in the last three years
 -- (from 2011), and sort those authors by last names
 -- limiting results to the second and third row

   SELECT T_AUTHOR.FIRST_NAME, T_AUTHOR.LAST_NAME, COUNT(*)
     FROM T_AUTHOR
     JOIN T_BOOK ON T_AUTHOR.ID = T_BOOK.AUTHOR_ID
    WHERE T_BOOK.LANGUAGE = 'DE'
      AND T_BOOK.PUBLISHED > '2008-01-01'
 GROUP BY T_AUTHOR.FIRST_NAME, T_AUTHOR.LAST_NAME
   HAVING COUNT(*) > 5
 ORDER BY T_AUTHOR.LAST_NAME ASC NULLS FIRST
    LIMIT 2
   OFFSET 1
      FOR UPDATE
       OF FIRST_NAME, LAST_NAME
       NO WAIT

Its equivalent in jOOQ

 create.select(TAuthor.FIRST_NAME, TAuthor.LAST_NAME, create.count())
       .from(T_AUTHOR)
       .join(T_BOOK).on(TBook.AUTHOR_ID.equal(TAuthor.ID))
       .where(TBook.LANGUAGE.equal("DE"))
       .and(TBook.PUBLISHED.greaterThan(parseDate('2008-01-01')))
       .groupBy(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
       .having(create.count().greaterThan(5))
       .orderBy(TAuthor.LAST_NAME.asc().nullsFirst())
       .limit(2)
       .offset(1)
       .forUpdate()
       .of(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
       .noWait();

Refer to the manual for more details

Author:: Lukas Eder

Method Summary

All Methods Instance Methods Abstract Methods Deprecated Methods
Modifier and Type	Method and Description
`SelectOnConditionStep<R>`	`on(Boolean condition)` Deprecated. - 3.8.0 - [#4763] - Use `on(Condition...)` or `on(Field)` instead. Due to ambiguity between calling this method using `Field.equals(Object)` argument, vs. calling the other method via a `Field.equal(Object)` argument, this method will be removed in the future.
`SelectOnConditionStep<R>`	`on(Condition... conditions)` Add an `ON` clause to the previous `JOIN`, connecting them with each other with `Operator.AND`.
`SelectOnConditionStep<R>`	`on(Field<Boolean> condition)` Add an `ON` clause to the previous `JOIN`.
`SelectOnConditionStep<R>`	`on(SQL sql)` Add an `ON` clause to the previous `JOIN`.
`SelectOnConditionStep<R>`	`on(String sql)` Add an `ON` clause to the previous `JOIN`.
`SelectOnConditionStep<R>`	`on(String sql, Object... bindings)` Add an `ON` clause to the previous `JOIN`.
`SelectOnConditionStep<R>`	`on(String sql, QueryPart... parts)` Add an `ON` clause to the previous `JOIN`.
`SelectJoinStep<R>`	`onKey()` Join the previous table on a non-ambiguous foreign key relationship between the two joined tables.
`SelectJoinStep<R>`	`onKey(ForeignKey<?,?> key)` Join the table on a non-ambiguous foreign key relationship between the two joined tables.
`SelectJoinStep<R>`	`onKey(TableField<?,?>... keyFields)` Join the previous table on a non-ambiguous foreign key relationship between the two joined tables.
`SelectJoinStep<R>`	`using(Collection<? extends Field<?>> fields)` Join the previous table with the `USING(column [, column...])`
`SelectJoinStep<R>`	`using(Field<?>... fields)` Join the previous table with the `USING(column [, column...])`

- Method Detail
  - on
```
@Support
SelectOnConditionStep<R> on(Condition... conditions)
```
    Add an ON clause to the previous JOIN, connecting them with each other with Operator.AND.
  - on
```
@Support
SelectOnConditionStep<R> on(Field<Boolean> condition)
```
    Add an ON clause to the previous JOIN.
  - on
```
@Deprecated
 @Support
SelectOnConditionStep<R> on(Boolean condition)
```
    Deprecated. - 3.8.0 - [#4763] - Use on(Condition...) or on(Field) instead. Due to ambiguity between calling this method using Field.equals(Object) argument, vs. calling the other method via a Field.equal(Object) argument, this method will be removed in the future.
    
    Add an ON clause to the previous JOIN.
  - on
```
@Support
 @PlainSQL
SelectOnConditionStep<R> on(SQL sql)
```
    Add an ON clause to the previous JOIN.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    See Also:
    
    DSL.condition(SQL), SQL
  - on
```
@Support
 @PlainSQL
SelectOnConditionStep<R> on(String sql)
```
    Add an ON clause to the previous JOIN.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    See Also:
    
    DSL.condition(String), SQL
  - on
```
@Support
 @PlainSQL
SelectOnConditionStep<R> on(String sql,
                                                  Object... bindings)
```
    Add an ON clause to the previous JOIN.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    See Also:
    
    DSL.condition(String, Object...), DSL.sql(String, Object...), SQL
  - on
```
@Support
 @PlainSQL
SelectOnConditionStep<R> on(String sql,
                                                  QueryPart... parts)
```
    Add an ON clause to the previous JOIN.
    NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
    
    See Also:
    
    DSL.condition(String, QueryPart...), DSL.sql(String, QueryPart...), SQL
  - onKey
```
@Support
SelectJoinStep<R> onKey()
                           throws DataAccessException
```
    Join the previous table on a non-ambiguous foreign key relationship between the two joined tables.
    See TableOnStep.onKey(ForeignKey) for examples.
    
    Throws:
    
    DataAccessException - If there is no non-ambiguous key definition known to jOOQ
    
    See Also:
    
    TableOnStep.onKey(ForeignKey)
  - onKey
```
@Support
SelectJoinStep<R> onKey(TableField<?,?>... keyFields)
                           throws DataAccessException
```
    Join the previous table on a non-ambiguous foreign key relationship between the two joined tables.
    See TableOnStep.onKey(ForeignKey) for examples.
    
    Throws:
    
    DataAccessException - If there is no non-ambiguous key definition known to jOOQ
    
    See Also:
    
    TableOnStep.onKey(ForeignKey)
  - onKey
```
@Support
SelectJoinStep<R> onKey(ForeignKey<?,?> key)
```
    Join the table on a non-ambiguous foreign key relationship between the two joined tables.
    See TableOnStep.onKey(ForeignKey) for examples.
    
    See Also:
    
    TableOnStep.onKey(ForeignKey)
  - using
```
@Support
SelectJoinStep<R> using(Field<?>... fields)
```
    Join the previous table with the USING(column [, column...]) syntax.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
  - using
```
@Support
SelectJoinStep<R> using(Collection<? extends Field<?>> fields)
```
    Join the previous table with the USING(column [, column...]) syntax.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.

Interface SelectOnStep<R extends Record>

Method Summary

Method Detail

on

on

on

on

on

on

on

onKey

onKey

onKey

using

using