topic queryRelatedFeaturesWithParameters - Offline Related Table in ArcGIS Runtime SDK for iOS Questions https://community.esri.com/t5/arcgis-runtime-sdk-for-ios-questions/queryrelatedfeatureswithparameters-offline-related/m-p/729672#M6537 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">Is -queryRelatedFeaturesWithParameters() the only method that can be used when querying a non-spatial offline table? It seems that the AGSRelationshipQuery class assumes that we use the OBJECTID as the link between the feature table and related table, which my application does not.</P><P></P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">In my application, we allow the user to specify any field they want as the link. For example, 'HydrantID' could be the common linking field between our feature table and related table.</P><P></P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">As always, we have used the AGSQuery class for querying related records, using a custom 'where' clause. Unless I'm mistaken, this custom 'where' clause does not exist in the AGSRelationshipQuery object. This is the problem. Does anyone have a suggestion as to how to query an offline related table without using the OBJECTID as the link?</P><P></P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">Thanks,</P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">Colin</P></BODY></HTML> Wed, 17 Dec 2014 15:33:55 GMT ColinCole 2014-12-17T15:33:55Z queryRelatedFeaturesWithParameters - Offline Related Table https://community.esri.com/t5/arcgis-runtime-sdk-for-ios-questions/queryrelatedfeatureswithparameters-offline-related/m-p/729672#M6537 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">Is -queryRelatedFeaturesWithParameters() the only method that can be used when querying a non-spatial offline table? It seems that the AGSRelationshipQuery class assumes that we use the OBJECTID as the link between the feature table and related table, which my application does not.</P><P></P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">In my application, we allow the user to specify any field they want as the link. For example, 'HydrantID' could be the common linking field between our feature table and related table.</P><P></P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">As always, we have used the AGSQuery class for querying related records, using a custom 'where' clause. Unless I'm mistaken, this custom 'where' clause does not exist in the AGSRelationshipQuery object. This is the problem. Does anyone have a suggestion as to how to query an offline related table without using the OBJECTID as the link?</P><P></P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">Thanks,</P><P style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">Colin</P></BODY></HTML> Wed, 17 Dec 2014 15:33:55 GMT https://community.esri.com/t5/arcgis-runtime-sdk-for-ios-questions/queryrelatedfeatureswithparameters-offline-related/m-p/729672#M6537 ColinCole 2014-12-17T15:33:55Z