Check exportd condition value with regex and limit obejct transfer

When creating conditions, the values are compared with the values from the database when the job is executed. Also, all objects that meet the conditions are transferred. When changing objects, the user also wants to transfer only the objects that have been changed. And not all the objects that meet the conditions.

Example:
Condition Value: 'Jack Lee'
Database Value: 'Jack Lee

A match is found here.

If you want to search only for the last name 'Lee' instead, no match will be found.

Example:
Condition Value: 'Lee'
Database Value: 'Jack Lee

Solution

There should be the possibility to find values using regex statements.

Example:
Condition Value: '.*Lee'
Database Value: 'Jack Lee

Source : https://community.datagerry.com/t/help-in-setting-up-filters-on-externalsystemcsv/293