Error
The subquery results in SQLite Error returns a "no such table" error message when executing ServiceFeatureTable.queryFeaturesAsync() but works in Service REST.
| Número de ID del error | BUG-000137419 |
|---|---|
| Enviado | February 11, 2021 |
| Última modificación | June 5, 2024 |
| Relacionado con | ArcGIS Runtime SDK |
| Versión encontrada | 100.10 |
| Sistema operativo | Windows OS |
| Versión de sistema operativo | 10.0 64 Bit |
| Estado | Will Not Be Addressed |
Información adicional
SQL Subqueries are not currently supported in ArcGIS Runtime.Solución alternativa
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)".
Pasos para reproducir
ID del error: BUG-000137419
Software:
- ArcGIS Runtime SDK
Recibir notificaciones cuando cambie el estado de un error
Descubrir más sobre este tema
Buscar información relacionada
Encontrar formación relacionada con este tema
Explorar ideas y aportar opiniones
Obtener ayuda de expertos en ArcGIS
Descargar la aplicación de soporte de Esri