25 / 166
What is lexical operator in Trigger filter condition?
You can use the lexical relational operators to create filters that compare string values.
Asked In ::
You can use the lexical relational operators to create filters that compare string values.
You can use the lexical relational operators to create filters that compare string values.
The following table describes the lexical operators that you can use in filters.
Operator Description
L_EQUALS Lexical equal to. This example... Evaluates to true if..
%myString% L_EQUALS "abc" The value of the myString variable is abc.
L_NOT_EQUALS Lexical not equal to.
This example... Evaluates to true if..
%myString% L_NOT_EQUALS "abc" The value of the myString variable is not abc.
L_LESS_THAN Lexical less than.
This example... Evaluates to true if..
%myString% L_LESS_THAN "abc" The value of the myString variable is less than abc.
L_LESS_OR_EQUAL Lexical less than or equal to.
This example... Evaluates to true if..
%myString% L_LESS_OR_EQUAL "abc" The value of the myString variable is less than or equal to abc.
L_GREATER_THAN Lexical greater than.
This example... Evaluates to true if..
%myString% L_GREATER_THAN "abc" The value of the myString variable is greater than abc.
L_GREATER_OR_EQUAL Lexical greater than or equal to.
This example... Evaluates to true if..
%myString% L_GREATER_OR_EQUAL "abc" The value of the myString variable is greater than or equal to abc.
If you use a lexical operator to compare a value that is not a string with another string value, the Integration Server treats the non-string value as an empty string (that is, ""). For example, in the expression (%myInt% L_EQUALS ""), the %myInt% variable is declared to be of type integer. This expression always evaluates to true because %myInt% contains an integer value that the Integration Server treats as an empty string ("") when it evaluates the expression.
The following table describes the lexical operators that you can use in filters.
Operator Description
L_EQUALS Lexical equal to. This example... Evaluates to true if..
%myString% L_EQUALS "abc" The value of the myString variable is abc.
L_NOT_EQUALS Lexical not equal to.
This example... Evaluates to true if..
%myString% L_NOT_EQUALS "abc" The value of the myString variable is not abc.
L_LESS_THAN Lexical less than.
This example... Evaluates to true if..
%myString% L_LESS_THAN "abc" The value of the myString variable is less than abc.
L_LESS_OR_EQUAL Lexical less than or equal to.
This example... Evaluates to true if..
%myString% L_LESS_OR_EQUAL "abc" The value of the myString variable is less than or equal to abc.
L_GREATER_THAN Lexical greater than.
This example... Evaluates to true if..
%myString% L_GREATER_THAN "abc" The value of the myString variable is greater than abc.
L_GREATER_OR_EQUAL Lexical greater than or equal to.
This example... Evaluates to true if..
%myString% L_GREATER_OR_EQUAL "abc" The value of the myString variable is greater than or equal to abc.
If you use a lexical operator to compare a value that is not a string with another string value, the Integration Server treats the non-string value as an empty string (that is, ""). For example, in the expression (%myInt% L_EQUALS ""), the %myInt% variable is declared to be of type integer. This expression always evaluates to true because %myInt% contains an integer value that the Integration Server treats as an empty string ("") when it evaluates the expression.
Srikanth
12 Mar, 2022 9:03 PM
How to set filter to search records which starts with a particular string. Like in SQL we write query to "Select * from Table_Name where ColumnName Like 'Sriting%' . Please advise
a)