ArcGIS Server services with the ArcGIS Pro runtime are unable to process the query REST operation with the LIKE operator.
上次发布: April 3, 2023ArcGIS GIS Server
漏洞 ID 编号
BUG-000155466
已提交
January 30, 2023
上次修改时间
October 23, 2024
适用范围
ArcGIS GIS Server
找到的版本
10.9.1
操作系统
Windows OS
操作系统版本
N/A
状态
As Designed
经开发团队审核,已确定此行为符合设计。 有关详细信息,请参阅“其他信息”部分。
附加信息
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❭%'