Top Fields Constructors Methods
org.jooq.impl

pack-priv final Class CaseSearched<T>

extends AbstractField<T>
implements CaseConditionStep<T>, QOM.CaseSearched<T>
Class Inheritance
All Implemented Interfaces
org.jooq.impl.QOM.CaseSearched, org.jooq.impl.QOM.UOperator2, org.jooq.impl.QOM.UOperator, org.jooq.QueryPart, java.io.Serializable, org.jooq.Field, org.jooq.TableElement, org.jooq.Named, org.jooq.FieldOrConstraint, org.jooq.FieldOrRowOrSelect, org.jooq.FieldOrRow, org.jooq.OrderField, org.jooq.GroupField, org.jooq.SelectField, org.jooq.Typed, org.jooq.SelectFieldOrAsterisk, org.jooq.CaseConditionStep
Static Imports
java.lang.Boolean.TRUE, org.jooq.impl.DSL.inline, .DSL.one, .DSL.select, .Keywords.K_CASE, .Keywords.K_ELSE, .Keywords.K_END, .Keywords.K_NULL, .Keywords.K_SWITCH, .Keywords.K_THEN, .Keywords.K_TRUE, .Keywords.K_WHEN, .Names.NQ_CASE, .Tools.BooleanDataKey.DATA_FORCE_CASE_ELSE_NULL

Deprecated

as a consequence of AbstractField, CaseConditionStep and QOM.CaseSearched being deprecated. See corresponding docs for further information.

Author
Lukas Eder

Field Summary

Modifier and TypeField and Description
private Field<T>
else_

Deprecated as a consequence of Field being deprecated.
private final List<QOM.Tuple2<Condition, Field<T>>>
when

Constructor Summary

AccessConstructor and Description
pack-priv
CaseSearched(DataType<T> type)

pack-priv
CaseSearched(Condition condition, Field<T> result)

Deprecated as a consequence of Condition and Field being deprecated.

Method Summary

Modifier and TypeMethod and Description
public final QOM.UnmodifiableList<? extends QOM.Tuple2<Condition, Field<T>>>
$arg1()

Implements org.jooq.impl.QOM.UOperator2.$arg1.

public final CaseSearched<T>
$arg1(QOM.UnmodifiableList<? extends QOM.Tuple2<Condition, Field<T>>> w)

Overrides default org.jooq.impl.QOM.UOperator2.$arg1.

Deprecated as a consequence of CaseSearched being deprecated.
public final Field<T>
$arg2()

Implements org.jooq.impl.QOM.UOperator2.$arg2.

Deprecated as a consequence of Field being deprecated.
public final CaseSearched<T>
$arg2(Field<T> e)

Overrides default org.jooq.impl.QOM.UOperator2.$arg2.

Deprecated as a consequence of Field and CaseSearched being deprecated.
public final Function2<? super QOM.UnmodifiableList<? extends QOM.Tuple2<Condition, Field<T>>>, ? super Field<T>, ? extends CaseSearched<T>>
$constructor()

Implements org.jooq.impl.QOM.UOperator2.$constructor.

public final void
accept(Context<?> ctx)

Implements abstract org.jooq.impl.AbstractField.accept.

Implements org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.
private final void
acceptNative(Context<?> ctx)

public final Field<T>
else_(T
The result value if no other value matches the case
result)

Implements org.jooq.CaseConditionStep.else_.

Deprecated as a consequence of Field being deprecated.
Add an else clause to the already constructed case statement
public final Field<T>
else_(Field<T>
The result value if no other value matches the case
result)

Implements org.jooq.CaseConditionStep.else_, org.jooq.CaseConditionStep.else_.

Deprecated as a consequence of Field being deprecated.
Add an else clause to the already constructed case statement
public final Field<T>
else_(Select<? extends Record1<T>>
The result value if no other value matches the case
result)

Implements org.jooq.CaseConditionStep.else_, org.jooq.CaseConditionStep.else_.

Deprecated as a consequence of Field being deprecated.
Add an else clause to the already constructed case statement
public final Field<T>
otherwise(T
The result value if no other value matches the case
result)

Implements org.jooq.CaseConditionStep.otherwise.

Deprecated as a consequence of Field being deprecated.
Add an else clause to the already constructed case statement
public final Field<T>
otherwise(Field<T>
The result value if no other value matches the case
result)

Implements org.jooq.CaseConditionStep.otherwise, org.jooq.CaseConditionStep.otherwise.

Deprecated as a consequence of Field being deprecated.
Add an else clause to the already constructed case statement
public final Field<T>
otherwise(Select<? extends Record1<T>>
The result value if no other value matches the case
result)

Implements org.jooq.CaseConditionStep.otherwise, org.jooq.CaseConditionStep.otherwise.

Deprecated as a consequence of Field being deprecated.
Add an else clause to the already constructed case statement
public final CaseConditionStep<T>
when(Condition
The condition to add to the case statement
condition, T
The result value if the condition holds true
result)

Implements org.jooq.CaseConditionStep.when.

Deprecated as a consequence of Condition and CaseConditionStep being deprecated.
Compare a condition to the already constructed case statement, return result if the condition holds true
public final CaseConditionStep<T>
when(Condition
The condition to add to the case statement
condition, Field<T>
The result value if the condition holds true
result)

Implements org.jooq.CaseConditionStep.when, org.jooq.CaseConditionStep.when.

Deprecated as a consequence of Condition, Field and CaseConditionStep being deprecated.
Compare a condition to the already constructed case statement, return result if the condition holds true
public final CaseConditionStep<T>
when(Condition
The condition to add to the case statement
condition, Select<? extends Record1<T>>
The result value if the condition holds true
result)

Implements org.jooq.CaseConditionStep.when, org.jooq.CaseConditionStep.when.

Deprecated as a consequence of Condition and CaseConditionStep being deprecated.
Compare a condition to the already constructed case statement, return result if the condition holds true
public final CaseConditionStep<T>
when(Field<Boolean>
The condition to add to the case statement
condition, T
The result value if the condition holds true
result)

Implements org.jooq.CaseConditionStep.when.

Deprecated as a consequence of Field and CaseConditionStep being deprecated.
Compare a condition to the already constructed case statement, return result if the condition holds true
public final CaseConditionStep<T>
when(Field<Boolean>
The condition to add to the case statement
condition, Field<T>
The result value if the condition holds true
result)

Implements org.jooq.CaseConditionStep.when, org.jooq.CaseConditionStep.when.

Deprecated as a consequence of Field and CaseConditionStep being deprecated.
Compare a condition to the already constructed case statement, return result if the condition holds true
public final CaseConditionStep<T>
when(Field<Boolean>
The condition to add to the case statement
condition, Select<? extends Record1<T>>
The result value if the condition holds true
result)

Implements org.jooq.CaseConditionStep.when, org.jooq.CaseConditionStep.when.

Deprecated as a consequence of Field and CaseConditionStep being deprecated.
Compare a condition to the already constructed case statement, return result if the condition holds true
Inherited from org.jooq.impl.AbstractField:
$alias$aliasedabsacosaddaddasasasasascasciiasinatanatan2atan2avgavgOverbetweenbetweenbetweenbetweenbetweenSymmetricbetweenSymmetricbetweenSymmetricbetweenSymmetricbitAndbitAndbitLengthbitNandbitNandbitNorbitNorbitNotbitOrbitOrbitXNorbitXNorbitXorbitXorcastcastcastceilchangedcharLengthclausescoalescecoalescecoercecoercecoercecollatecollatecollatecommentcommentcomparecomparecomparecompareconcatconcatconcatcontainscontainscontainsIgnoreCasecontainsIgnoreCaseconvertconvertconvertconvertFromconvertFromconvertToconvertTocoscoshcotcothcountcountDistinctcountOverdecodedecodedecodedecodedegdescdivdivdividedivideendsWithendsWithendsWithIgnoreCaseendsWithIgnoreCaseeqeqeqeqequalequalequalequalequalIgnoreCaseequalIgnoreCaseexpextractfieldfirstValuefloorfromgegegegegetgetValuegreaterOrEqualgreaterOrEqualgreaterOrEqualgreaterOrEqualgreaterThangreaterThangreaterThangreaterThangreatestgreatestgtgtgtgtinininininisDistinctFromisDistinctFromisDistinctFromisDocumentisFalseisJsonisNotDistinctFromisNotDistinctFromisNotDistinctFromisNotDocumentisNotJsonisNotNullisNullisNullableisPossiblyNullableisTruelaglaglaglaglastValueleleleleleadleadleadleadleastleastlengthlessOrEquallessOrEquallessOrEquallessOrEquallessThanlessThanlessThanlessThanlikelikelikelikelikelikeIgnoreCaselikeIgnoreCaselikeIgnoreCaselikeIgnoreCaselikeRegexlikeRegexlnloglowerlpadlpadlpadlpadltltltltltrimmaxmaxOvermedianminminOverminusminusmodmodmodulomodulomulmulmultiplymultiplynenenenenegnotBetweennotBetweennotBetweennotBetweennotBetweenSymmetricnotBetweenSymmetricnotBetweenSymmetricnotBetweenSymmetricnotContainsnotContainsnotContainsIgnoreCasenotContainsIgnoreCasenotEqualnotEqualnotEqualnotEqualnotEqualIgnoreCasenotEqualIgnoreCasenotInnotInnotInnotInnotInnotLikenotLikenotLikenotLikenotLikenotLikeIgnoreCasenotLikeIgnoreCasenotLikeIgnoreCasenotLikeIgnoreCasenotLikeRegexnotLikeRegexnotSimilarTonotSimilarTonotSimilarTonotSimilarTonotSimilarTonullifnullifnullsFirstnullsLastnvlnvlnvl2nvl2octetLengthoriginalparenthesisedpluspluspositionpositionpowpowpowerpowerprojectionSizeradremremrepeatrepeatreplacereplacereplacereplaceresetroundroundrpadrpadrpadrpadrtrimshlshlshrshrsignsimilarTosimilarTosimilarTosimilarTosimilarTosinsinhsortsortsortAscsortAscsortDefaultsortDescsortDescsqrtstartsWithstartsWithstartsWithIgnoreCasestartsWithIgnoreCasestddevPopstddevPopOverstddevSampstddevSampOversubsubsubstringsubstringsubstringsubstringsubtractsubtractsumsumOvertantanhtimestimestrimunaryMinusunaryPlusuppervarPopvarPopOvervarSampvarSampOver

Field Detail

else_back to summary
private Field<T> else_

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

whenback to summary
private final List<QOM.Tuple2<Condition, Field<T>>> when

Constructor Detail

CaseSearchedback to summary
pack-priv CaseSearched(DataType<T> type)
CaseSearchedback to summary
pack-priv CaseSearched(Condition condition, Field<T> result)

Deprecated

as a consequence of Condition and Field being deprecated. See corresponding docs for further information.

Method Detail

$arg1back to summary
public final QOM.UnmodifiableList<? extends QOM.Tuple2<Condition, Field<T>>> $arg1()

Implements org.jooq.impl.QOM.UOperator2.$arg1.

Annotations
@Override
$arg1back to summary
public final CaseSearched<T> $arg1(QOM.UnmodifiableList<? extends QOM.Tuple2<Condition, Field<T>>> w)

Overrides default org.jooq.impl.QOM.UOperator2.$arg1.

Deprecated

as a consequence of CaseSearched being deprecated. See corresponding docs for further information.

Annotations
@Override
$arg2back to summary
public final Field<T> $arg2()

Implements org.jooq.impl.QOM.UOperator2.$arg2.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Annotations
@Override
$arg2back to summary
public final CaseSearched<T> $arg2(Field<T> e)

Overrides default org.jooq.impl.QOM.UOperator2.$arg2.

Deprecated

as a consequence of Field and CaseSearched being deprecated. See corresponding docs for further information.

Annotations
@Override
$constructorback to summary
public final Function2<? super QOM.UnmodifiableList<? extends QOM.Tuple2<Condition, Field<T>>>, ? super Field<T>, ? extends CaseSearched<T>> $constructor()

Implements org.jooq.impl.QOM.UOperator2.$constructor.

Annotations
@Override
acceptback to summary
public final void accept(Context<?> ctx)

Implements abstract org.jooq.impl.AbstractField.accept.

Implements org.jooq.QueryPartInternal.accept.

Doc from org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.

Annotations
@Override
acceptNativeback to summary
private final void acceptNative(Context<?> ctx)
else_back to summary
public final Field<T> else_(T result)

Implements org.jooq.CaseConditionStep.else_.

Doc from org.jooq.CaseConditionStep.else_.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add an else clause to the already constructed case statement

Parameters
result:T

The result value if no other value matches the case

Returns:Field<T>

The resulting field from case statement construction

Annotations
@Override
else_back to summary
public final Field<T> else_(Field<T> result)

Implements org.jooq.CaseConditionStep.else_, org.jooq.CaseConditionStep.else_.

Doc from org.jooq.CaseConditionStep.else_.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add an else clause to the already constructed case statement

Parameters
result:Field<T>

The result value if no other value matches the case

Returns:Field<T>

The resulting field from case statement construction

Annotations
@Override
else_back to summary
public final Field<T> else_(Select<? extends Record1<T>> result)

Implements org.jooq.CaseConditionStep.else_, org.jooq.CaseConditionStep.else_.

Doc from org.jooq.CaseConditionStep.else_.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add an else clause to the already constructed case statement

Parameters
result:Select<? extends Record1<T>>

The result value if no other value matches the case

Returns:Field<T>

The resulting field from case statement construction

Annotations
@Override
otherwiseback to summary
public final Field<T> otherwise(T result)

Implements org.jooq.CaseConditionStep.otherwise.

Doc from org.jooq.CaseConditionStep.otherwise.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add an else clause to the already constructed case statement

Parameters
result:T

The result value if no other value matches the case

Returns:Field<T>

The resulting field from case statement construction

Annotations
@Override
otherwiseback to summary
public final Field<T> otherwise(Field<T> result)

Implements org.jooq.CaseConditionStep.otherwise, org.jooq.CaseConditionStep.otherwise.

Doc from org.jooq.CaseConditionStep.otherwise.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add an else clause to the already constructed case statement

Parameters
result:Field<T>

The result value if no other value matches the case

Returns:Field<T>

The resulting field from case statement construction

Annotations
@Override
otherwiseback to summary
public final Field<T> otherwise(Select<? extends Record1<T>> result)

Implements org.jooq.CaseConditionStep.otherwise, org.jooq.CaseConditionStep.otherwise.

Doc from org.jooq.CaseConditionStep.otherwise.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add an else clause to the already constructed case statement

Parameters
result:Select<? extends Record1<T>>

The result value if no other value matches the case

Returns:Field<T>

The resulting field from case statement construction

Annotations
@Override
whenback to summary
public final CaseConditionStep<T> when(Condition condition, T result)

Implements org.jooq.CaseConditionStep.when.

Doc from org.jooq.CaseConditionStep.when.

Deprecated

as a consequence of Condition and CaseConditionStep being deprecated. See corresponding docs for further information.

Compare a condition to the already constructed case statement, return result if the condition holds true

Parameters
condition:Condition

The condition to add to the case statement

result:T

The result value if the condition holds true

Returns:CaseConditionStep<T>

An intermediary step for case statement construction

Annotations
@Override
whenback to summary
public final CaseConditionStep<T> when(Condition condition, Field<T> result)

Implements org.jooq.CaseConditionStep.when, org.jooq.CaseConditionStep.when.

Doc from org.jooq.CaseConditionStep.when.

Deprecated

as a consequence of Condition, Field and CaseConditionStep being deprecated. See corresponding docs for further information.

Compare a condition to the already constructed case statement, return result if the condition holds true

Parameters
condition:Condition

The condition to add to the case statement

result:Field<T>

The result value if the condition holds true

Returns:CaseConditionStep<T>

An intermediary step for case statement construction

Annotations
@Override
whenback to summary
public final CaseConditionStep<T> when(Condition condition, Select<? extends Record1<T>> result)

Implements org.jooq.CaseConditionStep.when, org.jooq.CaseConditionStep.when.

Doc from org.jooq.CaseConditionStep.when.

Deprecated

as a consequence of Condition and CaseConditionStep being deprecated. See corresponding docs for further information.

Compare a condition to the already constructed case statement, return result if the condition holds true

Parameters
condition:Condition

The condition to add to the case statement

result:Select<? extends Record1<T>>

The result value if the condition holds true

Returns:CaseConditionStep<T>

An intermediary step for case statement construction

Annotations
@Override
whenback to summary
public final CaseConditionStep<T> when(Field<Boolean> condition, T result)

Implements org.jooq.CaseConditionStep.when.

Doc from org.jooq.CaseConditionStep.when.

Deprecated

as a consequence of Field and CaseConditionStep being deprecated. See corresponding docs for further information.

Compare a condition to the already constructed case statement, return result if the condition holds true

Parameters
condition:Field<Boolean>

The condition to add to the case statement

result:T

The result value if the condition holds true

Returns:CaseConditionStep<T>

An intermediary step for case statement construction

Annotations
@Override
whenback to summary
public final CaseConditionStep<T> when(Field<Boolean> condition, Field<T> result)

Implements org.jooq.CaseConditionStep.when, org.jooq.CaseConditionStep.when.

Doc from org.jooq.CaseConditionStep.when.

Deprecated

as a consequence of Field and CaseConditionStep being deprecated. See corresponding docs for further information.

Compare a condition to the already constructed case statement, return result if the condition holds true

Parameters
condition:Field<Boolean>

The condition to add to the case statement

result:Field<T>

The result value if the condition holds true

Returns:CaseConditionStep<T>

An intermediary step for case statement construction

Annotations
@Override
whenback to summary
public final CaseConditionStep<T> when(Field<Boolean> condition, Select<? extends Record1<T>> result)

Implements org.jooq.CaseConditionStep.when, org.jooq.CaseConditionStep.when.

Doc from org.jooq.CaseConditionStep.when.

Deprecated

as a consequence of Field and CaseConditionStep being deprecated. See corresponding docs for further information.

Compare a condition to the already constructed case statement, return result if the condition holds true

Parameters
condition:Field<Boolean>

The condition to add to the case statement

result:Select<? extends Record1<T>>

The result value if the condition holds true

Returns:CaseConditionStep<T>

An intermediary step for case statement construction

Annotations
@Override