laptop and a wrench

Bug

The subquery results in SQLite Error returns a "no such table" error message when executing ServiceFeatureTable.queryFeaturesAsync() but works in Service REST.

Last Published: March 22, 2021 ArcGIS Runtime SDK
Bug ID Number BUG-000137419
SubmittedFebruary 11, 2021
Last ModifiedJune 5, 2024
Applies toArcGIS Runtime SDK
Version found100.10
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusWill Not Be Addressed

Additional Information

SQL Subqueries are not currently supported in ArcGIS Runtime.

Workaround

Publishing a database view

  1. Create a database view using SQL (`create view...`).
  2. Register the view with the geodatabase using the Register with geodatabase tool.
  3. Publish the view as a map service (`MapServer`). Note you can also publish a feature service (`FeatureServer`) as long as the edit capability is not enabled.
  4. Using the ArcGIS Runtime API Create a ServiceFeatureTable/FeatureLayer from the service layer referencing the view e.g. `https://server.esri.com/server/rest/services/RI_0_2543367View/MapServer/0`.
  5. Set the `FeatureLayer.DefinitionExpression` to: table.DefinitionExpression = $"GRAPHICALID IN (101, 102)".

Steps to Reproduce

Bug ID: BUG-000137419

Software:

  • ArcGIS Runtime SDK

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options