instanceOfBoolean (Function)

Checks whether the parameter is an instance of Boolean or not.

Syntax

<BOOL> instanceOfBoolean(<INT|LONG|DOUBLE|FLOAT|STRING|BOOL|OBJECT> arg)

Query Parameters

Name	Description	Default Value	Possible Data Types	Optional	Dynamic
arg	The parameter to be checked.		INT LONG DOUBLE FLOAT STRING BOOL OBJECT	No	Yes

Example 1

@info(name = 'query1')
INSERT INTO barStream
SELECT instanceOfBoolean(switchState) AS state
FROM fooStream;

This query, named 'query1', selects records from the fooStream and calculates a new field called state. The instanceOfBoolean function is used to determine if the switchState is of boolean data type. If switchState is a boolean, then the value of state will be TRUE; otherwise, it will be FALSE. The resulting data, including the calculated state, is then inserted into the barStream.

Essentially, this query processes records in the fooStream and creates new records in the barStream with the state field, where state is determined based on the data type of the switchState.

Example 2

@info(name = 'query1')
INSERT INTO barStream
SELECT instanceOfBoolean(value) AS state
FROM fooStream;

This query, named 'query1', selects records from the fooStream and calculates a new field called state. The instanceOfBoolean function is used to determine if the value is of boolean data type. If value is a boolean, then the value of state will be TRUE; otherwise, it will be FALSE. The resulting data, including the calculated state, is then inserted into the barStream.

Essentially, this query processes records in the fooStream and creates new records in the barStream with the state field, where state is determined based on the data type of the value.

For example, if the value = 32, then this returns false as the value is not an instance of boolean.