Skip to main content

And Not

Definition​

The andNot methods allows you to add the AND NOT operator to a WHERE clause.

Available methods​

1. andNot(KCondition kCondition)​

  • kCondition: which contains all the information about the condition that will be added to the WHERE clause with an AND NOT operator.

2. andNot(KRaw kRaw)​

  • kRaw: is a raw content which will be added in the WHERE clause with an AND NOT operator.

Method hierarchy​

The andNot method can be used right after the following methods:

and the subsequent methods that can be called are:

Example: KCondition​

Java code:

k
.deleteFrom(APP_USER)
.where(APP_USER.ID.gt(559))
.andNot(APP_USER.ACTIVE.isTrue())
.execute();

SQL generated:

DELETE
FROM app_user au
WHERE au.id > ?
AND NOT (au.active IS TRUE)

Parameters:

  • ?1: 559

Example: KRaw​

Java code:

k
.deleteFrom(APP_USER)
.where(raw("au.id > 559"))
.andNot(raw("au.active IS TRUE"))
.execute();

SQL generated:

DELETE
FROM app_user au
WHERE au.id > 559
AND NOT (au.active IS TRUE)

Parameters:

  • None