I am trying to Sync down a feature layer with subquery in WhereClause ROUTE_ID IN (SELECT ROUTE_ID FROM B)
So, my code just does this in SQL terms:SELECT * FROM A WHERE ROUTE_ID IN (SELECT ROUTE_ID FROM B);
That gives me InvalidOperationException exception, stack trace is Stack Trace:
at ESRI.ArcGIS.Mobile.MobileServices.FeatureDataReader.InitCursor()
at ESRI.ArcGIS.Mobile.MobileServices.FeatureDataReader.Reset()
at ESRI.ArcGIS.Mobile.MobileServices.FeatureDataReader..ctor(FeatureLayer featureLayer, QueryFilter queryFilter, EditState requestedEditState, Boolean lockedRead, String[] columnNames)
at ESRI.ArcGIS.Mobile.MobileServices.FeatureLayerSyncAgent.GetFidChecksumDictionary(QueryFilter filter)
at ESRI.ArcGIS.Mobile.MobileServices.FeatureLayerSyncAgent.DownloadExtent(BinaryWriter binaryWriter, QueryFilter filter, Boolean markAsCached, FeatureLayerSyncResults results)
at ESRI.ArcGIS.Mobile.MobileServices.FeatureLayerSyncAgent.ProcessDecomposedExtents(String whereClause, Boolean markAsCached, FeatureLayerSyncResults results, IList`1 decomposedExtents)
at ESRI.ArcGIS.Mobile.MobileServices.FeatureLayerSyncAgent.Download(QueryFilter downloadFilter, FeatureLayerSyncResults results)
at ESRI.ArcGIS.Mobile.MobileServices.FeatureLayerSyncAgent.Synchronize()
On ArcGIS server I have verbose log enabled and it does show correct number of return rows:MobileSync: Get Feature Count for AMS_KY.M_SIGN_INVENTORY [70 features in 1.607800 seconds: rate (43.5 f/s)].
