laptop and a wrench

Bug

ArcGIS Server services with the ArcGIS Pro runtime are unable to process the query REST operation with the LIKE operator.

Last Published: April 3, 2023 ArcGIS GIS Server
Bug ID Number BUG-000155466
SubmittedJanuary 30, 2023
Last ModifiedOctober 23, 2024
Applies toArcGIS GIS Server
Version found10.9.1
Operating SystemWindows OS
Operating System VersionN/A
StatusAs Designed

Additional Information

When StandardizedQueries is enabled, a clause must pass that conforms to that specification. Using a numeric field with the LIKE operator is not supported as not all databases support this type of SQL clause. To make values from a numeric field be treated as string, use CAST() function. E.g.: CAST(incident_count as varchar(10)) like '%7%' The syntax will look like the following: CAST( ❬afield❭ AS varchar( ❬size❭ )) LIKE '%❬value❭%'

Steps to Reproduce

Bug ID: BUG-000155466

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