Conditions-Records
Last updated
Last updated
The Records condition contains the following conditions categorized as follows:
Category | Type | Description |
---|---|---|
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.