December 2025
estos MetaDirectory 6
During replication, contacts should be omitted or deleted according to certain rules. (Filter)
- In the database wizard for the replicator, activate "Advanced settings":
In the next dialog you have the possibility to specify a "regular expression" in the "Search" field via an "LDAP data field" as a criterion for the omission/deletion of the record, which will lead to the omission/deletion of the record if the regular expression applies:
This means "search" for an expression, replace it with an expression and alternatively, so if it doesn't apply "do nothing", "delete it" or "leave it out".
In this example, only records where the Business phone field is not empty are transferred.
The regular expression ^(.+)$ expects at least one arbitrary character in order to evaluate the content to be checked with true and to execute the import according to the rule in Replace .
If the content to be checked does not contain any characters, i.e. the phone number is empty, the content is evaluated as incorrect and the Alternative action is triggered, thus omitting the data record.
In the following example the following records are omitted or skipped: records are omitted or skipped, where the content of user-defined field 1 contains the keyword no at any position:
The regular expression used for this purpose, ^(?!.*no).*$ , follows the method of exclusion testing/negative lookahead.
For Microsoft CRM, you can also use FetchXML query to filter out these contacts in advance.
Source: https://docs.microsoft.com/en-US/powerapps/developer/common-data-service/use-fetchxml-construct-query
Database records can be selectively determined for replication and thus also excluded via an SQL query.