laptop and a wrench

Bug

Query on the map service layer fails when the 'distinct values' parameter is set to true and the 'record count' parameter is specified for the referenced data from the SQL Server or PostgreSQL.

Last Published: May 18, 2022 ArcGIS GIS Server
Bug ID Number BUG-000149241
SubmittedMay 13, 2022
Last ModifiedOctober 28, 2025
Applies toArcGIS GIS Server
Version found10.9.1
Operating SystemWindows Server
Operating System Version2019 64 Bit
StatusAs Designed

Additional Information

When pagination parameters (such as returnResultCount and resultOffset) are used in a query request together with returnDistinctValue, the orderBy parameter must include a field from the outFields parameter. This limitation is imposed by certain underlying databases. Therefore, the bug reported for the map service is closed as designed. However, the issue encountered in the ArcGIS Experience Builder app is resolved in newer versions of ArcGIS Enterprise, such as version 11.3 and later.

Steps to Reproduce

Bug ID: BUG-000149241

Software:

  • ArcGIS GIS Server

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options