Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
The Fields condition category contains the following conditions categorized as follows:
Category | Type | Description |
---|---|---|
Boolean
BooleanValueHasData
Evaluates if a boolean value contains data.
IsBooleanComparisonTrue
The IsBooleanComparisonTrue condition compares two boolean field values using operators including EqualTo and NotEqualTo.
IsBooleanValueTrue
The IsBooleanValueTrue condition checks if a boolean value evaluates to true.
IsValidBoolean
The IsValidBoolean condition checks if a field is a valid boolean.
DateTime
DateTimeValueHasData
Verifies if a datetime field (string, datafieldvalue, argument, etc.) contains data.
IsDateBirthdayOrRenewalDate
Indicates whether a date is a birthday or annual renewal date
IsDateFirstDayOfCalendarYear
Evaluates if a date is the first day of a calendar year
IsDateFirstDayOfFiscalYear
Evaluates if a date is the first day of a fiscal year
IsDateFirstDayOfFiscalYearQuarter
Evaluates if a date is the first day of a fiscal year quarter
IsDateFirstDayOfMonth
Evaluates if a date is the first day of a month
IsDateInCalendarYear
Evaluates if a date value is in a specific calendar year
IsDateInFiscalYear
Evaluates if a date value is in a fiscal year
IsDateInFiscalYearQuarter
Evaluates if a date is in a fiscal year quarter
IsDateInLeapYear
Evaluates if a date is in a leap year
IsDateLastDayOfCalendarYear
Evaluates if a date value is last day of a calendar year
IsDateLastDayOfFiscalYear
Evaluates if a date is the last day of a fiscal year
IsDateLastDayOfFiscalYearQuarter
Evaluates if a date value is the last day of a fiscal year quarter
IsDateLastDayOfMonth
Evaluates if a date value is the last day month
IsDateOverdueForAging
Evaluates if a date is overdue for 30-60-90-120 day aging.
IsDateTimeComparisonTrue
The DateTimeComparison condition is executed by comparing a date/time value to another using operators including EqualTo, NotEqualTo, GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo, etc.
IsDateWeekDay
Evaluates if a date falls on a week day.
IsDateWeekEndDay
Evaluates if a date falls on a weekend.
IsNumberOfDaysComparisonTrue
Evaluates if the number of days in a starting and ending datetime periods meets a specified condition.
IsNumberOfHoursComparisonTrue
Evaluates if the number of hours in a starting and ending datetime periods meets a specified condition.
IsNumberOfMinutesComparisonTrue
Evaluates if the number of minutes in a starting and ending datetime periods meets a specified condition.
IsNumberOfSecondsComparisonTrue
Evaluates if the number of seconds in a starting and ending datetime periods meets a specified condition.
IsNumberOfYearsComparisonTrue
Evaluates if the number of years in a starting and ending datetime periods meets a specified condition.
IsValidDateTime
Evaluates if a value is a valid datetime
IsValidUnixTime
Evaluates if a value is a valid Unix time
Numeric
IsCounterInRange
Evaluates whether a counter is in range - (between the starting and ending values defined in the InitializeCounter action)
IsCounterValueComparisonTrue
Evaluates whether a the current value of a counter meets a specified condition
IsNumericComparisonTrue
IsNumericComparisonTrue
IsRunningTotalComparisonTrue
Evaluates whether a the current value of a runnint total meets a specified condition
IsValidNumericValue
Tests if a numeric value is valid
NumericValueHasData
The NumericValueHasData condition evaluates if a numeric field contains data.
String
Contains
The Contains condition checks to see if a string is contained in another.
EndsWith
The EndsWith condition checks to see if an input string value ends with a specific string value.
EqualTo
The EqualTo condition checks to see if a string is equal to another string.
HasDuplicateCharacters
Indicates whether a string contains at least two of any character
HasNumeric
Indicates whether a string contains any numeric characters
HasRepeats
Indicates whether a string contains any character repeated in a row more than once
HasVowels
Indicates whether a string contains any vowel letters
IsAlphaNumeric
Indicates whether a string is composed of only letter and number characters.
IsAlternateCases
Indicates whether the letter casing in a string is alternating
IsCapitalized
Indicates whether the first character in a string is upper case
IsComparisonTrue
The IsComparisonTrue condition is executed by comparing a string to another using operators including Contains, EndsWith, EqualTo, StartsWith, etc.
IsEmailAddress
Indicates whether a string is in a valid email address format
IsInDelimitedString
The IsInDelimitedString condition is evaluated by checking to see if a string value exists in a delimiter-separated list
IsInPickList
The IsInPickList condition is evaluated by checking to see if a string value exists in a PickList or OptionSet
IsLengthComparisonTrue
The IsLengthComparisonTrue condition is executed by comparing the length of a string to another using operators including EqualTo, NotEqualTo, GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo
IsLetters
Indicates whether a string is composed of all letter characters.
IsLowerCase
Indicates whether a string is in all lower case
IsMultiline
Indicates whether a string contains multiple lines
IsNullOrEmpty
Indicates whether a string value is null or empty
IsNumeric
Indicates whether a string is composed of only numeric characters.
IsPalindrome
Indicates whether a string is a palindrome.
IsRegexMatch
The IsRegexMatch condition is executed by matching a specified string value against a text pattern defined with a regular expression (regex).
IsRepeatedChar
Indicates whether a string is composed of only a single character value
IsSpaces
Indicates whether a string is all spaces
IsStringCountComparisonTrue
Condition is executed by comparing the total number of times a given sequence appears in a string using operators including EqualTo, NotEqualTo, GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo
IsTitle
Indicates whether a string is formatted like a title, ie the first chracter of each word is capitalized. Words must be separated by spaces
IsUpperCase
Indicates whether a string is in all upper case
IsUrl
Indicates whether a string is a valid Url
StartsWith
The StartsWith condition checks to see if an input string value starts with a specific string value.
The Cache condition category contains the following conditions:
Category | Type | Description |
---|---|---|
The Custom condition category contains the following conditions:
Category | Type | Description |
---|---|---|
The Results condition category contains the following conditions categorized as follows:
Category | Type | Description |
---|---|---|
The Records condition contains the following conditions categorized as follows:
Category | Type | Description |
---|
The FileSystem condition contains the following conditions categorized as follows:
Category | Type | Description |
---|
The Workflow condition category contains the following conditions categorized as follows:
Category | Type | Description |
---|
Cache
IsCustomValueInCache
Evaluates if a specific custom value is in the cache
IsRecordInCache
Evaluates if a specific record exists in the cache
IsRecordKeyInCache
Evaluates if a specific Source record key is in the cache
Custom
Composite
Definition of conditions to be executed in sequence
Expression
The Expression action executes a simple expression (javascript). The expression must return a boolean
Function
Executes a .Net custom function and returns a boolean result
Script
The Script field action executes a script (javascript). The script must return a boolean.
Action
ActionExecutionResult
The ActionExecutionResult condition is used for evaluating the result of the last execution of a specific action.
ActionResultInList
The ActionResultInList condition is used for evaluating whether the current result of executing a specific action is in a list.
IsActionExecutionErrorCountComparisonTrue
The IsActionExecutionErrorCountComparisonTrue condition is evaluated using the count of the number of errors that have occurred on the executions of a specific action.
IsActionExecutionSuccessCountComparisonTrue
The IsActionExecutionSuccessCountComparisonTrue condition is evaluated using the count of the number of successful executions of a selected action
IsActionExecutionTotalCountComparisonTrue
The IsActionExecutionTotalCountComparisonTrue condition is evaluated using the count of the total number of executions of a selected action
Activity
ActivityExecutionResult
The ActivityExecutionResult condition is used for evaluating the result of the last execution of a specific activity. This is typically used when looping through a list of records using the While activity.
ActivityExecutionResultInList
The ActivityResultInList condition is used for evaluating whether the current result of executing a specific activity is in a list.
IsActivityExecutionErrorCountComparisonTrue
The IsActivityExecutionErrorCountComparisonTrue condition is evaluated using the count of the number of errors that have occurred on the executions of a specific workflow activity.
IsActivityExecutionSuccessCountComparisonTrue
The IsActivityExecutionSuccessCountComparisonTrue condition is evaluated using the count of the number of successful results that have occurred on the executions of a specific workflow activity.
IsActivityExecutionTotalCountComparisonTrue
The IsActivityExecutionTotalCountComparisonTrue condition is evaluated using the count of the total executions of a specific workflow activity.
IsTargetRecordErrorCountComparisonTrue
The IsTargetRecordErrorCountComparisonTrue condition is evaluated using the count of the total number of errors that have occurred during record operations (insert, update, delete) on the target.
Condition
ConditionExecutionResult
The ConditionExecutionResult condition is used for evaluating the result of the last execution of a specific condition.
ConditionResultInList
The ConditionResultInList condition is used for evaluating whether the current result of executing a specific condition is in a list.
IsConditionExecutionErrorCountComparisonTrue
The IsConditionExecutionErrorCountComparisonTrue condition is evaluated using the count of the number of errors that have occurred on the executions of a specific condition.
IsConditionExecutionSuccessCountComparisonTrue
The IsConditionExecutionSuccessCountComparisonTrue condition is evaluated using the count of the number of successful executions of a selected condition
IsConditionExecutionTotalCountComparisonTrue
The IsConditionExecutionTotalCountComparisonTrue condition is evaluated using the count of the total number of executions of a selected condition
LastResult
LastExecutionResult
The LastExecutionResult condition is used for evaluating the last activity result. This is typically used when looping through a list of records using the While activity.
LastRecordAction
The LastRecordAction condition is used for evaluating the last executed record action. The action can be checked to see if it is Delete, Insert, Update or Undefined.
LastResultInList
The LastResultInList condition is used for evaluating whether the last activity execution is in a list.
AuditLog | IsRetrievedRecordIdInAuditLog | Evaluates if a retrieved source record Id is in the AuditLogs table |
Source | IsPreloadedRecordsCountComparisonTrue | Executes a condition based on the number of records in a preloaded records activity. Note: The number can fluctuate based on the actions performed on the list |
IsQueryCountComparisonTrue | The IsQueryCountComparisonTrue condition is executed by comparing the number of records in a SQL select count statement to a specific numeric value using operators including EqualTo, NotEqualTo, GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo, etc. Note: You can use SQL Select statement for all supported data sources. |
IsRecordsSelectedCountComparisonTrue | IsRecordsSelectedCountComparisonTrue |
SourceRecordExists | The SourceRecordExists condition evaluates if a specific data record exists. The supported record types include data source, preloaded, list and picklist records. |
SourceRecordRead | The SourceRecordReadCondition condition is used for evaluating whether a record was successfully read from a Source. |
Target | IsRecordsDeletedCountComparisonTrue | Executes a condition based on the number of records that have been deleted by a Target activity. |
IsRecordsInsertedCountComparisonTrue | IsRecordsInsertedCountComparisonTrue |
IsRecordsSkippedCountComparisonTrue | IsRecordsSkippedCountComparisonTrue |
IsRecordsUpdatedCountComparisonTrue | IsRecordsUpdatedCountComparisonTrue |
TargetLastRecordAction | The LastRecordActionCondition condition is used for evaluating the last record action of a specific Target activity. The action can be checked to see if it is Delete, Insert, Update or Undefined. |
TargetRecordSaved | The TargetRecordSavedCondition condition is used for evaluating whether a record was successfully saved to a Target. |
Files | FileExists | The FileExists condition evaluates if a specific file exists. |
FileNameHasExtension | The HasExtension condition evaluates if a specific path includes a file name extension |
IsFileCountComparisonTrue | The IsFileCountComparisonTrue condition evaluates the number of files in a folder. Operators include EqualTo, GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo, etc. |
IsFileDateTimeComparisonTrue | The IsFileDateTimeComparisonTrue condition is executed by comparing a file's datetime value to a specific date using operators including EqualTo, NotEqualTo, GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo, etc. |
IsFileExtensionComparisonTrue | The IsFileExtensionComparisonTrue condition is executed by comparing a the file extension component of a file path to a string using operators including Contains, EndsWith, EqualTo, StartsWith, etc. |
IsFileExtensionRegexMatch | The IsFileExtensionRegexMatch condition is executed by matching the file extension against a text pattern defined with a regular expression (regex). |
IsFileNameComparisonTrue | The IsFileNameComparisonTrue condition is executed by comparing a the file name component of a file path to a string using operators including Contains, EndsWith, EqualTo, StartsWith, etc. |
IsFileNameRegexMatch | The IsFileNameRegexMatch condition is executed by matching the file name against a text pattern defined with a regular expression (regex). |
IsFileReadOnly | The IsFileReadOnly condition evaluates if a file is read only |
IsFileSizeComparisonTrue | The IsFileSizeComparisonTrue condition is executed by comparing a file's size value to a specific value using operators including EqualTo, NotEqualTo, GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo, etc. |
Folders | FolderExists | The FolderExists condition evaluates if a specific folder exists. |
IsFolderCountComparisonTrue | The IsFolderCountComparisonTrue condition evaluates the number of folders in a folder. Operators include EqualTo, GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo, etc. |
IsFolderDateTimeComparisonTrue | The IsFileDateTimeComparisonTrue condition is executed by comparing a file's access datetime value to a specific date using operators including EqualTo, NotEqualTo, GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo, etc. |
IsFolderNameComparisonTrue | The IsFolderNameComparisonTrue condition is executed by comparing a the folder name component of a path to a string using operators including Contains, EndsWith, EqualTo, StartsWith, etc. |
IsFolderNameRegexMatch | The IsFolderNameRegexMatch condition is executed by matching the folder name against a text pattern defined with a regular expression (regex). |
IsFolderSizeComparisonTrue | The IsFolderSizeComparisonTrue condition is executed by comparing a folder's size value to a specific value using operators including EqualTo, NotEqualTo, GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo, etc. |
Instance | IsCurrentInstanceElapsedTimeComparisonTrue | Evaluates if the number of seconds in the elapsed time of the current workflow instance meets a specified condition. |
WorkflowInstanceState | The WorkflowInstanceState condition is used for evaluating the state of an instance of a specific project job. |
Services | IsCpuUtilizationComparisonTrue | The IsCpuUtilizationComparisonTrue condition is used for evaluating the CPU utilization percent of a machine. |
IsDiskUtilizationComparisonTrue | The IsDiskUtilizationComparisonTrue is used for evaluating the disk utilization percent of a machine. |
IsHostAvailable | The IsHostAvailable condition evaluates host availability by pinging the host with an ICMP message to see if it is available. |
IsRemoteProcessRunning | The IsRemoteProcessRunning condition evaluates whether a process is running on a remote machine |
IsServiceRunning | The IsServiceRunning condition evaluates whether a service is running |
IsUrlAvailable | The IsUrlAvailable condition evaluates whether a Url is available |