-
- All Superinterfaces:
DivideByReturningStep
public interface DivideByOnConditionStep extends DivideByReturningStep
An intermediate type for the construction of a relational division. This type can be used as a convenience type for connecting more conditions.Referencing
XYZ*Step
types directly from client codeIt is usually not recommended to reference any
XYZ*Step
types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.Drawbacks of referencing the
XYZ*Step
types directly:- They're operating on mutable implementations (as of jOOQ 3.x)
- They're less composable and not easy to get right when dynamic SQL gets complex
- They're less readable
- They might have binary incompatible changes between minor releases
- Author:
- Lukas Eder
-
-
Method Summary
All Methods Instance Methods Abstract Methods Deprecated Methods Modifier and Type Method Description DivideByOnConditionStep
and(Boolean condition)
Deprecated.- 3.8.0 - [#4763] - Useand(Condition)
(typically withDSL.trueCondition()
,DSL.falseCondition()
, orDSL.noCondition()
as the parameter) orand(Field)
instead.DivideByOnConditionStep
and(String sql)
Combine the currently assembled conditions with another one using theOperator.AND
operator.DivideByOnConditionStep
and(String sql, Object... bindings)
Combine the currently assembled conditions with another one using theOperator.AND
operator.DivideByOnConditionStep
and(String sql, QueryPart... parts)
Combine the currently assembled conditions with another one using theOperator.AND
operator.DivideByOnConditionStep
and(Condition condition)
Combine the currently assembled conditions with another one using theOperator.AND
operator.DivideByOnConditionStep
and(Field<Boolean> condition)
Combine the currently assembled conditions with another one using theOperator.AND
operator.DivideByOnConditionStep
and(SQL sql)
Combine the currently assembled conditions with another one using theOperator.AND
operator.DivideByOnConditionStep
andExists(Select<?> select)
Combine the currently assembled conditions with anEXISTS
clause using theOperator.AND
operator.DivideByOnConditionStep
andNot(Boolean condition)
Deprecated.- 3.8.0 - [#4763] - UseandNot(Condition)
(typically withDSL.trueCondition()
,DSL.falseCondition()
, orDSL.noCondition()
as the parameter) orandNot(Field)
instead.DivideByOnConditionStep
andNot(Condition condition)
Combine the currently assembled conditions with a negated other one using theOperator.AND
operator.DivideByOnConditionStep
andNot(Field<Boolean> condition)
Combine the currently assembled conditions with a negated other one using theOperator.AND
operator.DivideByOnConditionStep
andNotExists(Select<?> select)
Combine the currently assembled conditions with aNOT EXISTS
clause using theOperator.AND
operator.DivideByOnConditionStep
or(Boolean condition)
Deprecated.- 3.8.0 - [#4763] - Useor(Condition)
(typically withDSL.trueCondition()
,DSL.falseCondition()
, orDSL.noCondition()
as the parameter) oror(Field)
instead.DivideByOnConditionStep
or(String sql)
Combine the currently assembled conditions with another one using theOperator.OR
operator.DivideByOnConditionStep
or(String sql, Object... bindings)
Combine the currently assembled conditions with another one using theOperator.OR
operator.DivideByOnConditionStep
or(String sql, QueryPart... parts)
Combine the currently assembled conditions with another one using theOperator.OR
operator.DivideByOnConditionStep
or(Condition condition)
Combine the currently assembled conditions with another one using theOperator.OR
operator.DivideByOnConditionStep
or(Field<Boolean> condition)
Combine the currently assembled conditions with another one using theOperator.OR
operator.DivideByOnConditionStep
or(SQL sql)
Combine the currently assembled conditions with another one using theOperator.OR
operator.DivideByOnConditionStep
orExists(Select<?> select)
Combine the currently assembled conditions with anEXISTS
clause using theOperator.OR
operator.DivideByOnConditionStep
orNot(Boolean condition)
Deprecated.- 3.8.0 - [#4763] - UseorNot(Condition)
(typically withDSL.trueCondition()
,DSL.falseCondition()
, orDSL.noCondition()
as the parameter) ororNot(Field)
instead.DivideByOnConditionStep
orNot(Condition condition)
Combine the currently assembled conditions with a negated other one using theOperator.OR
operator.DivideByOnConditionStep
orNot(Field<Boolean> condition)
Combine the currently assembled conditions with a negated other one using theOperator.OR
operator.DivideByOnConditionStep
orNotExists(Select<?> select)
Combine the currently assembled conditions with aNOT EXISTS
clause using theOperator.OR
operator.-
Methods inherited from interface org.jooq.DivideByReturningStep
returning, returning
-
-
-
-
Method Detail
-
and
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep and(Condition condition)
Combine the currently assembled conditions with another one using theOperator.AND
operator.
-
and
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep and(Field<Boolean> condition)
Combine the currently assembled conditions with another one using theOperator.AND
operator.
-
and
@Deprecated @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep and(Boolean condition)
Deprecated.- 3.8.0 - [#4763] - Useand(Condition)
(typically withDSL.trueCondition()
,DSL.falseCondition()
, orDSL.noCondition()
as the parameter) orand(Field)
instead. Due to ambiguity between calling this method usingField.equals(Object)
argument, vs. calling the other method via aField.equal(Object)
argument, this method will be removed in the future.Combine the currently assembled conditions with another one using theOperator.AND
operator.
-
and
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @PlainSQL DivideByOnConditionStep and(SQL sql)
Combine the currently assembled conditions with another one using theOperator.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!
- See Also:
DSL.condition(SQL)
,SQL
-
and
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @PlainSQL DivideByOnConditionStep and(String sql)
Combine the currently assembled conditions with another one using theOperator.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!
- See Also:
DSL.condition(String)
,SQL
-
and
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @PlainSQL DivideByOnConditionStep and(String sql, Object... bindings)
Combine the currently assembled conditions with another one using theOperator.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!
-
and
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @PlainSQL DivideByOnConditionStep and(String sql, QueryPart... parts)
Combine the currently assembled conditions with another one using theOperator.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!
-
andNot
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep andNot(Condition condition)
Combine the currently assembled conditions with a negated other one using theOperator.AND
operator.
-
andNot
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep andNot(Field<Boolean> condition)
Combine the currently assembled conditions with a negated other one using theOperator.AND
operator.
-
andNot
@Deprecated @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep andNot(Boolean condition)
Deprecated.- 3.8.0 - [#4763] - UseandNot(Condition)
(typically withDSL.trueCondition()
,DSL.falseCondition()
, orDSL.noCondition()
as the parameter) orandNot(Field)
instead. Due to ambiguity between calling this method usingField.equals(Object)
argument, vs. calling the other method via aField.equal(Object)
argument, this method will be removed in the future.Combine the currently assembled conditions with a negated other one using theOperator.AND
operator.
-
andExists
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep andExists(Select<?> select)
Combine the currently assembled conditions with anEXISTS
clause using theOperator.AND
operator.
-
andNotExists
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep andNotExists(Select<?> select)
Combine the currently assembled conditions with aNOT EXISTS
clause using theOperator.AND
operator.
-
or
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep or(Condition condition)
Combine the currently assembled conditions with another one using theOperator.OR
operator.
-
or
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep or(Field<Boolean> condition)
Combine the currently assembled conditions with another one using theOperator.OR
operator.
-
or
@Deprecated @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep or(Boolean condition)
Deprecated.- 3.8.0 - [#4763] - Useor(Condition)
(typically withDSL.trueCondition()
,DSL.falseCondition()
, orDSL.noCondition()
as the parameter) oror(Field)
instead. Due to ambiguity between calling this method usingField.equals(Object)
argument, vs. calling the other method via aField.equal(Object)
argument, this method will be removed in the future.Combine the currently assembled conditions with another one using theOperator.OR
operator.
-
or
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @PlainSQL DivideByOnConditionStep or(SQL sql)
Combine the currently assembled conditions with another one using theOperator.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!
- See Also:
DSL.condition(SQL)
,SQL
-
or
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @PlainSQL DivideByOnConditionStep or(String sql)
Combine the currently assembled conditions with another one using theOperator.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!
- See Also:
DSL.condition(String)
,SQL
-
or
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @PlainSQL DivideByOnConditionStep or(String sql, Object... bindings)
Combine the currently assembled conditions with another one using theOperator.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!
-
or
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @PlainSQL DivideByOnConditionStep or(String sql, QueryPart... parts)
Combine the currently assembled conditions with another one using theOperator.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!
-
orNot
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep orNot(Condition condition)
Combine the currently assembled conditions with a negated other one using theOperator.OR
operator.
-
orNot
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep orNot(Field<Boolean> condition)
Combine the currently assembled conditions with a negated other one using theOperator.OR
operator.
-
orNot
@Deprecated @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep orNot(Boolean condition)
Deprecated.- 3.8.0 - [#4763] - UseorNot(Condition)
(typically withDSL.trueCondition()
,DSL.falseCondition()
, orDSL.noCondition()
as the parameter) ororNot(Field)
instead. Due to ambiguity between calling this method usingField.equals(Object)
argument, vs. calling the other method via aField.equal(Object)
argument, this method will be removed in the future.Combine the currently assembled conditions with a negated other one using theOperator.OR
operator.
-
orExists
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep orExists(Select<?> select)
Combine the currently assembled conditions with anEXISTS
clause using theOperator.OR
operator.
-
orNotExists
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) DivideByOnConditionStep orNotExists(Select<?> select)
Combine the currently assembled conditions with aNOT EXISTS
clause using theOperator.OR
operator.
-
-