Filtering Records During a Synchronization Session RRS feed

  • Question

  • I am learning about sync framework to see if it is a solution to my synchronization tasks. Is there a way to filter records being synchronized within a table?  For example, the database has multiple "projects" with unique project IDs.  During synchronization, could a filter be set for a particular project, or set of projects, including records in related tables?  There would be other tables for which a filter would not be applied during the same session; for example, a dropdown lookup table.

    Rob E.

    Monday, August 10, 2015 2:13 PM


  • Sync Fx tracks and apply changes by table. Its not privy to the relationship of tables. while you can specify a filter based on joins with other tables ( a filter is simply concatenated on where clause), it will not pull related records from another table for you.

    you can have mix of filtered and unfiltered table in a give scope and they will be sync in the same session. 

    • Marked as answer by REvans611 Tuesday, August 18, 2015 1:59 PM
    Tuesday, August 18, 2015 1:54 PM