Skip to main content
Skip table of contents

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!

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.