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

  • Question

  • 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

  • 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
    Moderator