漏洞
When using Return Distinct Values with the Out Fields and Output Statistics parameters, the ArcGIS REST query request returns unexpected results by using both the out fields and the output statistics field as distinct values instead of just using the out fields.
| 漏洞 ID 编号 | BUG-000169317 |
|---|---|
| 已提交 | July 23, 2024 |
| 上次修改时间 | October 14, 2024 |
| 适用范围 | ArcGIS Online |
| 找到的版本 | June 2024 |
| 操作系统 | Windows OS |
| 操作系统版本 | 11.0 64 bit |
| 状态 | As Designed |
附加信息
The current implementation does not support the use of distinct count in combination with aggregation for fields other than those used in the statistics calculation. This behavior applies to both the Online and Enterprise feature services. Current Behavior: For non-aggregated queries, the documented behavior is correct. For aggregated queries with distinct count: The system always uses the statistics field as the distinct field. In the example provided, it is the population field. Out fields are only supported for aggregated queries if they are the group by fields. Explanation: The query structure in question presents challenges in interpretation and execution. After careful consideration and discussion with the Enterprise team, it is determined that supporting this specific use case would introduce significant complexity and potential risks to the system.解决办法
It is recommended for the users seeking to achieve similar results to follow the following approach: Use a group by clause on the desired fields (e.g., GROUP BY zipcode, population). Calculate the distinct sum for each group. If needed, infer the total sum from the grouped results. This method provides a more reliable and supported way to obtain the required information while maintaining system integrity and performance.
重现步骤
漏洞 ID: BUG-000169317
软件:
- ArcGIS Online
当漏洞状态发生变化时获得通知
发现关于本主题的更多内容
搜索相关信息
查找与此主题相关的培训
探索想法并提供反馈
获取来自 ArcGIS 专家的帮助
下载 Esri 支持应用程序