title: Filtering MS Sync Framework
body: <p>hello been said filtering works with latest Microsoft Sync Framework version. so I used filter passing from client to server</p>
  
  <p>on server(sqlServer08 with change tracking enabled) I have </p>
  
  <p>SqlParameter filterParameter = new SqlParameter("@Institution_ID", SqlDbType.UniqueIdentifier);</p>
  
  <pre><code>    string customerFilterClause = "Institution_ID=@Institution_ID";
      customerBuilder.FilterClause = customerFilterClause;
      customerBuilder.FilterParameters.Add(filterParameter);
  </code></pre>
  
  <p>and on client I have</p>
  
  <p>SyncTable depsSyncTable = new SyncTable("department");
              depsSyncTable.CreationOption = TableCreationOption.DropExistingOrCreateNewTable;
              depsSyncTable.SyncDirection = SyncDirection.DownloadOnly;            </p>
  
  <pre><code>        this.Configuration.SyncTables.Add(depsSyncTable);
          this.Configuration.SyncParameters.Add(
               new SyncParameter("@Institution_ID", new Guid("248a1343-decb-45a5-906f-2fa4d17f8d76")));
  </code></pre>
  
  <p>but filtering doesnt work as it expected, it getms me all data not filteres by institution ID. what I found also that it goes like that only on first time I do syncronize, so while I manually add new rows and press again sync it works great on client and filters them. To summarize I understand that first time Sync creates some anchor and uses it as base point so all prev data gets loaded onto the client, but I would say this is wrong as I still would like my filter working right.</p>
  
  <p>can you help me here? thanks</p>