Filter (clsMiningModel)
Note
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
The filter property is an SQL filter expression that is used to restrict the cases that are used by mining model objects.
Data Type
String
Access
Read/write
Remarks
This pass-through filter condition is applied to the SQL query that returns the cases for the mining model object.
This property applies only to objects with a ClassType of clsMiningModel and a SubClassType of sbclsRelational.
Example
The following filter restricts the cases to customers involved in the first million transactions:
"sales_fact_1997.transaction_id <= 1000000"