Skip to main content

True methods

Definition​

The True methods allow you to add the IS TRUE operator to the query.

The methods available are:

Normal method nameSQL to generate
isTrueleftOp IS TRUE
isNotTrueleftOp IS NOT TRUE
info

For all cases, the object that calls True methods will be placed as the operand on the left side of the IS TRUE operator.

1. isTrue​

SQL to generate
leftOperand IS TRUE

This method takes no parameters.

Example: isTrue()​

Java code:

k
.select(APP_USER.ID)
.from(APP_USER)
.where(APP_USER.ACTIVE.isTrue())
.multiple();

SQL generated:

SELECT au.id
FROM app_user au
WHERE au.active IS TRUE

Parameters:

  • None

1. isNotTrue​

SQL to generate
leftOperand IS NOT TRUE

This method takes no parameters.

Example: isNotTrue()​

Java code:

k
.select(APP_USER.ID)
.from(APP_USER)
.where(APP_USER.ACTIVE.isNotTrue())
.multiple();

SQL generated:

SELECT au.id
FROM app_user au
WHERE au.active IS NOT TRUE

Parameters:

  • None