Conditions-Records

The Records condition contains the following conditions categorized as follows:

CategoryTypeDescription

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.

Last updated