Hello,
I am using the Download Map button to take a map offline. In the map, I have four feature layers and one standalone table from a published web layer. Two of the feature layers include one-to-many relationship classes to the table, in the enterprise geodatabase. The service is published on a Portal (version 10.9.1), and the data source is SQL Server. ArcGIS Pro version 2.9.1.
The features download correctly to the local mobile geodatabase, including only the features within the map extent. The table downloads also, along with the relationship classes. In my test extent, there are only about 50 features, that only have 50+ related records in the table.
The problem is that the entire contents of the table get downloaded, about 112,000 rows. This is undesirable, because it's very slow (about 20 minutes), and I don't want all those 10s of thousands of extra rows.
I have tried setting a query def on the features and the table, and I still get the entire table. The query def is applied to the local table when the process finishes, but it still contains all of the rows from the source table. I've also tried selecting a subset of features before downloading. Either way, the entire table downloads.
Is there a way to get this tool to only download the rows that are related to the features within the map extent?
Thanks.