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

Zusätzliche Informationen

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)".

Schritte zur Reproduzierung