How the syncing works with the template?

• Question

• 

  

  0

  Sign in to vote

  Hello, 

  I am provisioning the Sync with SqlSyncScopeProvisioningType.Template for dynamic filtering parameter-base. For passing the customize filtering, I need to pass the parameter to the config like:
  

  If tableProvision.Tables("CaseBase") IsNot Nothing Then
                              tableProvision.Tables("CaseBase").AddFilterColumn("DynamicCaseForm")
                              tableProvision.Tables("CaseBase").FilterClause = " [side].DynamicCaseForm = 'DynamicCaseForm6' AND [base].OwnerUserID = @OwnerUserID "
                              Dim param As New SqlParameter("@OwnerUserID", SqlDbType.NVarChar, 36)
                              tableProvision.Tables("CaseBase").FilterParameters.Add(param)
                          End If

  But it's need apply with the Template instead of SqlSyncScopeProvisioningType.Scope

  For make the filtering works, I need to provisioning with the scope. Here is the method that I am ref:
  
  https://social.microsoft.com/Forums/en-US/838c975a-d6bb-48b8-986c-cdde1460da6c/cannot-find-a-valid-scope-in-table-scopeinfo

  I have to customize the provider, on this class, I have Me.ScopeName = scopeName. 

  How how I can reach  my goal with an existing SqlSyncScopeProvisioningType.Template. Is it auto generate the score then?

  Thursday, June 14, 2018 12:10 PM