laptop and a wrench

Bug

ArcGIS Server is unable to process queries such as "field in ('value')" if the field is an integer and values are enclosed with apostrophes.

Last Published: September 7, 2021 ArcGIS GIS Server
Bug ID Number BUG-000140998
SubmittedJune 25, 2021
Last ModifiedJune 5, 2024
Applies toArcGIS GIS Server
Version found10.9
Operating SystemWindows OS
Operating System VersionN/A
StatusWill Not Be Addressed

Additional Information

Since the column is a numeric type, the correct syntax to be used is objectd in (1).

Workaround

  • Change the field's data type to string.
  • Use a query where values are not enclosed with apostrophes.

Steps to Reproduce

Bug ID: BUG-000140998

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