Module org.jooq

Package org.jooq

Interface Condition

All Superinterfaces:

Field<Boolean>, FieldOrConstraint, FieldOrRow, FieldOrRowOrSelect, GroupField, Named, OrderField<Boolean>, QueryPart, SelectField<Boolean>, SelectFieldOrAsterisk, Serializable, TableElement, Typed<Boolean>

All Known Subinterfaces:

False, JSONExistsOnStep, LikeEscapeStep, Null, QOM.And, QOM.ArrayOverlap<T>, QOM.Between<T>, QOM.CombinedCondition<R>, QOM.CompareCondition<T,R>, QOM.Contains<T>, QOM.ContainsIgnoreCase<T>, QOM.Deleting, QOM.EndsWith<T>, QOM.EndsWithIgnoreCase<T>, QOM.Eq<T>, QOM.EqQuantified<T>, QOM.Exists, QOM.False, QOM.FieldCondition, QOM.Ge<T>, QOM.GeQuantified<T>, QOM.Gt<T>, QOM.GtQuantified<T>, QOM.In<T>, QOM.InList<T>, QOM.Inserting, QOM.IsDistinctFrom<T>, QOM.IsDocument, QOM.IsJson, QOM.IsNotDistinctFrom<T>, QOM.IsNotDocument, QOM.IsNotJson, QOM.IsNotNull, QOM.IsNull, QOM.Le<T>, QOM.LeQuantified<T>, QOM.Like, QOM.LikeIgnoreCase, QOM.LikeQuantified, QOM.Lt<T>, QOM.LtQuantified<T>, QOM.Ne<T>, QOM.NeQuantified<T>, QOM.Not, QOM.NotIn<T>, QOM.NotInList<T>, QOM.NotLike, QOM.NotLikeIgnoreCase, QOM.NotLikeQuantified, QOM.NotSimilarTo, QOM.NotSimilarToQuantified, QOM.Null, QOM.Or, QOM.RegexpLike, QOM.RowEq<T>, QOM.RowGe<T>, QOM.RowGt<T>, QOM.RowIsNotNull, QOM.RowIsNull, QOM.RowLe<T>, QOM.RowLt<T>, QOM.RowNe<T>, QOM.RowOverlaps, QOM.SelectIsNotNull, QOM.SelectIsNull, QOM.SimilarTo, QOM.SimilarToQuantified, QOM.StartsWith<T>, QOM.StartsWithIgnoreCase<T>, QOM.StContains<T>, QOM.StCrosses, QOM.StDisjoint<T>, QOM.StEquals<T>, QOM.StIntersects<T>, QOM.StIsClosed, QOM.StIsEmpty, QOM.StOverlaps<T>, QOM.StTouches<T>, QOM.StWithin<T>, QOM.TableEq<R>, QOM.TableNe<R>, QOM.True, QOM.Unique, QOM.Updating, QOM.XMLExists, QOM.Xor, True

All Known Implementing Classes:

CustomCondition

public interface Condition
extends Field<Boolean>

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(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 arg2)	The 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(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()	The NOT operator.
@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 arg2)	The 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(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.
@NotNull Condition	xor(String sql)	Combine this condition with another one using the Operator.XOR operator.
@NotNull Condition	xor(String sql, Object... bindings)	Combine this condition with another one using the Operator.XOR operator.
@NotNull Condition	xor(String sql, QueryPart... parts)	Combine this condition with another one using the Operator.XOR operator.
@NotNull Condition	xor(Condition arg2)	The XOR operator.
@NotNull Condition	xor(Field<Boolean> other)	Combine this condition with another one using the Operator.XOR operator.
@NotNull Condition	xor(SQL sql)	Combine this condition with another one using the Operator.XOR operator.
@NotNull Condition	xorExists(Select<?> select)	Combine this condition with an EXISTS clause using the Operator.XOR operator.
@NotNull Condition	xorNot(Condition other)	Combine this condition with a negated other one using the Operator.XOR operator.
@NotNull Condition	xorNot(Field<Boolean> other)	Combine this condition with a negated other one using the Operator.XOR operator.
@NotNull Condition	xorNotExists(Select<?> select)	Combine this condition with a NOT EXIST clause using the Operator.XOR operator.

Methods inherited from interface org.jooq.Field

abs, 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, equals, exp, extract, field, firstValue, floor, from, ge, ge, ge, ge, get, getComment, getName, 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, 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, plus, plus, plus, position, position, pow, pow, power, power, 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

Methods inherited from interface org.jooq.Named

$name, getCommentPart, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart

$replace, $replace, $traverse, $traverse, hashCode, toString

Methods inherited from interface org.jooq.Typed

$dataType, getBinding, getConverter, getDataType, getDataType, getType

Method Details

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

@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

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(Field<Boolean> other)

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

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

xor

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

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

Parameters:

other - The other condition

Returns:

The combined condition

xor

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

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

Returns:

The combined condition

See Also:

• DSL.condition(SQL)
• SQL

xor

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

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

Returns:

The combined condition

See Also:

• DSL.condition(String)
• SQL

xor

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

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

bindings - The bindings

Returns:

The combined condition

See Also:

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

xor

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

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 - 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

xorNot

@NotNull
@Support
@NotNull Condition xorNot(Condition other)

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

Parameters:

other - The other condition

Returns:

The combined condition

xorNot

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

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

Parameters:

other - The other condition

Returns:

The combined condition

xorExists

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

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

Parameters:

select - The EXISTS's subquery

Returns:

The combined condition

xorNotExists

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

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

Parameters:

select - The EXISTS's subquery

Returns:

The combined condition

and

@NotNull
@Support
@NotNull Condition and(Condition arg2)

The AND operator.

not

@NotNull
@Support
@NotNull Condition not()

The NOT operator.

or

@NotNull
@Support
@NotNull Condition or(Condition arg2)

The OR operator.

xor

@NotNull
@Support
@NotNull Condition xor(Condition arg2)

The XOR operator.