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

• instanceOfString('test') returns true

• instanceOfString('5667') returns true

• instanceOfString(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;

• maximum(37.88, 38.12, 37.62) returns 38.12.
• maximum(15, 30, 25, 57 )  returns 57.

• minimum(37.88, 38.12, 37.62) returns 37.62.

• minimum(15, 30, 25, 57 ) returns 15.

Converts the first parameter according to the castTo parameter. Incompatible arguments cause Class Cast exceptions if further processed. This function is used with map extension that returns attributes of the object type. You can use this function to cast the object to an accurate and 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

Returns the the value of the arg1 parameter if the condition parameter is set to true, or returns the value of the arg2 parameter if the condition parameter is set to false.

• condition : This specifies the if then else condition value. The data type for this parameter is bool. 
• arg1 : This specifies the value to be returned if the value of the condition parameter is true. The data type of he value specified should be int, long, float, double, string, bool, or object.
• arg2 : This specifies the value to be returned if the value of the condition parameter is false. The data type of he value specified should be int , long , float , double , string , bool , or object .

Returns <int|long|float|double|string|bool|object>arg1 if the value of the condition parameter is true, or  <int|long|float|double|string|bool|object> arg2  if the value of the condition parameter is false.

• ifThenElse(sensorValue > 35,'High','Low') returns High if sensorValue = 50.
• ifThenElse(voltage < 5, 0, 1) returns 1 if voltage= 12.
• ifThenElse(password == 'admin', true, false) returns true if password = admin.