Module org.jooq

Package org.jooq

Interface Condition

All Superinterfaces:

QueryPart, Serializable

All Known Subinterfaces:

False, JSONExistsOnStep, LikeEscapeStep, True

All Known Implementing Classes:

CustomCondition

public interface Condition
extends QueryPart

A condition or predicate.

Conditions can be used in a variety of SQL clauses. They're mainly used in a Select statement's WHERE clause, but can also appear in (non-exhaustive list):

• SELECT .. WHERE, e.g. via SelectWhereStep.where(Condition)
• SELECT .. HAVING, e.g. via SelectHavingStep.having(Condition)
• In a CASE expression, e.g. via DSL.case_() and Case.when(Condition, Field)
• As an ordinary column expression, e.g. via DSL.field(Condition)
• In filtered aggregate functions, e.g. via AggregateFilterStep.filterWhere(Condition)
• ... and many more

Example:

 // Assuming import static org.jooq.impl.DSL.*;

 using(configuration)
    .select()
    .from(ACTOR)
    .where(ACTOR.ACTOR_ID.eq(1)) // The eq operator produces a Condition from two Fields
    .fetch();
 

Instances can be created using DSL.condition(Field) and overloads, or by calling a comparison operator method on Field, such as Field.eq(Field).

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull Condition	and(Boolean other)	Deprecated. - 3.8.0 - [#4763] - Use and(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or and(Field) instead.
@NotNull Condition	and(String sql)	Combine this condition with another one using the Operator.AND operator.
@NotNull Condition	and(String sql, Object... bindings)	Combine this condition with another one using the Operator.AND operator.
@NotNull Condition	and(String sql, QueryPart... parts)	Combine this condition with another one using the Operator.AND operator.
@NotNull Condition	and(Condition other)	Combine this condition with another one using the Operator.AND operator.
@NotNull Condition	and(Field<Boolean> other)	Combine this condition with another one using the Operator.AND operator.
@NotNull Condition	and(SQL sql)	Combine this condition with another one using the Operator.AND operator.
@NotNull Condition	andExists(Select<?> select)	Combine this condition with an EXISTS clause using the Operator.AND operator.
@NotNull Condition	andNot(Boolean other)	Deprecated. - 3.8.0 - [#4763] - Use andNot(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or andNot(Field) instead.
@NotNull Condition	andNot(Condition other)	Combine this condition with a negated other one using the Operator.AND operator.
@NotNull Condition	andNot(Field<Boolean> other)	Combine this condition with a negated other one using the Operator.AND operator.
@NotNull Condition	andNotExists(Select<?> select)	Combine this condition with a NOT EXIST clause using the Operator.AND operator.
@NotNull Condition	not()	Invert this condition
@NotNull Condition	or(Boolean other)	Deprecated. - 3.8.0 - [#4763] - Use or(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or or(Field) instead.
@NotNull Condition	or(String sql)	Combine this condition with another one using the Operator.OR operator.
@NotNull Condition	or(String sql, Object... bindings)	Combine this condition with another one using the Operator.OR operator.
@NotNull Condition	or(String sql, QueryPart... parts)	Combine this condition with another one using the Operator.OR operator.
@NotNull Condition	or(Condition other)	Combine this condition with another one using the Operator.OR operator.
@NotNull Condition	or(Field<Boolean> other)	Combine this condition with another one using the Operator.OR operator.
@NotNull Condition	or(SQL sql)	Combine this condition with another one using the Operator.OR operator.
@NotNull Condition	orExists(Select<?> select)	Combine this condition with an EXISTS clause using the Operator.OR operator.
@NotNull Condition	orNot(Boolean other)	Deprecated. - 3.8.0 - [#4763] - Use orNot(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or orNot(Boolean) instead.
@NotNull Condition	orNot(Condition other)	Combine this condition with a negated other one using the Operator.OR operator.
@NotNull Condition	orNot(Field<Boolean> other)	Combine this condition with a negated other one using the Operator.OR operator.
@NotNull Condition	orNotExists(Select<?> select)	Combine this condition with a NOT EXIST clause using the Operator.OR operator.

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Method Detail

and

@NotNull
@Support
@NotNull Condition and(Condition other)

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

Parameters:

other - The other condition

Returns:

The combined condition

and

@NotNull
@Support
@NotNull Condition and(Field<Boolean> other)

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

Parameters:

other - The other condition

Returns:

The combined condition

and

@Deprecated
@NotNull
@Support
@NotNull Condition and(Boolean other)

Deprecated.

- 3.8.0 - [#4763] - Use and(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or and(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.

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

Parameters:

other - The other condition

Returns:

The combined condition

and

@NotNull
@Support
@PlainSQL
@NotNull Condition and(SQL sql)

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 - The other condition

Returns:

The combined condition

See Also:

DSL.condition(SQL), SQL

and

@NotNull
@Support
@PlainSQL
@NotNull Condition and(String sql)

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 - The other condition

Returns:

The combined condition

See Also:

DSL.condition(String), SQL

and

@NotNull
@Support
@PlainSQL
@NotNull Condition and(String sql,
                       Object... bindings)

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 - The other condition

bindings - The bindings

Returns:

The combined condition

See Also:

DSL.condition(String, Object...), DSL.sql(String, Object...), SQL

and

@NotNull
@Support
@PlainSQL
@NotNull Condition and(String sql,
                       QueryPart... parts)

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 - The SQL clause, containing {numbered placeholders} where query parts can be injected

parts - The QueryPart objects that are rendered at the {numbered placeholder} locations

Returns:

The combined condition

See Also:

DSL.condition(String, QueryPart...), DSL.sql(String, QueryPart...), SQL

andNot

@NotNull
@Support
@NotNull Condition andNot(Condition other)

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

Parameters:

other - The other condition

Returns:

The combined condition

andNot

@NotNull
@Support
@NotNull Condition andNot(Field<Boolean> other)

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

Parameters:

other - The other condition

Returns:

The combined condition

andNot

@Deprecated
@NotNull
@Support
@NotNull Condition andNot(Boolean other)

Deprecated.

- 3.8.0 - [#4763] - Use andNot(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or andNot(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.

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

Parameters:

other - The other condition

Returns:

The combined condition

andExists

@NotNull
@Support
@NotNull Condition andExists(Select<?> select)

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

Parameters:

select - The EXISTS's subquery

Returns:

The combined condition

andNotExists

@NotNull
@Support
@NotNull Condition andNotExists(Select<?> select)

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

Parameters:

select - The EXISTS's subquery

Returns:

The combined condition

or

@NotNull
@Support
@NotNull Condition or(Condition other)

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

Parameters:

other - The other condition

Returns:

The combined condition

or

@NotNull
@Support
@NotNull Condition or(Field<Boolean> other)

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

Parameters:

other - The other condition

Returns:

The combined condition

or

@Deprecated
@NotNull
@Support
@NotNull Condition or(Boolean other)

Deprecated.

- 3.8.0 - [#4763] - Use or(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or or(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.

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

Parameters:

other - The other condition

Returns:

The combined condition

or

@NotNull
@Support
@PlainSQL
@NotNull Condition or(SQL sql)

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 - The other condition

Returns:

The combined condition

See Also:

DSL.condition(SQL), SQL

or

@NotNull
@Support
@PlainSQL
@NotNull Condition or(String sql)

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 - The other condition

Returns:

The combined condition

See Also:

DSL.condition(String), SQL

or

@NotNull
@Support
@PlainSQL
@NotNull Condition or(String sql,
                      Object... bindings)

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 - The other condition

bindings - The bindings

Returns:

The combined condition

See Also:

DSL.condition(String, Object...), DSL.sql(String, Object...), SQL

or

@NotNull
@Support
@PlainSQL
@NotNull Condition or(String sql,
                      QueryPart... parts)

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 - The SQL clause, containing {numbered placeholders} where query parts can be injected

parts - The QueryPart objects that are rendered at the {numbered placeholder} locations

Returns:

The combined condition

See Also:

DSL.condition(String, Object...), DSL.sql(String, QueryPart...), SQL

orNot

@NotNull
@Support
@NotNull Condition orNot(Condition other)

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

Parameters:

other - The other condition

Returns:

The combined condition

orNot

@NotNull
@Support
@NotNull Condition orNot(Field<Boolean> other)

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

Parameters:

other - The other condition

Returns:

The combined condition

orNot

@Deprecated
@NotNull
@Support
@NotNull Condition orNot(Boolean other)

Deprecated.

- 3.8.0 - [#4763] - Use orNot(Condition) (typically with DSL.trueCondition(), DSL.falseCondition(), or DSL.noCondition() as the parameter) or orNot(Boolean) 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.

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

Parameters:

other - The other condition

Returns:

The combined condition

orExists

@NotNull
@Support
@NotNull Condition orExists(Select<?> select)

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

Parameters:

select - The EXISTS's subquery

Returns:

The combined condition

orNotExists

@NotNull
@Support
@NotNull Condition orNotExists(Select<?> select)

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

Parameters:

select - The EXISTS's subquery

Returns:

The combined condition

not

@NotNull
@Support
@NotNull Condition not()

Invert this condition

This is the same as calling DSL.not(Condition)

Returns:

This condition, inverted