| Bug ID Number |
BUG-000137419 |
| Submitted | February 11, 2021 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS Runtime SDK |
| Version found | 100.10 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | Will Not Be Addressed
The development team has considered the issue or request and concluded it will not be addressed. The issue's Additional Information section may contain further explanation.
|
Additional Information
SQL Subqueries are not currently supported in ArcGIS Runtime.
Workaround
Publishing a database view
- Create a database view using SQL (`create view...`).
- Register the view with the geodatabase using the Register with geodatabase tool.
- 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.
- 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`.
- Set the `FeatureLayer.DefinitionExpression` to: table.DefinitionExpression = $"GRAPHICALID IN (101, 102)".
Steps to Reproduce