See AlsoIn Talisma, operators are used to specify field values when defining the elements of a search condition or creating a Rule.
Talisma provides you with the following operators:
• Text
• Date
• Logical
• Team
In addition to the operators discussed in the following tables, Talisma provides the in any Row operator. This operator can be used in combination with all the other operators.
|
Example If a condition is created as: Name =(in any Row) 'Debbie' Age <(in any Row) 24 Talisma will retrieve Object items that satisfy the above conditions in any row of the RecordList tab. |
Comparison Operators
The Comparison operator compares two values and then produces the logical value TRUE or FALSE. These operators compare data in numeric fields and display the relevant results.
|
Comparison operator |
Meaning |
Example |
|
= (equal sign) |
Equal to |
Interaction state = Open |
|
> (greater than sign) |
Greater than |
No. of Messages > 2 |
|
>= (greater than or equal to sign) |
Greater than or equal to |
No. of Messages >= 2 |
|
< (less than sign) |
Less than |
No. of Messages < 3 |
|
<= (less than equal to sign) |
Less than or equal to |
No. of Messages <= 2 |
|
<> (not equal to) |
Not equal to |
Category NOT Golden |
|
is null |
No value |
No Revenue generated from an Opportunity |
Text Operators
The Text operator matches the specified text value to display the relevant results.
|
Text operator |
Meaning |
Example |
|
= |
Equal to |
Name = "Smith" |
|
Starts with |
Text starts with. Applicable to proper nouns (Names, Countries, States, and Cities). |
Name starts with "Smi" |
|
Ends with |
Text ends with. Applicable to proper nouns (Names, Countries, States, and Cities). |
Name ends with "th" |
|
Contains |
Text contains |
Message text contains music |
|
Does not contain |
Text does not contain |
First name does not contain "en" |
|
is null |
No value |
No Last Name |
Date Operators
The Date operators retrieve data depending on the date range specified.
|
Date operator |
Meaning |
Example |
|
In |
In the date range specified |
In = Last 7 days |
|
On |
On a specific date |
On = September 8, 2000 |
|
On or before |
On or before a specific date |
On or before = September 8, 2000 |
|
On or after |
On or after a specific date |
On or after = September 8, 2000 |
|
is null |
The date is not defined |
Date last updated is null. This means that the date was not updated. |
Logical Operators
The Logical operators are used to join the expressions in a condition.
|
Logical operators |
Meaning |
Example |
|
OR |
Returns all items that meet any of the criteria specified |
Interaction assigned to "Tim" OR Interaction assigned to "Becky" |
|
AND |
Returns all items that meet all criteria specified |
Interaction ID > 100 and Contact Name = "Smith" |
Team Operator
The Team operator enables a User to select all child Teams within a Parent Team.
|
Team operator |
Meaning |
Example |
|
Include subteams |
Includes all child Teams in the query condition |
Interaction transferred to Team (can include child Teams in this condition) |