We're using https://developers.arcgis.com/rest/services-reference/enterprise/create-replica to build a replica with the following hierarchy:
layer -> child layer -> child table 1 -> child table 2
layer relates one to many to child layer
child layer relates one to many to child table 1
child table 1 relates one to many for child table 2
When we set a query on the top-most layer then we only get related data for child layer and the related data (to child layer) for child table 1. However, child table 2 has no data. We would expect child table 2 to have the data related to child table 1 cascading from the chain of relationships to the query on layer.
Does anyone have experience writing a createReplica query to do this? Is this possible with syncOptions?