Order group

1. Equal

Description

Compares if two values of the same type are quantitatively the same.

Format

eq(arg_1, arg_2) → result

  • arg_1 : String, integer, float, ip, timestamp, boolean
  • arg_2 : The same type as arg_1
  • result : Boolean

Examples

  Example 1

eq("hello", "hello")

    • arg_1 : hello
    • arg_2 : hello
    • result : true
  Example 2

eq(1, 2)

    • arg_1 : 1
    • arg_2 : 2
    • result : false
  Example 3

eq(100.8, 12.3)

    • arg_1 : 100.8
    • arg_2 : 12.3
    • result : false
  Example 4

eq(192.168.1.1, 192.168.1.1)

    • arg_1 : 192.168.1.1
    • arg_2 : 192.168.1.1
    • result : true
  Example 5

timestamp(1484663566720) = timestamp(1484663566720)

    • arg_1 : timestamp(1484663566720)
    • arg_2 : timestamp(1484663566720)
    • result : true
  Example 6

true = false

    • arg_1 : true
    • arg_2 : false
    • result : false

This operation can also be written as arg_1 = arg_2.

2. Greater or equal

Description

Returns the true value if one argument is greater than or equal to the other one.

Format

ge(arg_1, arg_2) → result

  • arg_1 : String, integer, float, ip, timestamp
  • arg_2 : The same type as arg_1
  • result : Boolean

Examples

  Example 1

ge("hello", "hello")

  • arg_1 : hello
  • arg_2 : hello
  • result : true
  Example 2

ge(1, 2)

  • arg_1 : 1
  • arg_2 : 2
  • result : false
  Example 3

ge(100.8, 12.3)

  • arg_1 : 100.8
  • arg_2 : 12.3
  • result : true
  Example 4

ge(192.168.1.1, 192.168.1.1)

  • arg_1 : 192.168.1.1
  • arg_2 : 192.168.1.1
  • result : true
  Example 5

timestamp(1484663566720) >= timestamp(1484663566721)

  • arg_1 : timestamp(1484663566720)
  • arg_2 : timestamp(1484663566721)
  • result : false

This operation can also be written as arg_1 >= arg_2.

3. Greater than

Description

Returns the true value if one argument is greater than the other one.

Format

gt(arg_1, arg_2) → result

  • arg_1 : String, integer, float, ip, timestamp
  • arg_2 : The same type as arg_1
  • result : Boolean

Examples

  Example 1

gt("hello", "hello")

    • arg_1 : hello
    • arg_2 : hello
    • result : false
  Example 2

gt(1, 2)

    • arg_1 : 1
    • arg_2 : 2
    • result : false
  Example 3

gt(100.8, 12.3)

    • arg_1 : 100.8
    • arg_2 : 12.3
    • result : true
  Example 4

gt(192.168.1.1, 192.168.1.10)

    • arg_1 : 192.168.1.1
    • arg_2 : 192.168.1.10
    • result : false
  Example 5

timestamp(1484663566720) > timestamp(1484663566721)

    • arg_1 : timestamp(1484663566720)
    • arg_2 : timestamp(1484663566721)
    • result : false

This operation can also be written as arg_1 >arg_2.

4. Less or equal

Description

Returns the true value if one argument is less than or equal to the other one.

Format

le(arg_1, arg_2) → result

  • arg_1 : String, integer, float, ip, timestamp
  • arg_2 : The same type as arg_1
  • result : Boolean

Examples

  Example 1

le("hello", "hello")

    • arg_1 : hello
    • arg_2 : hello
    • result : true
  Example 2

le(1, 2)

    • arg_1 : 1
    • arg_2 : 2
    • result : true
  Example 3

le(100.8, 12.3)

    • arg_1 : 100.8
    • arg_2 : 12.3
    • result : false
  Example 4

le(192.168.1.1, 192.168.1.1)

    • arg_1 : 192.168.1.1
    • arg_2 : 192.168.1.1
    • result : true
  Example 5

timestamp(1484663566720) <= timestamp(1484663566721)

    • arg_1 : timestamp(1484663566720)
    • arg_2 : timestamp(1484663566721)
    • result : true

This operation can also be written as arg_1 <= arg_2.

5. Less than

Description

Returns the true value if one argument is less than the other one.

Format

lt(arg_1, arg_2) → result

  • arg_1 : String, integer, float, ip, timestamp
  • arg_2 : The same type as arg_1
  • result : Boolean

Examples

  Example 1

lt("hello", "hello")

    • arg_1 : hello
    • arg_2 : hello
    • result : false
  Example 2

lt(1, 2)

    • arg_1 : 1
    • arg_2 : 2
    • result : true
  Example 3

le(100.8, 12.3)

    • arg_1 : 100.8
    • arg_2 : 12.3
    • result : false
  Example 4

le(192.168.1.1, 192.168.1.1)

    • arg_1 : 192.168.1.1
    • arg_2 : 192.168.1.10
    • result : true
  Example 5

timestamp(1484663566720) < timestamp(1484663566721)

    • arg_1 : timestamp(1484663566720)
    • arg_2 : timestamp(1484663566721)
    • result : true

This operation can also be written as arg_1 < arg_2.

5. Maximum

Description

Compares numerical values and returns the highest number.

Format

max(arg_1, arg_s) → result

  • arg_1 : Integer or Float
  • arg_2 : Integer or Float
  • result : Integer or Float

Examples

  Example 1

max(1, -10)

    • arg_1 : 1
    • arg_2 : -10
    • result : 1
  Example 2

max(2.5, 8.5, 3.5)

    • arg_1 : 2.5
    • arg_2 : 8.5
    • arg_3 : 3.5
    • result : 8.5
  Example 3

max(10, 100.8, 12.3)

    • arg_1 : 10
    • arg_2 : 100.8
    • arg_3 : 12.3
    • result : 100.8

arg_s can be used one or more times.

6. Minimum

Description

Compares numerical values and returns the smallest number.

Format

min(arg_1, arg_s) → result

  • arg_1 : Integer or Float
  • arg_2 : Integer or Float
  • result : Integer or Float

Examples

  Example 1

min(1, -10)

    • arg_1 : 1
    • arg_2 : -10
    • result : -10
  Example 2

max(2.5, 8.5, 3.5)

    • arg_1 : 2.5
    • arg_2 : 8.5
    • arg_2 : 3.5
    • result : 2.5
  Example 3

max(10, 100.8, 12.3)

    • arg_1 : 1
    • arg_2 : 100.8
    • arg_3 : 12.3
    • result : 1

arg_s can be used one or more times.

7. Not equal

Description

Returns the true value if two arguments are not the same.

Format

ne(arg_1, arg_2) → result

  • arg_1 : String, integer, float, ip, timestamp, boolean
  • arg_2 : The same type as arg_1
  • result : Boolean

Examples

  Example 1

ne("hello", "hello")

    • arg_1 : hello
    • arg_2 : hello
    • result : false
  Example 2

ne(1, 2)

    • arg_1 : 1
    • arg_2 : 2
    • result : true
  Example 3

ne(100.8, 12.3)

    • arg_1 : 100.8
    • arg_2 : 12.3
    • result : true
  Example 4

le(192.168.1.1, 192.168.1.1)

    • arg_1 : 192.168.1.1
    • arg_2 : 192.168.1.1
    • result : false
  Example 5

timestamp(1484663566720) /= timestamp(1484663566720)

    • arg_1 : timestamp(1484663566720)
    • arg_2 : timestamp(1484663566720)
    • result : false
  Example 6

true /= false

    • arg_1 : true
    • arg_2 : false
    • result : true

This operation can also be written as arg_1 /= arg_2.

Have we answered your question?

If not, please contact our technical support team via email by clicking the button below.

CONTACT US