I am using v7.0.2 Synchronization Editor, in a SQL Server type synchronization project. I have a SQL Server connection and want ALL records read from all database tables, but:
- I have a table which contains both users and roles, a column determines the type
How can I apply a filter to only process users (where type='USER') in one synchronization workflow and apply another filter of another synchronization workflow (apply some scope like where type='ROLE')
I cannot apply the WHERE filter in the Database connection configuration because it will filter out records.