laptop and a wrench

Bug

Querying a map service layer for distinct value counts with an SQL expression in the output statistics parameter adds extra parentheses to the request to the database, causing the query to fail.

Last Published: July 27, 2017 ArcGIS GIS Server
Bug ID Number BUG-000105914
SubmittedJune 19, 2017
Last ModifiedNovember 20, 2025
Applies toArcGIS GIS Server
Version found10.5
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusAs Designed

Additional Information

This is expected behavior. To find the count of distinct values, please set returnDistinctValues=true in combination with the count statistic query as provided in the reproducible steps.

Steps to Reproduce

Bug ID: BUG-000105914

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