Versions Compared

Old Version 12

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt
hiddentrue

Siddhi Inbuilt functions in wiki format

...

coalesce
Anchor
coalesce
coalesce

Syntax<int|long|float|double|string|bool|object> coalesce(<int|long|float|double|string|bool|object> arg1, <int|long|float|double|string|bool|object> arg2,.., <int|long|float|double|string|bool|object> argN)
Extension TypeFunction
DescriptionReturns the value of the first input parameter that is not null.
ParametersThis function accepts one or more parameters. They can belong to any one of the available types. All the specified parameters should be of the same type.
Return TypeThis will be the same as the type of the first input parameter.
Examples
  • coalesce('123', null, '789') returns 123
  • coalesce(null, 76, 567) returns 76
  • coalesce(null, null, null) returns null

...

convert
Anchor
convert
convert

Syntax<int|long|float|double|string|bool> convert(<int|long|float|double|string|bool> toBeConverted, <string> convertedTo)
Extension TypeFunction
DescriptionConverts the first input parameter according to the convertedTo parameter. 
Parameters
  • 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.
Return TypeThe return type is the same as the type specified by the convertedTo parameter.
Examples
  • convert('123', 'double') returns 123.0
  • convert(45.9, 'int') returns 46
  • convert(true, 'string') returns true

...

instanceOfBoolean
Anchor
boolean
boolean

Syntax<bool> instanceOfBoolean(<int|long|float|double|string|bool|object> arg)
Extension TypeFunction
DescriptionChecks whether the parameter is an instance of Boolean or not.
Parameters
  • arg: The parameter to be checked.
Return TypeReturns bool: true if the parameter is an instance of Boolean, or false if the parameter is not an instance of Boolean.
Examples
  • instanceOfBoolean(123) returns false
  • instanceOfBoolean(true) returns true
  • instanceOfBoolean(false) returns true. 

instanceOfDouble
Anchor
double
double

Syntax<bool> instanceOfDouble(<int|long|float|double|string|bool|object> arg)
Extension TypeFunction
DescriptionChecks whether the parameter is an instance of Double or not.
Parameters
  • arg: The parameter to be checked.
Return TypeReturns bool: true if the parameter is an instance of Double, or false if the parameter is not an instance of Double.
Examples
  • instanceOfDouble(123) returns false
  • instanceOfDouble(56.45) returns true
  • instanceOfDouble(false) returns false

instanceOfFloat
Anchor
float
float

Syntax<bool> instanceOfFloat(<int|long|float|double|string|bool|object> arg)
Extension TypeFunction
DescriptionChecks whether the parameter is an instance of Float or not.
ParameterThe parameter to be checked.
Return TypeReturns bool: true if the parameter is an instance of Float, or false if the parameter is not an instance of Float.
Examples
  • instanceOfFloat(123) returns false
  • instanceOfFloat(56.45) returns false
  • instanceOfFloat(56.45f) returns true

instanceOfInteger
Anchor
integer
integer

Syntax<bool> instanceOfInteger(<int|long|float|double|string|bool|object> arg)
Extension TypeFunction
DescriptionChecks whether the parameter is an instance of Integer or not.
ParameterThe parameter to be checked.
Return TypeReturns bool: true if the parameter is an instance of Integer, or false if the parameter is not an instance of Integer.
Examples
  • instanceOfInteger(123) returns true
  • instanceOfInteger(56.45) returns false
  • instanceOfInteger(56.45f) returns false

instanceOfLong
Anchor
long
long

Syntax<bool> instanceOfLong(<int|long|float|double|string|bool|object> arg)
Extension TypeFunction
DescriptionChecks whether the parameter is an instance of Long or not.
ParameterThe parameter to be checked.
Return TypeReturns bool: true if the parameter is an instance of Long, or false if the parameter is not an instance of Long.
Examples
  • instanceOfLong(123) returns false
  • instanceOfLong(5667l) returns true
  • instanceOfLong(56.67) returns false

instanceOfString
Anchor
string
string

Syntax<bool> instanceOfString(<int|long|float|double|string|bool|object> arg)
Extension TypeFunction
DescriptionChecks whether the parameter is an instance of String or not.
ParameterThe parameter to be checked.
Return TypeReturns bool: true if the parameter is an instance of String, or false if the parameter is not an instance of String.
Examples
  • instanceOfString('test') returns true
  • instanceOfString('5667') returns true
  • instanceOfString(56.67) returns false

UUID

Syntax<string> UUID()
Extension TypeFunction
DescriptionGenerates a UUID (Universally Unique Identifier).
Return TypeReturns a UUID string.
Examples
  • UUID() returns a34eec40-32c2-44fe-8075-7f4fde2e2dd8

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

    Code Block
    languagesql
    linenumberstrue
    from TempStream 
select convert(roomNo, 'string') as roomNo, temp, UUID() as messageID
insert into RoomTempStream;

...

cast
Anchor
cast
cast

Syntax<int|long|float|double|string|bool|object> cast(<object> toBeCasted, <string> castTo)
Extension TypeFunction
Description

Converts the first parameter according to the castTo parameter. Incompatible arguments will cause Class Cast Exceptions exceptions if further processed. This function is to be used with map extension whichwill return attribute of type object. We that returns attributes of the object type. You can use this cast function to cast the object to an accurate and concrete type.

Parameters
  • 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.
Return TypeThis will be is the same as the type of the second input parameter.
Examples
  • cast(100.3, 'double') returns 100.3d
  • cast(true, 'double') returns true
  • cast(null, 'double') returns null

ifThenElse
Anchor
ifThenElse
ifThenElse

Syntax<bool> ifThenElse(<bool> condition, <int|long|float|double|string|bool|object> arg1, <int|long|float|double|string|bool|object> arg2)
Extension TypeFunction
Description

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

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

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.

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