不具合
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 Support アプリのダウンロード