Using Record Validation Job Filter
When starting a new job, in the job settings, you have the opportunity to apply a Filter to it. The Record Validation Job Filter can include or exclude records based on a field value. The filter can be applied only before a job is started.
Apply filters on
|Job selection||The filtered records will be matched with the entire database.|
|Matched Records||The entire database will be matched with the filtered records. This may take some time.|
|Job selection & Matched records||Filtered records will only be matched with the filtered records.|
Pick the field(s) you want the Record Validation filter to take into account. If you use a reference field, a suggestion will present all your inputs. The filter will only work if you click the suggested value. You can use multiple fields by clicking on the 'add filter' button.
The expression determines if an exclusion or inclusion will be executed for this job.
Equal - include records only with the defined 'Value'.
Not Equal - exclude results of records with the selected 'Value'.
Start with - include results of records in which the field starts with the 'Value'.
End with - include results of records in which the field ends with the 'Value'.
The Filter Logic governs how and when filters apply to your Record Validation Job.
|AND||Finds records that match both values (1 AND 2)
|OR||Finds records that match either value (1 OR 2)
|NOT||Finds records that exclude values (NOT 1)