Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
appRules Conditions deliver a centralized and consistent approach for evaluating simple and complex conditions in all operations. The Conditions Editor is shown below:
To select a Condition type, simply navigate the condition tree and configure the properties for the selected type. Once a condition is created, it can be evaluated at any point in the running project by using the EvaluateCondition activity in the BaseActivities module or through other built-in access points in appRules.
The Fields condition category contains the following conditions categorized as follows:
| Category | Type | Description |
|---|---|---|
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 |
|---|
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.
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. |
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 |
|---|---|---|
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