Bogue
The subquery results in SQLite Error returns a "no such table" error message when executing ServiceFeatureTable.queryFeaturesAsync() but works in Service REST.
| Numéro d’ID de bogue | BUG-000137419 |
|---|---|
| Envoi | February 11, 2021 |
| Dernière modification | June 5, 2024 |
| S’applique à | ArcGIS Runtime SDK |
| Version trouvée | 100.10 |
| Système d’exploitation | Windows OS |
| Version du système d’exploitation | 10.0 64 Bit |
| Statut | Will Not Be Addressed |
Informations supplémentaires
SQL Subqueries are not currently supported in ArcGIS Runtime.Solution de contournement
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)".
Étapes pour reproduire
ID de bogue: BUG-000137419
Logiciel:
- ArcGIS Runtime SDK
Recevoir une notification lorsque le statut d’un bogue change
En savoir plus sur ce sujet
Rechercher des informations associées
Rechercher une formation sur ce sujet
Explorer des pistes et donner un avis
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support