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