laptop and a wrench

Bogue

When a hosted feature layer view has both a view definition/filter and a topFilter parameter applied, ArcGIS Online appears to apply the topFilter parameter first and then the view definition, causing the topFilter parameter to return records filtered out by the view definition.

ArcGIS Online
Numéro d’ID de bogue BUG-000164286
EnvoiJanuary 11, 2024
Dernière modificationMay 27, 2025
S’applique àArcGIS Online
Version trouvéeOct 2023
Système d’exploitationN/A
Version du système d’exploitationN/A
StatutAs Designed

Informations supplémentaires

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.

Solution de contournement

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.

Étapes pour reproduire

ID de bogue: BUG-000164286

Logiciel:

  • ArcGIS Online

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement