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.
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!