I have a merge publication with parameterized filter articles.
The filter statement of one article is:
SELECT <published_columns> FROM [Common].[StaffRule] WHERE StaffRule.ID IN (SELECT StaffRuleID FROM Common.fnCBCBC_Staff(SUSER_SNAME()))
I have created the snapshot files then created the subscription sucessfully.
The unexpected comes when adding a new record to the [Common].[StaffRule] table which satisfy the filter, but the record does not synchronize to the subscriber database.