Page Comparison

• coalesce('123', null, '789') returns 123
• coalesce(null, 76, 567) returns 76
• coalesce(null, null, null) returns null

• toBeConverted: This specifies the value to be converted. The type of this value can be any of the available types other than object.
• convertedTo: A string constant parameter expressing the conveverted to type using one of the following strings values: int, long, float, double, string, bool.

• convert('123', 'double') returns 123.0
• convert(45.9, 'int') returns 46
• convert(true, 'string') returns true

• arg: The parameter to be checked.

• instanceOfBoolean(123) returns false
• instanceOfBoolean(true) returns true
• instanceOfBoolean(false) returns true. 

• arg: The parameter to be checked.

• instanceOfDouble(123) returns false
• instanceOfDouble(56.45) returns true
• instanceOfDouble(false) returns false

• instanceOfFloat(123) returns false
• instanceOfFloat(56.45) returns false
• instanceOfFloat(56.45f) returns true

• instanceOfInteger(123) returns true
• instanceOfInteger(56.45) returns false
• instanceOfInteger(56.45f) returns false

• instanceOfLong(123) returns false
• instanceOfLong(5667l) returns true
• instanceOfLong(56.67) returns false

• UUID() returns a34eec40-32c2-44fe-8075-7f4fde2e2dd8

• The following converts a room number to string, introducing a message ID to each event.

  Code Block
  language sql linenumbers true
  from TempStream select convert(roomNo, 'string') as roomNo, temp, UUID() as messageID insert into RoomTempStream;

Converts the first parameter according to the castTo parameter. Incompatible arguments will cause Class Cast Exceptions if further processed. This is to be used with map extension which

will return attribute of type object. We can use this cast function to cast the object to accurate concrete type.

• toBeCasted: This specifies the attribute to be casted.
• castTo: A string constant parameter expressing the cast to type using one of the following strings values: int, long, float, double, string, bool.

• cast(100.3, 'double') returns 100.3d
• cast(true, 'double') returns true
• cast(null, 'double') returns null

Return the arg1 parameter if the condition parameter is true, or return the arg2 parameter if the condition parameter is false.

• condition: This specifies the if then else condition value. The type of this value : bool. 
• arg1: The parameter to be return if the condition value true. The type of this value one of the following : int, long, float, double, string, bool,object.
• arg2: The parameter to be return if the condition value false. The type of this value one of the following : int, long, float, double, string, bool,object.

Returns <int|long|float|double|string|bool|object>arg1 if the condition parameter is true,

or  <int|long|float|double|string|bool|object> arg2  if the condition parameter is false.

• ifThenElse(sensorValue > 35,'High','Low') returns 'High'
• ifThenElse(voltage < 5, 0, 1) returns 'High1'
• ifThenElse(password == 'admin', true, false) returns 'Highfalse'