不具合 ID 番号 |
BUG-000164286 |
送信されました | January 11, 2024 |
最終更新日 | May 27, 2025 |
適用対象 | ArcGIS Online |
見つかったバージョン | Oct 2023 |
オペレーティング システム | N/A |
オペレーティング システムのバージョン | N/A |
ステータス | As Designed
開発チームによる確認後に、この動作が設計どおりであると判断されました。 詳細については、「参考情報」セクションをご参照ください。
|
参考情報
This is a known behavior regarding the execution order of filters in feature services. When both viewDefinitionQuery and topFilter are applied to a feature service, the system processes the topFilter first, followed by the viewDefinitionQuery.
To achieve simultaneous execution of both filtering operations, the correct approach is to structure the query using sqlExpression within the viewLayerDefinition instead of using viewDefinitionQuery directly.
The recommended structure is:
json{
"viewDefinitionQuery": "",
"viewLayerDefinition": {
"filter": {
"sqlExpression": "status = 'Active'"
},
"topFilter": {
"orderByFields": "CreationDate DESC",
"groupByFields": "Name",
"topCount": 1
}
}
}
This structure ensures that both the SQL expression filter and the top filter are processed together, providing more precise control over the returned data and preventing unexpected results that may occur when filters are applied in sequence.
対処法
For query purposes, it is recommended to not add the topFilter parameter on the view definition. Use the queryTopFeatures method to get the correct result.
再現の手順