Q: It is possible to work with a DigaSystem database table as a source for DigaPorter. But how can we filter the content which should be handled by DigaPorter?

A: DigaPorter has a direct SQL interface where you can set your filters.

For example if you need to select items which are not softdeleted but existing you can enter a SQL filter like this:


Code:

(STATE = 3 AND SOFTDEL = 0)




A simple filter looks like this:


Code:

(SOFTDEL = 0)




This will filter the database query.

You can test this code also with SQL Query Analyzer or SQL Management Studio before using it in DigaPorter.