Bug
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.
| Bug ID Number | BUG-000167543 |
|---|---|
| Submitted | May 16, 2024 |
| Last Modified | January 6, 2026 |
| Applies to | ArcGIS GIS Server |
| Version found | 11.3 |
| Operating System | Windows Server |
| Operating System Version | 2022 |
| Status | As Designed |
Additional Information
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.Workaround
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.
Steps to Reproduce
Bug ID: BUG-000167543
Software:
- ArcGIS GIS Server
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App