laptop and a wrench

Bug

When Return Distinct Values is set to True for a feature service or map service and a geometry type is specified, a query from ArcGIS REST API fails on ArcGIS Server with PostgreSQL as the underlying database.

Zuletzt veröffentlicht: July 5, 2019 ArcGIS GIS Server
Bug-ID-Nummer BUG-000118572
EingereichtDecember 4, 2018
Zuletzt geändertJune 5, 2024
Gilt fürArcGIS GIS Server
Gefunden in Version10.6.1
BetriebssystemWindows OS
Betriebssystemversion2016 64 Bit
StatusKnown Limit

Zusätzliche Informationen

This is a known limitation in ArcGIS Server. Our ArcGIS Server REST API states the following: Note: Make sure to set returnGeometry = false when returnDistinctValues = true or results will not be reliable. https://developers.arcgis.com/rest/services-reference/query-feature-service-layer-.htm

Workaround

  1. Run a query with only Return IDs Only set to True, along with an Input Geometry specified.
  2. Take note of the ObjectIDs that are returned and then run another query.
  3. Place the returned ObjectIDs into a second query with the following parameters:
    1. Remove the input geometry.
    2. Return Distinct Values = True.
    3. Return IDs Only = False.
  4. The query should complete successfully.

Schritte zur Reproduzierung

Bug-ID: BUG-000118572

Software:

  • ArcGIS GIS Server

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln