The operator in a rule qualifier statement determines how the left and right arguments are compared. It may have several components, depending on the type of data value you are working with in the qualifier (text, lookup table value, date, and so on).
The following table describes TeamConnect operators and the corresponding types of data that may be compared.
Selection
|
Description
|
Data types where operator selection is available
|
Text
|
Number
|
Date
|
List
|
Check-box
|
Related object
|
Is
|
Determines whether the qualifier statement is a positive or negative statement.
|
x
|
x
|
x
|
x
|
x
|
x
|
Not
|
x
|
x
|
x
|
x
|
x
|
x
|
Equal To
|
Evaluates whether the left argument and right argument are the same value.
|
x
|
x
|
x
|
x
|
x
|
x
|
Populated
|
Evaluates whether the field identified in the left argument has a value.
Do not use this selection to check whether a field that was previously null now has a value. Instead, use Changed from No Value.
|
x
|
x
|
x
|
x
|
|
x
|
Changed
|
Evaluates whether the value for the field identified in the left argument has changed. It compares the old value in the database to the value in the record when rule is triggered.
Tip: This option is useful for triggering audit rules.
|
x
|
x
|
x
|
x
|
x
|
x
|
Begins With
|
Evaluates whether the text value in the field identified in the left argument begins with, ends with, or contains the text that is identified in the right argument.
|
x
|
|
|
|
|
|
Ends With
|
x
|
|
|
|
|
|
Contains
|
x
|
|
|
|
|
|
Less Than
|
Evaluates the number value identified in the left argument compared to the number value in the right argument.
For example, you may specify that if a dollar amount Is - Greater Than Or Equal To 5000, send the action for approval.
|
|
x
|
|
|
|
|
Less Than Or Equal To
|
|
x
|
|
|
|
|
Greater Than Or Equal To
|
|
x
|
|
|
|
|
Greater Than
|
|
x
|
|
|
|
|
Exists
|
These options appear when you select a particular category by creating a path such as .detailList.(Motions). Evaluates whether the category has been added to the record.
|
|
|
|
|
|
|
Does Not Exist
|
|
|
|
|
|
|
Item Added
|
Evaluates whether a related object (such as involved) or sub-object (such as assignee) was added, deleted, or modified.
|
|
|
|
x
|
|
|
Item Deleted
|
|
|
|
x
|
|
|
Item Modified
|
|
|
|
x
|
|
|
After
|
Compares the date in the left argument to the date in the right argument.
An additional field appears when you select one of the options that requires you to specify a number of days. Enter the value for X in this field.
|
|
|
x
|
|
|
|
Before
|
|
|
x
|
|
|
|
After The Next X Days
|
|
|
x
|
|
|
|
Within The Next X Days
|
|
|
x
|
|
|
|
Within The Last X Days
|
|
|
x
|
|
|
|
Before The Last X Days
|
|
|
x
|
|
|
|
|
