Skip to main content

Unknown methods

Definition​

The Unknown methods allow you to add the IS UNKNOWN operator to the query.

The methods available are:

Normal method nameSQL to generate
isUnknownleftOp IS UNKNOWN
isNotUnknownleftOp IS NOT UNKNOWN
info

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

1. isUnknown​

SQL to generate
leftOperand IS UNKNOWN

This method takes no parameters.

Example: isUnknown()​

Java code:

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

SQL generated:

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

Parameters:

  • None

1. isNotUnknown​

SQL to generate
leftOperand IS NOT UNKNOWN

This method takes no parameters.

Example: isNotUnknown()​

Java code:

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

SQL generated:

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

Parameters:

  • None