Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Stored procedures in FilterClause definition in MSF2.1 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi, 

      I´m defining parameter-based filters in my database and I whould like to know if it is possible to define the FilterClause of a sync filter Template in terms of a custom stored procedure. Example:

    serverTemplate.Tables["Sales.Customer"].AddFilterColumn("CustomerType");
serverTemplate.Tables["Sales.Customer"].FilterClause = "[side].customertype in (select GetMyCustomers.CustomerType from GetMyCustomers(@idPerson)) )";

    Thanks in advance,

    Paola

     

    Thursday, March 10, 2011 8:02 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    the filter clause is just added to the other Sync Fx filter clauses, for as long as it is a valid sql statement that can be appended in the Sync Fx where clause, it should work.
    Thursday, March 10, 2011 11:08 PM