jOOQ 3.18.7 · org.jooq.impl.AbstractCondition

Modifier and Type	Field and Description
private static final Clause[]	CLAUSES Hides org.jooq.impl.AbstractField.CLAUSES. Deprecated as a consequence of `Clause` being deprecated.

Access	Constructor and Description
pack-priv	AbstractCondition()

Method Summary

Modifier and Type	Method and Description
public Condition	and(Field<Boolean> The other condition other) Implements org.jooq.Condition.and. Deprecated as a consequence of `Field` and `Condition` being deprecated. Combine this condition with another one using the `Operator#AND` operator.
public final Condition	and(SQL The other condition sql) Implements org.jooq.Condition.and. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with another one using the `Operator#AND` operator.
public final Condition	and(String The other condition sql) Implements org.jooq.Condition.and. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with another one using the `Operator#AND` operator.
public final Condition	and(String The other condition sql, Object... The bindings bindings) Implements org.jooq.Condition.and. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with another one using the `Operator#AND` operator.
public final Condition	and(String The SQL clause, containing {numbered placeholders} where query parts can be injected sql, QueryPart... The `QueryPart` objects that are rendered at the {numbered placeholder} locations parts) Implements org.jooq.Condition.and. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with another one using the `Operator#AND` operator.
public final Condition	and(Condition arg2) Implements org.jooq.Condition.and. Deprecated as a consequence of `Condition` being deprecated. The `AND` operator.
public final Condition	andExists(Select<?> The EXISTS's subquery select) Implements org.jooq.Condition.andExists. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with an EXISTS clause using the `Operator#AND` operator.
public final Condition	andNot(Condition The other condition other) Implements org.jooq.Condition.andNot. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with a negated other one using the `Operator#AND` operator.
public final Condition	andNot(Field<Boolean> The other condition other) Implements org.jooq.Condition.andNot. Deprecated as a consequence of `Field` and `Condition` being deprecated. Combine this condition with a negated other one using the `Operator#AND` operator.
public final Condition	andNotExists(Select<?> The EXISTS's subquery select) Implements org.jooq.Condition.andNotExists. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with a NOT EXIST clause using the `Operator#AND` operator.
public Clause[]	clauses(Context<?> ctx) Overrides org.jooq.impl.AbstractField.clauses. Implements org.jooq.QueryPartInternal.clauses. Deprecated as a consequence of `Clause` being deprecated. The `Clause`s that are represented by this query part.
public final Condition	not() Implements org.jooq.Condition.not. Deprecated as a consequence of `Condition` being deprecated. The `NOT` operator.
public final Condition	or(Field<Boolean> The other condition other) Implements org.jooq.Condition.or. Deprecated as a consequence of `Field` and `Condition` being deprecated. Combine this condition with another one using the `Operator#OR` operator.
public final Condition	or(SQL The other condition sql) Implements org.jooq.Condition.or. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with another one using the `Operator#OR` operator.
public final Condition	or(String The other condition sql) Implements org.jooq.Condition.or. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with another one using the `Operator#OR` operator.
public final Condition	or(String The other condition sql, Object... The bindings bindings) Implements org.jooq.Condition.or. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with another one using the `Operator#OR` operator.
public final Condition	or(String The SQL clause, containing {numbered placeholders} where query parts can be injected sql, QueryPart... The `QueryPart` objects that are rendered at the {numbered placeholder} locations parts) Implements org.jooq.Condition.or. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with another one using the `Operator#OR` operator.
public final Condition	or(Condition arg2) Implements org.jooq.Condition.or. Deprecated as a consequence of `Condition` being deprecated. The `OR` operator.
public final Condition	orExists(Select<?> The EXISTS's subquery select) Implements org.jooq.Condition.orExists. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with an EXISTS clause using the `Operator#OR` operator.
public final Condition	orNot(Condition The other condition other) Implements org.jooq.Condition.orNot. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with a negated other one using the `Operator#OR` operator.
public final Condition	orNot(Field<Boolean> The other condition other) Implements org.jooq.Condition.orNot. Deprecated as a consequence of `Field` and `Condition` being deprecated. Combine this condition with a negated other one using the `Operator#OR` operator.
public final Condition	orNotExists(Select<?> The EXISTS's subquery select) Implements org.jooq.Condition.orNotExists. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with a NOT EXIST clause using the `Operator#OR` operator.
public final Condition	xor(Field<Boolean> The other condition other) Implements org.jooq.Condition.xor. Deprecated as a consequence of `Field` and `Condition` being deprecated. Combine this condition with another one using the `Operator#XOR` operator.
public final Condition	xor(SQL The other condition sql) Implements org.jooq.Condition.xor. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with another one using the `Operator#XOR` operator.
public final Condition	xor(String The other condition sql) Implements org.jooq.Condition.xor. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with another one using the `Operator#XOR` operator.
public final Condition	xor(String The other condition sql, Object... The bindings bindings) Implements org.jooq.Condition.xor. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with another one using the `Operator#XOR` operator.
public final Condition	xor(String The SQL clause, containing {numbered placeholders} where query parts can be injected sql, QueryPart... The `QueryPart` objects that are rendered at the {numbered placeholder} locations parts) Implements org.jooq.Condition.xor. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with another one using the `Operator#XOR` operator.
public final Condition	xor(Condition arg2) Implements org.jooq.Condition.xor. Deprecated as a consequence of `Condition` being deprecated. The `XOR` operator.
public final Condition	xorExists(Select<?> The EXISTS's subquery select) Implements org.jooq.Condition.xorExists. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with an EXISTS clause using the `Operator#XOR` operator.
public final Condition	xorNot(Condition The other condition other) Implements org.jooq.Condition.xorNot. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with a negated other one using the `Operator#XOR` operator.
public final Condition	xorNot(Field<Boolean> The other condition other) Implements org.jooq.Condition.xorNot. Deprecated as a consequence of `Field` and `Condition` being deprecated. Combine this condition with a negated other one using the `Operator#XOR` operator.
public final Condition	xorNotExists(Select<?> The EXISTS's subquery select) Implements org.jooq.Condition.xorNotExists. Deprecated as a consequence of `Condition` being deprecated. Combine this condition with a NOT EXIST clause using the `Operator#XOR` operator.

Inherited from org.jooq.impl.AbstractField:: $alias $aliased abs accept acos add add as as as as asc ascii asin atan atan2 atan2 avg avgOver between between between between betweenSymmetric betweenSymmetric betweenSymmetric betweenSymmetric bitAnd bitAnd bitLength bitNand bitNand bitNor bitNor bitNot bitOr bitOr bitXNor bitXNor bitXor bitXor cast cast cast ceil changed charLength coalesce coalesce coerce coerce coerce collate collate collate comment comment compare compare compare compare concat concat concat contains contains containsIgnoreCase containsIgnoreCase convert convert convert convertFrom convertFrom convertTo convertTo cos cosh cot coth count countDistinct countOver decode decode decode decode deg desc div div divide divide endsWith endsWith endsWithIgnoreCase endsWithIgnoreCase eq eq eq eq equal equal equal equal equalIgnoreCase equalIgnoreCase exp extract field firstValue floor from ge ge ge ge get getValue greaterOrEqual greaterOrEqual greaterOrEqual greaterOrEqual greaterThan greaterThan greaterThan greaterThan greatest greatest gt gt gt gt in in in in in isDistinctFrom isDistinctFrom isDistinctFrom isDocument isFalse isJson isNotDistinctFrom isNotDistinctFrom isNotDistinctFrom isNotDocument isNotJson isNotNull isNull isNullable isPossiblyNullable isTrue lag lag lag lag lastValue le le le le lead lead lead lead least least length lessOrEqual lessOrEqual lessOrEqual lessOrEqual lessThan lessThan lessThan lessThan like like like like like likeIgnoreCase likeIgnoreCase likeIgnoreCase likeIgnoreCase likeRegex likeRegex ln log lower lpad lpad lpad lpad lt lt lt lt ltrim max maxOver median min minOver minus minus mod mod modulo modulo mul mul multiply multiply ne ne ne ne neg notBetween notBetween notBetween notBetween notBetweenSymmetric notBetweenSymmetric notBetweenSymmetric notBetweenSymmetric notContains notContains notContainsIgnoreCase notContainsIgnoreCase notEqual notEqual notEqual notEqual notEqualIgnoreCase notEqualIgnoreCase notIn notIn notIn notIn notIn notLike notLike notLike notLike notLike notLikeIgnoreCase notLikeIgnoreCase notLikeIgnoreCase notLikeIgnoreCase notLikeRegex notLikeRegex notSimilarTo notSimilarTo notSimilarTo notSimilarTo notSimilarTo nullif nullif nullsFirst nullsLast nvl nvl nvl2 nvl2 octetLength original parenthesised plus plus position position pow pow power power projectionSize rad rem rem repeat repeat replace replace replace replace reset round round rpad rpad rpad rpad rtrim shl shl shr shr sign similarTo similarTo similarTo similarTo similarTo sin sinh sort sort sortAsc sortAsc sortDefault sortDesc sortDesc sqrt startsWith startsWith startsWithIgnoreCase startsWithIgnoreCase stddevPop stddevPopOver stddevSamp stddevSampOver sub sub substring substring substring substring subtract subtract sum sumOver tan tanh times times trim unaryMinus unaryPlus upper varPop varPopOver varSamp varSampOver

CLAUSES	back to summary
private static final Clause[] CLAUSES Hides org.jooq.impl.AbstractField.CLAUSES. Deprecated as a consequence of `Clause` being deprecated. See corresponding docs for further information.

AbstractCondition	back to summary
pack-priv AbstractCondition()

Method Detail

and back to summary

and	back to summary
public Condition and(Field<Boolean> other) Implements org.jooq.Condition.and. Doc from org.jooq.Condition.and. Deprecated as a consequence of `Field` and `Condition` being deprecated. See corresponding docs for further information. Combine this condition with another one using the `Operator#AND` operator. Parameters other:Field<Boolean> The other condition Returns:Condition The combined condition Annotations @Override

public Condition and(Field<Boolean> other)

Implements org.jooq.Condition.and.

Doc from org.jooq.Condition.and.

Deprecated

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

Combine this condition with another one using the Operator#AND operator.

Parameters

other:Field<Boolean>: The other condition

Returns:Condition

The combined condition

Annotations

@Override

and back to summary

and	back to summary
public final Condition and(SQL sql) Implements org.jooq.Condition.and. Doc from org.jooq.Condition.and. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with another one using the `Operator#AND` operator. 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! Parameters sql:SQL The other condition Returns:Condition The combined condition Annotations @Override

public final Condition and(SQL sql)

Implements org.jooq.Condition.and.

Doc from org.jooq.Condition.and.

Deprecated

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

Combine this condition with another one using the Operator#AND operator.

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!

Parameters

sql:SQL: The other condition

Returns:Condition

The combined condition

Annotations

@Override

and back to summary

and	back to summary
public final Condition and(String sql) Implements org.jooq.Condition.and. Doc from org.jooq.Condition.and. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with another one using the `Operator#AND` operator. 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! Parameters sql:String The other condition Returns:Condition The combined condition Annotations @Override

public final Condition and(String sql)

Implements org.jooq.Condition.and.

Doc from org.jooq.Condition.and.

Deprecated

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

Combine this condition with another one using the Operator#AND operator.

Note

Parameters

sql:String: The other condition

Returns:Condition

The combined condition

Annotations

@Override

and back to summary

and	back to summary
public final Condition and(String sql, Object... bindings) Implements org.jooq.Condition.and. Doc from org.jooq.Condition.and. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with another one using the `Operator#AND` operator. 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! Parameters sql:String The other condition bindings:Object[] The bindings Returns:Condition The combined condition Annotations @Override

public final Condition and(String sql, Object... bindings)

Implements org.jooq.Condition.and.

Doc from org.jooq.Condition.and.

Deprecated

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

Combine this condition with another one using the Operator#AND operator.

Note

Parameters

sql:String: The other condition
bindings:Object[]: The bindings

Returns:Condition

The combined condition

Annotations

@Override

and back to summary

and	back to summary
public final Condition and(String sql, QueryPart... parts) Implements org.jooq.Condition.and. Doc from org.jooq.Condition.and. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with another one using the `Operator#AND` operator. 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! Parameters sql:String The SQL clause, containing {numbered placeholders} where query parts can be injected parts:QueryPart[] The `QueryPart` objects that are rendered at the {numbered placeholder} locations Returns:Condition The combined condition Annotations @Override

public final Condition and(String sql, QueryPart... parts)

Implements org.jooq.Condition.and.

Doc from org.jooq.Condition.and.

Deprecated

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

Combine this condition with another one using the Operator#AND operator.

Note

Parameters

sql:String: The SQL clause, containing {numbered placeholders} where query parts can be injected
parts:QueryPart[]: The QueryPart objects that are rendered at the {numbered placeholder} locations

Returns:Condition

The combined condition

Annotations

@Override

and back to summary

and	back to summary
public final Condition and(Condition arg2) Implements org.jooq.Condition.and. Doc from org.jooq.Condition.and. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. The `AND` operator. Annotations @Override

public final Condition and(Condition arg2)

Implements org.jooq.Condition.and.

Doc from org.jooq.Condition.and.

Deprecated

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

The AND operator.

Annotations

@Override

andExists back to summary

andExists	back to summary
public final Condition andExists(Select<?> select) Implements org.jooq.Condition.andExists. Doc from org.jooq.Condition.andExists. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with an EXISTS clause using the `Operator#AND` operator. Parameters select:Select<?> The EXISTS's subquery Returns:Condition The combined condition Annotations @Override

public final Condition andExists(Select<?> select)

Implements org.jooq.Condition.andExists.

Doc from org.jooq.Condition.andExists.

Deprecated

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

Combine this condition with an EXISTS clause using the Operator#AND operator.

Parameters

select:Select<?>: The EXISTS's subquery

Returns:Condition

The combined condition

Annotations

@Override

andNot back to summary

andNot	back to summary
public final Condition andNot(Condition other) Implements org.jooq.Condition.andNot. Doc from org.jooq.Condition.andNot. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with a negated other one using the `Operator#AND` operator. Parameters other:Condition The other condition Returns:Condition The combined condition Annotations @Override

public final Condition andNot(Condition other)

Implements org.jooq.Condition.andNot.

Doc from org.jooq.Condition.andNot.

Deprecated

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

Combine this condition with a negated other one using the Operator#AND operator.

Parameters

other:Condition: The other condition

Returns:Condition

The combined condition

Annotations

@Override

andNot back to summary

andNot	back to summary
public final Condition andNot(Field<Boolean> other) Implements org.jooq.Condition.andNot. Doc from org.jooq.Condition.andNot. Deprecated as a consequence of `Field` and `Condition` being deprecated. See corresponding docs for further information. Combine this condition with a negated other one using the `Operator#AND` operator. Parameters other:Field<Boolean> The other condition Returns:Condition The combined condition Annotations @Override

public final Condition andNot(Field<Boolean> other)

Implements org.jooq.Condition.andNot.

Doc from org.jooq.Condition.andNot.

Deprecated

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

Combine this condition with a negated other one using the Operator#AND operator.

Parameters

other:Field<Boolean>: The other condition

Returns:Condition

The combined condition

Annotations

@Override

andNotExists back to summary

andNotExists	back to summary
public final Condition andNotExists(Select<?> select) Implements org.jooq.Condition.andNotExists. Doc from org.jooq.Condition.andNotExists. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with a NOT EXIST clause using the `Operator#AND` operator. Parameters select:Select<?> The EXISTS's subquery Returns:Condition The combined condition Annotations @Override

public final Condition andNotExists(Select<?> select)

Implements org.jooq.Condition.andNotExists.

Doc from org.jooq.Condition.andNotExists.

Deprecated

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

Combine this condition with a NOT EXIST clause using the Operator#AND operator.

Parameters

select:Select<?>: The EXISTS's subquery

Returns:Condition

The combined condition

Annotations

@Override

clauses back to summary

clauses	back to summary
public Clause[] clauses(Context<?> ctx) Overrides org.jooq.impl.AbstractField.clauses. Implements org.jooq.QueryPartInternal.clauses. Doc from org.jooq.QueryPartInternal.clauses. Deprecated as a consequence of `Clause` being deprecated. See corresponding docs for further information. The `Clause`s that are represented by this query part. `QueryPart`s can specify several `Clause`s for which an event will be emitted `before` (in forward order) and `after` (in reverse order) visiting the the query part through `Context#visit(QueryPart)` This method is for JOOQ INTERNAL USE only. Do not reference directly Returns:Clause[] The `Clause`s represented by this query part or `null` or an empty array if this query part does not represent a clause. Annotations @Override

public Clause[] clauses(Context<?> ctx)

Overrides org.jooq.impl.AbstractField.clauses.

Implements org.jooq.QueryPartInternal.clauses.

Doc from org.jooq.QueryPartInternal.clauses.

Deprecated

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

The Clauses that are represented by this query part.

QueryParts can specify several Clauses for which an event will be emitted before (in forward order) and after (in reverse order) visiting the the query part through Context#visit(QueryPart)

This method is for JOOQ INTERNAL USE only. Do not reference directly

Returns:Clause[]

The Clauses represented by this query part or null or an empty array if this query part does not represent a clause.

Annotations

@Override

not back to summary

not	back to summary
public final Condition not() Implements org.jooq.Condition.not. Doc from org.jooq.Condition.not. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. The `NOT` operator. Annotations @Override

public final Condition not()

Implements org.jooq.Condition.not.

Doc from org.jooq.Condition.not.

Deprecated

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

The NOT operator.

Annotations

@Override

or back to summary

or	back to summary
public final Condition or(Field<Boolean> other) Implements org.jooq.Condition.or. Doc from org.jooq.Condition.or. Deprecated as a consequence of `Field` and `Condition` being deprecated. See corresponding docs for further information. Combine this condition with another one using the `Operator#OR` operator. Parameters other:Field<Boolean> The other condition Returns:Condition The combined condition Annotations @Override

public final Condition or(Field<Boolean> other)

Implements org.jooq.Condition.or.

Doc from org.jooq.Condition.or.

Deprecated

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

Combine this condition with another one using the Operator#OR operator.

Parameters

other:Field<Boolean>: The other condition

Returns:Condition

The combined condition

Annotations

@Override

or back to summary

or	back to summary
public final Condition or(SQL sql) Implements org.jooq.Condition.or. Doc from org.jooq.Condition.or. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with another one using the `Operator#OR` operator. 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! Parameters sql:SQL The other condition Returns:Condition The combined condition Annotations @Override

public final Condition or(SQL sql)

Implements org.jooq.Condition.or.

Doc from org.jooq.Condition.or.

Deprecated

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

Combine this condition with another one using the Operator#OR operator.

Note

Parameters

sql:SQL: The other condition

Returns:Condition

The combined condition

Annotations

@Override

or back to summary

or	back to summary
public final Condition or(String sql) Implements org.jooq.Condition.or. Doc from org.jooq.Condition.or. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with another one using the `Operator#OR` operator. 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! Parameters sql:String The other condition Returns:Condition The combined condition Annotations @Override

public final Condition or(String sql)

Implements org.jooq.Condition.or.

Doc from org.jooq.Condition.or.

Deprecated

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

Combine this condition with another one using the Operator#OR operator.

Note

Parameters

sql:String: The other condition

Returns:Condition

The combined condition

Annotations

@Override

or back to summary

or	back to summary
public final Condition or(String sql, Object... bindings) Implements org.jooq.Condition.or. Doc from org.jooq.Condition.or. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with another one using the `Operator#OR` operator. 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! Parameters sql:String The other condition bindings:Object[] The bindings Returns:Condition The combined condition Annotations @Override

public final Condition or(String sql, Object... bindings)

Implements org.jooq.Condition.or.

Doc from org.jooq.Condition.or.

Deprecated

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

Combine this condition with another one using the Operator#OR operator.

Note

Parameters

sql:String: The other condition
bindings:Object[]: The bindings

Returns:Condition

The combined condition

Annotations

@Override

or back to summary

or	back to summary
public final Condition or(String sql, QueryPart... parts) Implements org.jooq.Condition.or. Doc from org.jooq.Condition.or. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with another one using the `Operator#OR` operator. 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! Parameters sql:String The SQL clause, containing {numbered placeholders} where query parts can be injected parts:QueryPart[] The `QueryPart` objects that are rendered at the {numbered placeholder} locations Returns:Condition The combined condition Annotations @Override

public final Condition or(String sql, QueryPart... parts)

Implements org.jooq.Condition.or.

Doc from org.jooq.Condition.or.

Deprecated

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

Combine this condition with another one using the Operator#OR operator.

Note

Parameters

sql:String: The SQL clause, containing {numbered placeholders} where query parts can be injected
parts:QueryPart[]: The QueryPart objects that are rendered at the {numbered placeholder} locations

Returns:Condition

The combined condition

Annotations

@Override

or back to summary

or	back to summary
public final Condition or(Condition arg2) Implements org.jooq.Condition.or. Doc from org.jooq.Condition.or. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. The `OR` operator. Annotations @Override

public final Condition or(Condition arg2)

Implements org.jooq.Condition.or.

Doc from org.jooq.Condition.or.

Deprecated

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

The OR operator.

Annotations

@Override

orExists back to summary

orExists	back to summary
public final Condition orExists(Select<?> select) Implements org.jooq.Condition.orExists. Doc from org.jooq.Condition.orExists. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with an EXISTS clause using the `Operator#OR` operator. Parameters select:Select<?> The EXISTS's subquery Returns:Condition The combined condition Annotations @Override

public final Condition orExists(Select<?> select)

Implements org.jooq.Condition.orExists.

Doc from org.jooq.Condition.orExists.

Deprecated

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

Combine this condition with an EXISTS clause using the Operator#OR operator.

Parameters

select:Select<?>: The EXISTS's subquery

Returns:Condition

The combined condition

Annotations

@Override

orNot back to summary

orNot	back to summary
public final Condition orNot(Condition other) Implements org.jooq.Condition.orNot. Doc from org.jooq.Condition.orNot. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with a negated other one using the `Operator#OR` operator. Parameters other:Condition The other condition Returns:Condition The combined condition Annotations @Override

public final Condition orNot(Condition other)

Implements org.jooq.Condition.orNot.

Doc from org.jooq.Condition.orNot.

Deprecated

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

Combine this condition with a negated other one using the Operator#OR operator.

Parameters

other:Condition: The other condition

Returns:Condition

The combined condition

Annotations

@Override

orNot back to summary

orNot	back to summary
public final Condition orNot(Field<Boolean> other) Implements org.jooq.Condition.orNot. Doc from org.jooq.Condition.orNot. Deprecated as a consequence of `Field` and `Condition` being deprecated. See corresponding docs for further information. Combine this condition with a negated other one using the `Operator#OR` operator. Parameters other:Field<Boolean> The other condition Returns:Condition The combined condition Annotations @Override

public final Condition orNot(Field<Boolean> other)

Implements org.jooq.Condition.orNot.

Doc from org.jooq.Condition.orNot.

Deprecated

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

Combine this condition with a negated other one using the Operator#OR operator.

Parameters

other:Field<Boolean>: The other condition

Returns:Condition

The combined condition

Annotations

@Override

orNotExists back to summary

orNotExists	back to summary
public final Condition orNotExists(Select<?> select) Implements org.jooq.Condition.orNotExists. Doc from org.jooq.Condition.orNotExists. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with a NOT EXIST clause using the `Operator#OR` operator. Parameters select:Select<?> The EXISTS's subquery Returns:Condition The combined condition Annotations @Override

public final Condition orNotExists(Select<?> select)

Implements org.jooq.Condition.orNotExists.

Doc from org.jooq.Condition.orNotExists.

Deprecated

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

Combine this condition with a NOT EXIST clause using the Operator#OR operator.

Parameters

select:Select<?>: The EXISTS's subquery

Returns:Condition

The combined condition

Annotations

@Override

xor back to summary

xor	back to summary
public final Condition xor(Field<Boolean> other) Implements org.jooq.Condition.xor. Doc from org.jooq.Condition.xor. Deprecated as a consequence of `Field` and `Condition` being deprecated. See corresponding docs for further information. Combine this condition with another one using the `Operator#XOR` operator. Parameters other:Field<Boolean> The other condition Returns:Condition The combined condition Annotations @Override

public final Condition xor(Field<Boolean> other)

Implements org.jooq.Condition.xor.

Doc from org.jooq.Condition.xor.

Deprecated

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

Combine this condition with another one using the Operator#XOR operator.

Parameters

other:Field<Boolean>: The other condition

Returns:Condition

The combined condition

Annotations

@Override

xor back to summary

xor	back to summary
public final Condition xor(SQL sql) Implements org.jooq.Condition.xor. Doc from org.jooq.Condition.xor. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with another one using the `Operator#XOR` operator. 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! Parameters sql:SQL The other condition Returns:Condition The combined condition Annotations @Override

public final Condition xor(SQL sql)

Implements org.jooq.Condition.xor.

Doc from org.jooq.Condition.xor.

Deprecated

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

Combine this condition with another one using the Operator#XOR operator.

Note

Parameters

sql:SQL: The other condition

Returns:Condition

The combined condition

Annotations

@Override

xor back to summary

xor	back to summary
public final Condition xor(String sql) Implements org.jooq.Condition.xor. Doc from org.jooq.Condition.xor. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with another one using the `Operator#XOR` operator. 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! Parameters sql:String The other condition Returns:Condition The combined condition Annotations @Override

public final Condition xor(String sql)

Implements org.jooq.Condition.xor.

Doc from org.jooq.Condition.xor.

Deprecated

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

Combine this condition with another one using the Operator#XOR operator.

Note

Parameters

sql:String: The other condition

Returns:Condition

The combined condition

Annotations

@Override

xor back to summary

xor	back to summary
public final Condition xor(String sql, Object... bindings) Implements org.jooq.Condition.xor. Doc from org.jooq.Condition.xor. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with another one using the `Operator#XOR` operator. 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! Parameters sql:String The other condition bindings:Object[] The bindings Returns:Condition The combined condition Annotations @Override

public final Condition xor(String sql, Object... bindings)

Implements org.jooq.Condition.xor.

Doc from org.jooq.Condition.xor.

Deprecated

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

Combine this condition with another one using the Operator#XOR operator.

Note

Parameters

sql:String: The other condition
bindings:Object[]: The bindings

Returns:Condition

The combined condition

Annotations

@Override

xor back to summary

xor	back to summary
public final Condition xor(String sql, QueryPart... parts) Implements org.jooq.Condition.xor. Doc from org.jooq.Condition.xor. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with another one using the `Operator#XOR` operator. 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! Parameters sql:String The SQL clause, containing {numbered placeholders} where query parts can be injected parts:QueryPart[] The `QueryPart` objects that are rendered at the {numbered placeholder} locations Returns:Condition The combined condition Annotations @Override

public final Condition xor(String sql, QueryPart... parts)

Implements org.jooq.Condition.xor.

Doc from org.jooq.Condition.xor.

Deprecated

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

Combine this condition with another one using the Operator#XOR operator.

Note

Parameters

sql:String: The SQL clause, containing {numbered placeholders} where query parts can be injected
parts:QueryPart[]: The QueryPart objects that are rendered at the {numbered placeholder} locations

Returns:Condition

The combined condition

Annotations

@Override

xor back to summary

xor	back to summary
public final Condition xor(Condition arg2) Implements org.jooq.Condition.xor. Doc from org.jooq.Condition.xor. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. The `XOR` operator. Annotations @Override

public final Condition xor(Condition arg2)

Implements org.jooq.Condition.xor.

Doc from org.jooq.Condition.xor.

Deprecated

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

The XOR operator.

Annotations

@Override

xorExists back to summary

xorExists	back to summary
public final Condition xorExists(Select<?> select) Implements org.jooq.Condition.xorExists. Doc from org.jooq.Condition.xorExists. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with an EXISTS clause using the `Operator#XOR` operator. Parameters select:Select<?> The EXISTS's subquery Returns:Condition The combined condition Annotations @Override

public final Condition xorExists(Select<?> select)

Implements org.jooq.Condition.xorExists.

Doc from org.jooq.Condition.xorExists.

Deprecated

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

Combine this condition with an EXISTS clause using the Operator#XOR operator.

Parameters

select:Select<?>: The EXISTS's subquery

Returns:Condition

The combined condition

Annotations

@Override

xorNot back to summary

xorNot	back to summary
public final Condition xorNot(Condition other) Implements org.jooq.Condition.xorNot. Doc from org.jooq.Condition.xorNot. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with a negated other one using the `Operator#XOR` operator. Parameters other:Condition The other condition Returns:Condition The combined condition Annotations @Override

public final Condition xorNot(Condition other)

Implements org.jooq.Condition.xorNot.

Doc from org.jooq.Condition.xorNot.

Deprecated

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

Combine this condition with a negated other one using the Operator#XOR operator.

Parameters

other:Condition: The other condition

Returns:Condition

The combined condition

Annotations

@Override

xorNot back to summary

xorNot	back to summary
public final Condition xorNot(Field<Boolean> other) Implements org.jooq.Condition.xorNot. Doc from org.jooq.Condition.xorNot. Deprecated as a consequence of `Field` and `Condition` being deprecated. See corresponding docs for further information. Combine this condition with a negated other one using the `Operator#XOR` operator. Parameters other:Field<Boolean> The other condition Returns:Condition The combined condition Annotations @Override

public final Condition xorNot(Field<Boolean> other)

Implements org.jooq.Condition.xorNot.

Doc from org.jooq.Condition.xorNot.

Deprecated

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

Combine this condition with a negated other one using the Operator#XOR operator.

Parameters

other:Field<Boolean>: The other condition

Returns:Condition

The combined condition

Annotations

@Override

xorNotExists back to summary

xorNotExists	back to summary
public final Condition xorNotExists(Select<?> select) Implements org.jooq.Condition.xorNotExists. Doc from org.jooq.Condition.xorNotExists. Deprecated as a consequence of `Condition` being deprecated. See corresponding docs for further information. Combine this condition with a NOT EXIST clause using the `Operator#XOR` operator. Parameters select:Select<?> The EXISTS's subquery Returns:Condition The combined condition Annotations @Override

public final Condition xorNotExists(Select<?> select)

Implements org.jooq.Condition.xorNotExists.

Doc from org.jooq.Condition.xorNotExists.

Deprecated

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

Combine this condition with a NOT EXIST clause using the Operator#XOR operator.

Parameters

select:Select<?>: The EXISTS's subquery

Returns:Condition

The combined condition

Annotations

@Override

pack-priv abstract Class AbstractCondition

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail