The operators that can be selected depend on the Column type. The operators can be either unary or binary. If the operator is unary then the Value column is disabled. Population depends on the column’s type:
equals
not equals
less than
greater than
less or equal
greater or equal
empty
not empty
The following operators can be used only when the dialog is called from the User-Initiated Alert application:
has changed – The alert will trigger only if the value has changed.
has not changed – The alert will trigger only if the value did not change.
equals
not equals
less than
greater than
less or equal
greater or equal
The following operators can be used only when the dialog is called from the Scheduled Alert application:
is today
The operators that end with “is” trigger the alert when the month/quarter/year is equal to the one specified.
month is
quarter is
year is
The operators that begin with "this" trigger the alert if specified week/month/quarter falls on the current week/month/quarter:
this week
this month
this quarter
last days – The alert is triggered everyday for the specified number days after the date.
last month – The alert is triggered if the current date is one month after the date.
last quarter – The alert is triggered if the current date is one quarter after the date.
next days – The alert is triggered everyday for the specified number days before the date.
next month – The alert is triggered if the current date is one month before the date.
next quarter – The alert is triggered if the current date is one quarter before the date.
The operators that begin with "In" trigger the alert once before the specified number of days/weeks/month that date:
in days
in weeks
in months
The date operators that end with Ago trigger the alert specified number of days/weeks/months after the date:
days ago
weeks ago
months ago
The following operators can be used only when the dialog is called from the User-Initiated Alert application:
has changed – The alert will trigger only if the value of date has changed.
has not changed – The alert will trigger only if the value of date did not change.
empty
not empty