Skip to main content

Bool Or

Definition​

The boolOr method allows you to add the BOOL_OR function to the query. The BOOL_OR is a function that returns the “logical OR” of all specified non-null boolean input values. That is, if any of the non-null input values ​​are true, the function returns true, otherwise it returns false.

There are 2 ways to call this method:

1. Calling from a KColumn or a KTableColumn​

The only one method available to use this functionality calling from a KColumn or a KTableColumn is:

  • boolOr(): It does not receive any parameters. The KColumn or KTableColumn that invokes the method will be the one supplied to the BOOL_OR function.

Example​

Java code:

k
.select(
    APP_USER.ID.boolOr(),
    APP_USER.CREATED_AT.cast(date())
)
.from(APP_USER)
.groupBy(APP_USER.CREATED_AT.cast(date()))
.multiple();

SQL generated:

SELECT
    BOOL_OR(au.id),
    CAST(au.created_at AS DATE)
FROM app_user au
GROUP BY CAST(au.created_at AS DATE)

Parameters:

  • None

2. Calling from the KFunction class​

The methods available to use this functionality calling from the KFunction class are:

  • boolOr(KColumn kColumn): Receives a KColumn or a KTableColumn which will be supplied to the BOOL_OR function.
  • boolOr(KCondition kCondition): Receives a KCondition which will be supplied to the BOOL_OR function.

To use this way, you need to import the static functions as follows:

import static com.myzlab.k.KFunction.*;

Example​

Java code:

k
.select(
    boolOr(APP_USER.ID),
    APP_USER.CREATED_AT.cast(date())
)
.from(APP_USER)
.groupBy(APP_USER.CREATED_AT.cast(date()))
.multiple();

SQL generated:

SELECT
    BOOL_OR(au.id),
    CAST(au.created_at AS DATE)
FROM app_user au
GROUP BY CAST(au.created_at AS DATE)

Parameters:

  • None