Uses of Interface org.jooq.SelectFieldOrAsterisk (jOOQ 3.15.12 API)

Package

Description

This package contains jOOQ's public API.

org.jooq.impl

This package contains jOOQ's implementation classes.

Uses of SelectFieldOrAsterisk in org.jooq

Subinterfaces of SelectFieldOrAsterisk in org.jooq

Modifier and Type

Interface

Description

interface

AggregateFilterStep<T>

The step in the specification of aggregate functions where the SQL:2003 standard FILTER clause can be added.

interface

AggregateFunction<T>

An aggregate function.

interface

ArrayAggOrderByStep<T>

The SQL standard ARRAY_AGG() function.

interface

Asterisk

An unqualified asterisk.

interface

CaseConditionStep<T>

The final step in creating a case statement of the type
interface CaseWhenStep<V,T> The final step in creating a case statement of the type interface Field<T> A column expression. interface GroupConcatOrderByStep MySQL's GROUP_CONCAT function. interface GroupConcatSeparatorStep MySQL's GROUP_CONCAT function. interface JSONArrayAggNullStep<T> A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the NULL clause can be defined. interface JSONArrayAggOrderByStep<J> A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the ORDER BY clause can be defined. interface JSONArrayAggReturningStep<T> A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the RETURNING clause can be defined. interface JSONArrayNullStep<T> A step in the construction of the JSON ARRAY function. interface JSONArrayReturningStep<T> A step in the construction of the JSON ARRAY function. interface JSONObjectAggNullStep<T> A step in the construction of DSL.jsonObjectAgg(JSONEntry) or DSL.jsonbObjectAgg(JSONEntry) functions where the NULL clause can be defined. interface JSONObjectAggReturningStep<T> A step in the construction of DSL.jsonObjectAgg(JSONEntry) or DSL.jsonbObjectAgg(JSONEntry) functions where the RETURNING clause can be defined. interface JSONObjectNullStep<T> A step in the construction of the JSON OBJECT function. interface JSONObjectReturningStep<T> A step in the construction of the JSON OBJECT function. interface JSONValueOnStep<J> A step in the construction of DSL.jsonValue(Field, Field) or DSL.jsonbValue(Field, Field) functions where the ON EMPTY and ON ERROR clauses can be defined. interface JSONValueReturningStep<T> A step in the construction of the JSON VALUE function. interface Param<T> A named parameter and/or bind value. interface Parameter<T> A parameter to a stored procedure or function. interface ParamOrVariable<T> A common super type of Param and Variable. interface QualifiedAsterisk A qualified asterisk. interface Row1<T1> A row value expression. interface Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> A row value expression. interface Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> A row value expression. interface Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> A row value expression. interface Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> A row value expression. interface Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> A row value expression. interface Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> A row value expression. interface Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> A row value expression. interface Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> A row value expression. interface Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> A row value expression. interface Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> A row value expression. interface Row2<T1,T2> A row value expression. interface Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> A row value expression. interface Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> A row value expression. interface Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> A row value expression. interface Row3<T1,T2,T3> A row value expression. interface Row4<T1,T2,T3,T4> A row value expression. interface Row5<T1,T2,T3,T4,T5> A row value expression. interface Row6<T1,T2,T3,T4,T5,T6> A row value expression. interface Row7<T1,T2,T3,T4,T5,T6,T7> A row value expression. interface Row8<T1,T2,T3,T4,T5,T6,T7,T8> A row value expression. interface Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> A row value expression. interface RowN A row value expression. interface SelectField<T> A QueryPart to be used exclusively in SELECT clauses. interface TableField<R extends Record,T> A field contained in a table. interface UDTField<R extends UDTRecord<R>,T> A field contained in a UDT. interface Variable<T> A local variable reference. interface WindowBeforeOverStep<T> This type is used for the window function DSL API. interface WindowExcludeStep<T> This type is used for the window function DSL API. interface WindowFinalStep<T> Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future. interface WindowOrderByStep<T> This type is used for the window function DSL API. interface WindowPartitionByStep<T> This type is used for the window function DSL API. interface WindowRowsStep<T> This type is used for the window function DSL API. interface XMLAggOrderByStep<T> The SQL standard ARRAY_AGG() function.
Methods in org.jooq with parameters of type SelectFieldOrAsterisk Modifier and Type Method Description void SelectQuery.addDistinctOn(SelectFieldOrAsterisk... fields) Add a PostgreSQL-specific DISTINCT ON (fields...) clause. void SelectQuery.addSelect(SelectFieldOrAsterisk... fields) Add a list of select fields. @NotNull SelectIntoStep<R> SelectDistinctOnStep.distinctOn(SelectFieldOrAsterisk... fields) Add the PostgreSQL-specific ON(...) clause to a SELECT DISTINCT ON (...) statement. @NotNull SelectIntoStep<R> SelectDistinctOnStep.on(SelectFieldOrAsterisk... fields) Add the PostgreSQL-specific ON(...) clause to a SELECT DISTINCT ON (...) statement. @NotNull DeleteResultStep<R> DeleteReturningStep.returning(SelectFieldOrAsterisk... fields) Configure the DELETE statement to return a list of fields in R. @NotNull InsertResultStep<R> InsertReturningStep.returning(SelectFieldOrAsterisk... fields) Configure the INSERT statement to return a list of fields in R. @NotNull UpdateResultStep<R> UpdateReturningStep.returning(SelectFieldOrAsterisk... fields) Configure the UPDATE statement to return a list of fields in R. @NotNull DeleteResultStep<Record> DeleteReturningStep.returningResult(SelectFieldOrAsterisk... fields) Configure the DELETE statement to return a list of fields in R. @NotNull InsertResultStep<Record> InsertReturningStep.returningResult(SelectFieldOrAsterisk... fields) Configure the INSERT statement to return a list of fields in R. @NotNull UpdateResultStep<Record> UpdateReturningStep.returningResult(SelectFieldOrAsterisk... fields) Configure the UPDATE statement to return a list of fields in R. @NotNull SelectSelectStep<Record> DSLContext.select(SelectFieldOrAsterisk... fields) Create a new DSL select statement. @NotNull SelectSelectStep<Record> SelectSelectStep.select(SelectFieldOrAsterisk... fields) Add additional fields to the SELECT clause of this query @NotNull SelectSelectStep<Record> WithStep.select(SelectFieldOrAsterisk... fields) Create a new DSL select statement. @NotNull SelectSelectStep<Record> DSLContext.selectDistinct(SelectFieldOrAsterisk... fields) Create a new DSL select statement. @NotNull SelectSelectStep<Record> WithStep.selectDistinct(SelectFieldOrAsterisk... fields) Create a new DSL select statement. void DeleteQuery.setReturning(SelectFieldOrAsterisk... fields) Configure the DELETE statement to return a list of fields in R. void InsertQuery.setReturning(SelectFieldOrAsterisk... fields) Configure the INSERT or UPDATE statement to return a list of fields in R. void StoreQuery.setReturning(SelectFieldOrAsterisk... fields) Configure the INSERT or UPDATE statement to return a list of fields in R. void UpdateQuery.setReturning(SelectFieldOrAsterisk... fields) Configure the INSERT or UPDATE statement to return a list of fields in R. Method parameters in org.jooq with type arguments of type SelectFieldOrAsterisk Modifier and Type Method Description void SelectQuery.addDistinctOn(Collection<? extends SelectFieldOrAsterisk> fields) Add a PostgreSQL-specific DISTINCT ON (fields...) clause. void SelectQuery.addSelect(Collection<? extends SelectFieldOrAsterisk> fields) Add a list of select fields. @NotNull SelectIntoStep<R> SelectDistinctOnStep.distinctOn(Collection<? extends SelectFieldOrAsterisk> fields) Add the PostgreSQL-specific ON(...) clause to a SELECT DISTINCT ON (...) statement. @NotNull SelectIntoStep<R> SelectDistinctOnStep.on(Collection<? extends SelectFieldOrAsterisk> fields) Add the PostgreSQL-specific ON(...) clause to a SELECT DISTINCT ON (...) statement. @NotNull DeleteResultStep<R> DeleteReturningStep.returning(Collection<? extends SelectFieldOrAsterisk> fields) Configure the DELETE statement to return a list of fields in R. @NotNull InsertResultStep<R> InsertReturningStep.returning(Collection<? extends SelectFieldOrAsterisk> fields) Configure the INSERT statement to return a list of fields in R. @NotNull UpdateResultStep<R> UpdateReturningStep.returning(Collection<? extends SelectFieldOrAsterisk> fields) Configure the UPDATE statement to return a list of fields in R. @NotNull DeleteResultStep<Record> DeleteReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields) Configure the DELETE statement to return a list of fields in R. @NotNull InsertResultStep<Record> InsertReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields) Configure the INSERT statement to return a list of fields in R. @NotNull UpdateResultStep<Record> UpdateReturningStep.returningResult(Collection<? extends SelectFieldOrAsterisk> fields) Configure the UPDATE statement to return a list of fields in R. @NotNull SelectSelectStep<Record> DSLContext.select(Collection<? extends SelectFieldOrAsterisk> fields) Create a new DSL select statement. @NotNull SelectSelectStep<Record> SelectSelectStep.select(Collection<? extends SelectFieldOrAsterisk> fields) Add additional fields to the SELECT clause of this query @NotNull SelectSelectStep<Record> WithStep.select(Collection<? extends SelectFieldOrAsterisk> fields) Create a new DSL select statement. @NotNull SelectSelectStep<Record> DSLContext.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields) Create a new DSL select statement. @NotNull SelectSelectStep<Record> WithStep.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields) Create a new DSL select statement. void DeleteQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields) Configure the DELETE statement to return a list of fields in R. void InsertQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields) Configure the INSERT or UPDATE statement to return a list of fields in R. void StoreQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields) Configure the INSERT or UPDATE statement to return a list of fields in R. void UpdateQuery.setReturning(Collection<? extends SelectFieldOrAsterisk> fields) Configure the INSERT or UPDATE statement to return a list of fields in R.




Uses of SelectFieldOrAsterisk in org.jooq.impl
Classes in org.jooq.impl that implement SelectFieldOrAsterisk

Modifier and Type
Class
Description
class 
CustomField<T>

A base class for custom Field implementations in client code.


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

Modifier and Type
Method
Description
static @NotNull AggregateFunction<Integer>
DSL.count(SelectFieldOrAsterisk field)

Get the count(field) function.

static @NotNull AggregateFunction<Integer>
DSL.countDistinct(SelectFieldOrAsterisk field)

Get the count(distinct field) function.

SelectSelectStep<Record>
DefaultDSLContext.select(SelectFieldOrAsterisk... fields)
 
static @NotNull SelectSelectStep<Record>
DSL.select(SelectFieldOrAsterisk... fields)

Create a new DSL subselect statement.

SelectSelectStep<Record>
DefaultDSLContext.selectDistinct(SelectFieldOrAsterisk... fields)
 
static @NotNull SelectSelectStep<Record>
DSL.selectDistinct(SelectFieldOrAsterisk... fields)

Create a new DSL subselect statement.


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

Modifier and Type
Method
Description
SelectSelectStep<Record>
DefaultDSLContext.select(Collection<? extends SelectFieldOrAsterisk> fields)
 
static @NotNull SelectSelectStep<Record>
DSL.select(Collection<? extends SelectFieldOrAsterisk> fields)

Create a new DSL subselect statement.

SelectSelectStep<Record>
DefaultDSLContext.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
 
static @NotNull SelectSelectStep<Record>
DSL.selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)

Create a new DSL subselect statement.

Uses of Interfaceorg.jooq.SelectFieldOrAsterisk

Uses of SelectFieldOrAsterisk in org.jooq

Uses of SelectFieldOrAsterisk in org.jooq.impl

Uses of Interface
org.jooq.SelectFieldOrAsterisk