laptop and a wrench

漏洞

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

上次发布: March 22, 2021 ArcGIS Runtime SDK
漏洞 ID 编号 BUG-000137419
已提交February 11, 2021
上次修改时间June 5, 2024
适用范围ArcGIS Runtime SDK
找到的版本100.10
操作系统Windows OS
操作系统版本10.0 64 Bit
状态Will Not Be Addressed

附加信息

SQL Subqueries are not currently supported in ArcGIS Runtime.

解决办法

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

重现步骤

漏洞 ID: BUG-000137419

软件:

  • ArcGIS Runtime SDK

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项