The EnumAllSubsetFilters method returns a QueryResults object enumerating the join filters defined within a merge replication publication.
object.EnumAllSubsetFilters() as QueryResults
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
A QueryResults object containing one result set defined by these columns.
| Column | Data type | Description |
|---|---|---|
| join_filterid | integer | System-generated identifier. |
| filtername | nvarchar(129) | Name of the filter. |
| join article name | nvarchar(129) | Name of the article on which the filter is defined. |
| join_filterclause | nvarchar(1001) | Transact-SQL WHERE clause defining the filter. |
| join_unique_key | integer | When 1, the filter depends on a unique or key value. When 0, the filter does not depend on a unique value. |
| base table owner | nvarchar(129) | Name of the owner of the table joined to in the filter clause. |
| base table name | nvarchar(129) | Name of the table joined to in the filter clause. |
| join table owner | nvarchar(129) | Name of the owner of the table joined from in the filter clause. |
| join table name | nvarchar(129) | Name of the table joined from in the filter clause. |
| article name | nvarchar(129) | Name of the article containing the joined from table. |
HRESULT EnumAllSubsetFilters(
LPSQLDMOQUERYRESULTS* ppResults);