topic Query non-feature tables using ArcGIS Runtime SDK for .NET? in .NET Maps SDK Questions https://community.esri.com/t5/net-maps-sdk-questions/query-non-feature-tables-using-arcgis-runtime-sdk/m-p/587726#M7202 <HTML><HEAD></HEAD><BODY><P>Is it possible to query non-feature tables using the ArcGIS Runtime SDK for .NET 10.2.7?</P><P></P><P>I have a native Windows app using a file geodatabase (.gdb) as the source for an ArcGISDynamicMapServiceLayer hosted by a LocalMapService.&nbsp; I want to query a non-feature table in the ArcGISDynamicMapServiceLayer.&nbsp; I can retrieve a list of the tables from AllLayersServiceInfo.Tables and execute a FindTask the same way as I can with feature layers but the FindResult.Results.Count is always 0.&nbsp; I've verified the FindParameters match an existing record in the table.&nbsp; I've tried using the QueryTask but the results are the same.</P></BODY></HTML> Thu, 17 Mar 2016 23:37:50 GMT AndrewFoster 2016-03-17T23:37:50Z Query non-feature tables using ArcGIS Runtime SDK for .NET? https://community.esri.com/t5/net-maps-sdk-questions/query-non-feature-tables-using-arcgis-runtime-sdk/m-p/587726#M7202 <HTML><HEAD></HEAD><BODY><P>Is it possible to query non-feature tables using the ArcGIS Runtime SDK for .NET 10.2.7?</P><P></P><P>I have a native Windows app using a file geodatabase (.gdb) as the source for an ArcGISDynamicMapServiceLayer hosted by a LocalMapService.&nbsp; I want to query a non-feature table in the ArcGISDynamicMapServiceLayer.&nbsp; I can retrieve a list of the tables from AllLayersServiceInfo.Tables and execute a FindTask the same way as I can with feature layers but the FindResult.Results.Count is always 0.&nbsp; I've verified the FindParameters match an existing record in the table.&nbsp; I've tried using the QueryTask but the results are the same.</P></BODY></HTML> Thu, 17 Mar 2016 23:37:50 GMT https://community.esri.com/t5/net-maps-sdk-questions/query-non-feature-tables-using-arcgis-runtime-sdk/m-p/587726#M7202 AndrewFoster 2016-03-17T23:37:50Z Re: Query non-feature tables using ArcGIS Runtime SDK for .NET? https://community.esri.com/t5/net-maps-sdk-questions/query-non-feature-tables-using-arcgis-runtime-sdk/m-p/587727#M7203 <HTML><HEAD></HEAD><BODY><P>Yes Andrew, you can query a non-spatial table using the ArcGIS Runtime SDK for .NET. &nbsp;Whether your data source is an online map service or a local map service, you must use the QueryTask to query a table. &nbsp;The table does not have to be related to a feature layer but must be included in the map service layer definition. &nbsp;Interrogate the&nbsp;<SPAN style="background-color: #ffffff;">AllLayersServiceInfo.Tables collection to find the ID of the desired table. &nbsp;Then, append the table ID to the end of the map service Url when creating the Uri object for the QueryTask. &nbsp;Using the Query object, you specify the search criteria (WHERE clause) targeting the table. &nbsp;You follow the same procedure to query a single feature layer after you discover its layer ID. &nbsp;Here's the main difference between the FindTask and the QueryTask: The FindTask is used to search for a single&nbsp;attribute value on one or more fields in one or more feature layers using the FindParameters.LayerIDs list property&nbsp;and the FindParameters.SearchFields list property. &nbsp;The QueryTask is used to search a single feature layer -or- table by appending&nbsp;the feature/table ID to the map service Uri and using a query string that acts as a WHERE clause.</SPAN></P></BODY></HTML> Tue, 13 Sep 2016 18:51:13 GMT https://community.esri.com/t5/net-maps-sdk-questions/query-non-feature-tables-using-arcgis-runtime-sdk/m-p/587727#M7203 AndrewFoster 2016-09-13T18:51:13Z