I am using merge replication in SQL 2012. I have a situation where I am using join filters to filter out what records are being replicated to the subscriber.
When I look at the stored procedure,
sp_addmergefilter
You can only specify one @join_articlename. I want one of my tables to be join filtered by the content of two other tables, is this possible?
It is a bit like this, it relates to security. For example I have some tables,
ColourPermissions
ShapePermissions
Shapes
So if the ColourPermissions table says that my user 'peter' in the system is allowed to see red, blue, and yellow. Also the shape permissions table says that my user 'peter' in the system is allowed to see squares, and circles.
The only way I can filter the Shapes table properly is to join it to the ColourPermissions and ShapePermissions table. So I want my user to see a red square, but not a red hexagon.
Is there a way to do this using join filters, or any alternative ways to do this?
