~Fritz EkfoobergflarMay 2, 2016, 2:19 PM202 PostsPlease don't post your question across multiple forums, here is my answer in the other for...Link
~Sigmund UmwemanoniMay 2, 2016, 2:23 PM323 PostsWell, I started with the easy thing to check.The Help database reports that @UserRoles isn't supported in a SELECT formula. Now, that's not complete obliteration of functionality, but it should be taken to heart that there are subtleties that are likely to interfere.
~Lorraine BubweplopyndsMay 3, 2016, 6:19 AM11 Posts@UserRoles in DB Replication Selection FormulaThank you for the response. Since @UserRoles is not supported in DB replication selection formula how can I force each user to replicate only the documents that he has Author or Reader authority on them.
~Fritz EkfoobergflarMay 3, 2016, 2:00 PM202 PostsSo...If the document has a reader field, it won't replicate to the local replica unless the user ID replicating is in that reader field. For getting a users docs during selective replication, something like SELECT @Author = @username | @AllChildren
~Lorraine BubweplopyndsMay 4, 2016, 6:53 AM11 Posts@UserRoles in DB Replication Selection FormulaMy application depends on the Roles not the usaer names. So How can I replicate based on the roles