DigaPorter: Setting SQL Filter in DigaPorter for Custom Fields

You can select a DigaSystem database table as a source in DigaPorter. A SQL Filter can be applied to specify what elements should be handled.

This also works with custom fields. For creating a filter for custom fields the syntax differs from using standard fields.

Example:

DigaPorter should only handle elements which have filled out the field MPN/EXPORT with the value = TRUE

The SQL Filter would look like this:

(SOFTDEL = 0 AND STATE = 3 AND N5.FIELDNAME LIKE 'MPN/EXPORT' AND N5.RESERVE1 LIKE '%TRUE%')

Many thanks to Michael Freyer!