To define an expression, you specify the following:
•The left argument
•The operator
•The right argument
These three pieces together form a statement, such as these:
Sample Expressions
Left Argument
|
Operator
|
Right Argument
|
The value selected in the Loss Type list field
|
is
|
Fire Damage
|
The current user
|
is not
|
a member of the Outside Counsel group
|
The Trial Date
|
is changed
|
from any date to any date
|
The Expiration Date field
|
is populated
|
[none]
|
If you add these statements as expressions, the condition evaluates the statements to determine whether the condition is true.
The type of data being compared in the left and right arguments must match. For example, if your left argument identifies a list field, then your operator and right argument options allow you to compare the selection with a selection made in another list field or to a literal list value.
Operator Fields
The operator connects the rights and left arguments. Refer to the following table for a description of each operator field.
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
|
|
|
|
|
Right Argument Fields
The types of right arguments you can add depend on the data type of the left argument.
Selection
|
Description
|
Data types for which selection is available
|
Text
|
Number
|
Date
|
List
|
Check-box
|
Custom Object/Involved
|
Literal
|
Select this option when you want to specify a value to compare to the field identified by your left argument.
For example, select Literal for a qualifier item that checks whether the invoice total is greater than 5000.
You must also select Literal when you want to check whether a certain item is selected in a List field.
|
x
|
x
|
|
x
|
x
|
x
|
Attribute
|
Select this option when you need to compare the values of two fields in TeamConnect.
After you select Attribute, you must first select Current Object or Current User, and then use Object Navigator to identify the field to which you want to compare the field identified by your left argument.
For example, if you want to compare the Contact of a contact-centric project to the Contact identified in a custom field of type Involved, select Attribute to identify the custom field.
|
x
|
x
|
x
|
x
|
x
|
x
|
Current Object
|
Select one of these options after you have selected Attribute and you need to identify a field in TeamConnect to which you are comparing the field in your left argument.
For details about using Object Navigator, see Using Object Navigator.
|
x
|
x
|
x
|
x
|
x
|
x
|
Current User
|
x
|
x
|
x
|
x
|
x
|
x
|
Any Value
|
These options work in conjunction with the Changed option to form a statement, such as Is changed from any value to this value (California).
|
x
|
x
|
x
|
x
|
x
|
x
|
No Value
|
x
|
x
|
x
|
x
|
|
x
|
This Value
|
x
|
x
|
|
x
|
|
x
|
Today
|
The date that the rule is being triggered.
|
|
|
x
|
|
|
|
This Date
|
Allows you to compare the date in the left argument to a date that is identified in another field.
|
|
|
x
|
|
|
|
From Now
|
Allows you to specify a number of days from the date that the rule is being triggered.
|
|
|
x
|
|
|
|
From This Date
|
Allows you to specify a number of days from a date that is identified in another field.
|
|
|
x
|
|
|
|
Yes
|
These options correspond to a check-box being selected or not selected.
|
|
|
|
|
x
|
|
No
|
|
|
|
|
x
|
|
|
