laptop and a wrench

Bogue

Publishing mapping services containing layers with joins in ArcGIS Enterprise results in the advanced query capability being set to FALSE, unless the joined table is contained in the same map service.

ArcGIS GIS Server
Numéro d’ID de bogue BUG-000167543
EnvoiMay 16, 2024
Dernière modificationJanuary 6, 2026
S’applique àArcGIS GIS Server
Version trouvée11.3
Système d’exploitationWindows Server
Version du système d’exploitation2022
StatutAs Designed

Informations supplémentaires

The support for advanced queries completely relies on the underlying database. The map service generates an SQL containing the entire join definition and pushes it to the database to execute it. When tables are coming from different databases, the query fails. Hence, map services do not support advanced queries such as outStatistics when joins are made of tables from multiple databases.

Solution de contournement

If the table or layer from the same workspace that participates in the join is included in the service, the advancedQueryCapabilities property is set to TRUE for all ArcGIS Enterprise versions 10.9.1, 11.1, 11.2, and 11.3.

Étapes pour reproduire

ID de bogue: BUG-000167543

Logiciel:

  • ArcGIS GIS Server

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