FX - Operator @ Data transformation (ETL) @ MentDB Weak
Operator
+-*/bi+bi-bi*bi/bd+bd-bd*bd/andorxornotis nullis not nullis null or emptyis emptyis not emptyequalnot equal==!=>>=<<=
+ <number1> <number2>
Description
addition
addition
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
+ 23 42
mentdb
65
- <number1> <number2>
Description
substration
substration
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
- 50 26
mentdb
24
* <number1> <number2>
Description
multiplication
multiplication
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
* 2 5
mentdb
10
/ <number1> <number2>
Description
division
division
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
/ 30 2
mentdb
15
bi+ <number1> <number2>
Description
addition
addition
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
bi+ 23 42
mentdb
65
bi- <number1> <number2>
Description
substration
substration
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
bi- 50 26
mentdb
24
bi* <number1> <number2>
Description
multiplication
multiplication
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
bi* 2 5
mentdb
10
bi/ <number1> <number2>
Description
division
division
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
bi/ 30 2
mentdb
15
bd+ <number1> <number2>
Description
addition
addition
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
bd+ 23 42
mentdb
65
bd- <number1> <number2>
Description
substration
substration
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
bd- 50 26
mentdb
24
bd* <number1> <number2>
Description
multiplication
multiplication
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
bd* 2 5
mentdb
10
bd/ <number1> <number2>
Description
division
division
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
bd/ 30 2
mentdb
15
and <boolean1> <boolean2>
Description
and boolean
and boolean
Parameters
boolean1: The boolean 1 - boolean - required
boolean2: The boolean 2 - boolean - required
boolean1: The boolean 1 - boolean - required
boolean2: The boolean 2 - boolean - required
admin
and 1 1
mentdb
1
or <boolean1> <boolean2>
Description
or boolean
or boolean
Parameters
boolean1: The boolean 1 - boolean - required
boolean2: The boolean 2 - boolean - required
boolean1: The boolean 1 - boolean - required
boolean2: The boolean 2 - boolean - required
admin
or 1 0
mentdb
1
xor <boolean1> <boolean2>
Description
xor boolean
xor boolean
Parameters
boolean1: The boolean 1 - boolean - required
boolean2: The boolean 2 - boolean - required
boolean1: The boolean 1 - boolean - required
boolean2: The boolean 2 - boolean - required
admin
xor 1 0
mentdb
1
not <boolean>
Description
not boolean
not boolean
Parameters
boolean: The boolean - boolean - required
boolean: The boolean - boolean - required
admin
not 0
mentdb
1
is null <value>
Description
Check if the value is null
Check if the value is null
Parameters
value: The value - string - required
value: The value - string - required
admin
is null null
mentdb
1
is not null <value>
Description
Check if the value is not null
Check if the value is not null
Parameters
value: The value - string - required
value: The value - string - required
admin
is not null null
mentdb
0
is null or empty <value>
Description
Check if the value is null or empty
Check if the value is null or empty
Parameters
value: The value - string - required
value: The value - string - required
admin
is null or empty null
mentdb
1
is empty <str>
Description
Check if the string is empty
Check if the string is empty
Parameters
str: The string - string - required
str: The string - string - required
admin
is empty ""
mentdb
1
is not empty <str>
Description
Check if the string is not empty
Check if the string is not empty
Parameters
str: The string - string - required
str: The string - string - required
admin
is not empty ""
mentdb
0
equal <str1> <str2>
Description
Check if 2 strings are equal
Check if 2 strings are equal
Parameters
str1: The string 1 - string - required
str2: The string 2 - string - required
str1: The string 1 - string - required
str2: The string 2 - string - required
admin
equal "str1" "str1"
mentdb
1
not equal <str1> <str2>
Description
Check if 2 strings are not equal
Check if 2 strings are not equal
Parameters
str1: The string 1 - string - required
str2: The string 2 - string - required
str1: The string 1 - string - required
str2: The string 2 - string - required
admin
not equal "str1" "str1"
mentdb
0
== <number1> <number2>
Description
Check if 2 numbers are equal
Check if 2 numbers are equal
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
== "25" "25.0"
mentdb
1
!= <number1> <number2>
Description
Check if 2 numbers are not equal
Check if 2 numbers are not equal
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
!= "25" "25.0"
mentdb
0
> <number1> <number2>
Description
Check if a number is greater than another
Check if a number is greater than another
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
> "27" "26.0"
mentdb
1
>= <number1> <number2>
Description
Check if a number is greater or equal than another
Check if a number is greater or equal than another
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
>= "26" "26.0"
mentdb
1
< <number1> <number2>
Description
Check if a number is less than another
Check if a number is less than another
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
< "25" "26.0"
mentdb
1
<= <number1> <number2>
Description
Check if a number is less or equal than another
Check if a number is less or equal than another
Parameters
number1: The number 1 - number - required
number2: The number 2 - number - required
number1: The number 1 - number - required
number2: The number 2 - number - required
admin
<= "26" "26.0"
mentdb
1