I have the need for a complex filter on my provisioning scope. Currently the filterclause contains up to three nested selected statements which is impacting the sync process greatly. Is it possible to assign a stored procedure in the filterclause similar to:
string spDefinition = "exec spTest @ID";
eventScopeServerTemplate.Tables["Products"].AddFilterColumn("ID");
eventScopeServerTemplate.Tables["Products"].FilterClause = "[side].[ID] IN (" +
spDefinition + ")";
SqlParameter param = new SqlParameter("@ID", SqlDbType.Int);
eventScopeServerTemplate.Tables["Products"].FilterParameters.Add(param);
-f