tencent cloud

masukan

Logical and Mathematical Functions

Terakhir diperbarui:2024-01-20 17:44:35

    Overview

    Logic and arithmetic functions include AND, OR, greater than, less than, equal to, addition, subtraction, multiplication, division, and modulus operation functions. Their writing method is slightly different from that of commonly used programming languages, as shown in the figure below.
    
    

    Function op_if

    Function definition

    This function is used to return a value based on a specified condition.

    Syntax description

    op_if(Condition 1, Value 1, Value 2)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    condition
    Condition expression
    bool
    Yes
    -
    -
    data1
    If the condition is True, the value of this parameter is returned.
    string
    Yes
    -
    -
    data2
    If the condition is False, the value of this parameter is returned.
    string
    Yes
    -
    -

    Sample

    Example 1 Raw log:
    {"data": "abc"}
    Processing rule:
    fields_set("result", op_if(True, v("data"), "false"))
    Processing result:
    {"result":"abc","data":"abc"}
    Example 2 Raw log:
    {"data": "abc"}
    Processing rule:
    fields_set("result", op_if(False, v("data"), "123"))
    Processing result:
    {"result":"123","data":"abc"}

    Function op_and

    Function definition

    This function is used to perform the AND operation on values. If all the specified parameter values are evaluated to true, True is returned. Otherwise, False is returned.

    Syntax description

    op_and(Value 1, Value 2, ...)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    Variable parameter list
    Parameters or expressions that participate in the calculation
    string
    Yes
    -
    -

    Sample

    Example 1 Raw log:
    {}
    Processing rule:
    fields_set("result", op_and(True, False))
    Processing result:
    {"result":"false"}
    Example 2 Raw log:
    {}
    Processing rule:
    fields_set("result", op_and(1, 1))
    Processing result:
    {"result":"true"}
    Example 3 Raw log:
    {"data":"false"}
    Processing rule:
    fields_set("result", op_and(1, v("data")))
    Processing result:
    {"result":"false","data":"false"}

    Function op_or

    Function definition

    This function is used to perform the OR operation on values. If one or more of the specified parameter values are evaluated to false, False is returned. Otherwise, True is returned.

    Syntax description

    op_or(Value 1, Value 2, ...)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    Variable parameter list
    Parameters or expressions that participate in the calculation
    string
    Yes
    -
    -

    Sample

    Raw log:
    {}
    Processing rule:
    fields_set("result", op_or(True, False))
    Processing result:
    {"result":"true"}

    Function op_not

    Function definition

    This function is used to perform the NOT operation on values.

    Syntax description

    op_not(Value)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    data
    Value of any type
    any
    Yes
    -
    -

    Sample

    Example 1 Raw log:
    {}
    Processing rule:
    fields_set("result", op_not(True))
    Processing result:
    {"result":"false"}
    Example 2 Raw log:
    {}
    Processing rule:
    fields_set("result", op_not("True"))
    Processing result:
    {"result":"false"}

    Function op_eq

    Function definition

    This function is used to compare two values. If the values are equal, True is returned.

    Syntax description

    op_eq(Value 1, Value 2)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    data1
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -
    data2
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -

    Sample

    Example 1. Determine whether the values of the Post and Get fields are equal Raw log:
    {"Post": "10", "Get": "11"}
    Processing rule:
    fields_set("result", op_eq(v("Post"), v("Get")))
    Save the result to result. Processing result:
    {"result":"false","Post":"10","Get":"11"}
    Example 2. Determine whether the values of the field1 and field2 fields are equal Raw log:
    {"field1": "1", "field2": "1"}
    Processing rule:
    fields_set("result", op_eq(v("field1"), v("field2")))
    Processing result:
    {"result":"true","field1":"1","field2":"1"}

    Function op_ge

    Function definition

    This function is used to compare two values. If Value 1 is greater than or equal to Value 2, True is returned.

    Syntax description

    op_ge(Value 1, Value 2)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    data1
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -
    data2
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -

    Sample

    Example 1 Raw log:
    {"field1": "20", "field2": "9"}
    Processing rule:
    fields_set("result", op_ge(v("field1"), v("field2")))
    Processing result:
    {"result":"true","field1":"20","field2":"9"}
    Example 2 Raw log:
    {"field1": "2", "field2": "2"}
    Processing rule:
    fields_set("result", op_ge(v("field1"), v("field2")))
    Processing result:
    {"result":"true","field1":"2","field2":"2"}

    Function op_gt

    Function definition

    This function is used to compare two values. If Value 1 is greater than Value 2, True is returned.

    Syntax description

    op_gt(Value 1, Value 2)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    data1
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -
    data2
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -

    Sample

    Raw log:
    {"field1": "20", "field2": "9"}
    Processing rule:
    fields_set("result", op_ge(v("field1"), v("field2")))
    Processing result:
    {"result":"true","field1":"20","field2":"9"}

    Function op_le

    Function definition

    This function is used to compare two values. If Value 1 is less than or equal to Value 2, True is returned.

    Syntax description

    op_le(Value 1, Value 2)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    data1
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -
    data2
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -

    Sample

    Raw log:
    {"field1": "2", "field2": "2"}
    Processing rule:
    fields_set("result", op_le(v("field1"), v("field2")))
    Processing result:
    {"result":"true","field1":"2","field2":"2"}

    Function op_lt

    Function definition

    This function is used to compare two values. If Value 1 is less than Value 2, True is returned.

    Syntax description

    op_lt(Value 1, Value 2)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    data1
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -
    data2
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -

    Sample

    Raw log:
    {"field1": "2", "field2": "3"}
    Processing rule:
    fields_set("result", op_lt(v("field1"), v("field2")))
    Processing result:
    {"result":"true","field1":"2","field2":"3"}

    Function op_add

    Function definition

    This function is used to return the sum of two specified values.

    Syntax description

    op_add(Value 1, Value 2)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    data1
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -
    data2
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -

    Sample

    Raw log:
    {"field1": "1", "field2": "2"}
    Processing rule:
    fields_set("result", op_add(v("field1"), v("field2")))
    Processing result:
    {"result":"3","field1":"1","field2":"2"}

    Function op_sub

    Function definition

    This function is used to return the difference between two specified values.

    Syntax description

    op_sub(Value 1, Value 2)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    data1
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -
    data2
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -

    Sample

    Raw log:
    {"field1": "1", "field2": "2"}
    Processing rule:
    fields_set("result", op_sub(v("field1"), v("field2")))
    Processing result:
    {"result":"-1","field1":"1","field2":"2"}

    Function op_mul

    Function definition

    This function is used to return the product of two specified values.

    Syntax description

    op_mul(Value 1, Value 2)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    data1
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -
    data2
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -

    Sample

    Raw log:
    {"field1": "1", "field2": "2"}
    Processing rule:
    fields_set("result", op_mul(v("field1"), v("field2")))
    Processing result:
    {"result":"2","field1":"1","field2":"2"}

    Function op_div

    Function definition

    This function is used to return the quotient of two specified values.

    Syntax description

    op_div(Value 1, Value 2)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    data1
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -
    data2
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -

    Sample

    Example 1 Raw log:
    {"field1": "1", "field2": "2"}
    Processing rule:
    fields_set("result", op_div(v("field1"), v("field2")))
    Processing result:
    {"result":"0","field1":"1","field2":"2"}
    Example 2 Raw log:
    {"field1": "1.0", "field2": "2"}
    Processing rule:
    fields_set("result", op_div(v("field1"), v("field2")))
    Processing result:
    {"result":"0.5","field1":"1.0","field2":"2"}

    Function op_sum

    Function definition

    This function is used to return the sum of multiple specified values.

    Syntax description

    op_sum(Value 1, Value 2, ...)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    Variable parameter list
    Numeric value or string that can be converted to a numeric value
    string
    Yes
    -
    -

    Sample

    Raw log:
    {"field1": "1.0", "field2": "10"}
    Processing rule:
    fields_set("result", op_sum(v("field1"), v("field2")))
    Processing result:
    {"result":"11.0","field1":"1.0","field2":"10"}

    Function op_mod

    Function definition

    This function is used to return the remainder of a specified value divided by the other specified value.

    Syntax description

    op_mod(Value 1, Value 2)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    data1
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -

    Sample

    Example 1 Raw log:
    {"field1": "1.0", "field2": "0"}
    Processing rule:
    fields_set("result", op_mod(v("field1"), v("field2")))
    Processing result:
    {"result":"2","field1":"1","field2":"2"}
    Example 2 Raw log:
    {"field1": "1.0", "field2": "5"}
    Processing rule:
    fields_set("result", op_mod(v("field1"), v("field2")))
    Processing result:
    {"result":"1.0","field1":"1.0","field2":"5"}
    Example 3 Raw log:
    {"field1": "6", "field2": "4"}
    Processing rule:
    fields_set("result", op_mod(v("field1"), v("field2")))
    Processing result:
    {"result":"2","field1":"6","field2":"4"}

    Function op_null

    Function definition

    This function is used to check whether a value is null. If so, true is returned; otherwise, false is returned.

    Syntax description

    op_null(Value)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    data
    Value of any type
    any
    Yes
    -
    -

    Sample

    Example 1 Raw log:
    {}
    Processing rule:
    fields_set("result", op_null("null"))
    Processing result:
    {"result":"true"}
    Example 2 Raw log:
    {"data": null}
    Processing rule:
    fields_set("result", op_null(v("data")))
    Processing result:
    {"data": "null", "result":"true"}

    Function op_notnull

    Function definition

    This function is used to check whether a value is not null. If so, true is returned; otherwise, false is returned.

    Syntax description

    op_notnull(Value)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    data
    Value of any type
    any
    Yes
    -
    -

    Sample

    Example 1 Raw log:
    {}
    Processing rule:
    fields_set("result", op_notnull("null"))
    Processing result:
    {"result":"false"}
    Example 2 Raw log:
    {"data": null}
    Processing rule:
    fields_set("result", op_notnull(v("data")))
    Processing result:
    {"data": "null", "result":"false"}

    Function op_str_eq

    Function definition

    This function is used to compare string values. If the values are equal, true is returned.

    Syntax description

    op_str_eq(Value 1, Value 2, ignore_upper=False)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    data1
    String value
    string
    Yes
    -
    -
    data2
    String value
    string
    Yes
    -
    -
    ignore_upper
    Case sensitivity
    bool
    No
    False
    -

    Sample

    Example 1 Raw log:
    {"field": "cls"}
    Processing rule:
    fields_set("result", op_str_eq(v("field"), "cls"))
    Processing result:
    {"result":"true","field":"cls"}
    Example 2 Raw log:
    {"field": "cls"}
    Processing rule:
    fields_set("result", op_str_eq(v("field"), "etl|cls|data"))
    Processing result:
    {"result":"true","field":"cls"}
    Example 3 Raw log:
    {"field": "CLS"}
    Processing rule:
    fields_set("result", op_str_eq(v("field"), "cls", ignore_upper=True))
    Processing result:
    {"result":"true","field":"CLS"}
    Example 4 Raw log:
    {"field": "CLS"}
    Processing rule:
    fields_set("result", op_str_eq(v("field"), "etl|cls|data", ignore_upper=True))
    Processing result:
    {"result":"true","field":"CLS"}

    Function random

    Function definition

    This function is used to generate a random number between two values. The value range is left-closed and right-closed.

    Syntax description

    random(Value 1, Value 2)

    Field description

    Parameter
    Description
    Type
    Required
    Default Value
    Value Range
    data1
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -
    data2
    Numeric value or string that can be converted to a numeric value
    number
    Yes
    -
    -

    Sample

    Example 1 Raw log:
    {"field1": "1"}
    Processing rule:
    log_keep(op_eq(random(1, 5), 3))
    Processing result:
    {"field1": "1"}
    Example 2 Raw log:
    {"field1": "1"}
    Processing rule:
    fields_set("field2", random(1, 5))
    Processing result:
    {"field1":"1", "field2":"4"}
    
    Hubungi Kami

    Hubungi tim penjualan atau penasihat bisnis kami untuk membantu bisnis Anda.

    Dukungan Teknis

    Buka tiket jika Anda mencari bantuan lebih lanjut. Tiket kami tersedia 7x24.

    Dukungan Telepon 7x24