漏洞
Filtering using a field with Thai characters in the Add Category Selector does not work in the Operations Dashboard for ArcGIS web app.
| 漏洞 ID 编号 | BUG-000113965 |
|---|---|
| 已提交 | May 15, 2018 |
| 上次修改时间 | June 5, 2024 |
| 适用范围 | ArcGIS Online |
| 找到的版本 | N/A |
| 操作系统 | Windows OS |
| 操作系统版本 | 10.0 64 Bit |
| 状态 | Will Not Be Addressed |
附加信息
The query would work if a “N” prefix is added to the where clause (i.e. “YEs_NO = N'ใช่'”). The fact that the N prefix works suggests that there’s a possible mismatch between the encoding of the field type (e.g. in Unicode) and the input character (e.g. non-Unicode). The prefix can let the database know how to handle the conversion. However, the "N" prefix is a Microsoft SQL Server convention. Inserting it into the WHERE clause will imply that Operations Dashboard knows the implementation details of a feature service (e.g. what database is used), and in a RESTful system we should not have this knowledge. The service in question actually has the useStandardizedQueries flag disabled. Our recommended workflow is that useStandardizedQueries=true should be enabled. When this flag is enabled, the feature service code will get in the middle between the client and the database and will manipulate the query being built, and the where clause we send will work as is (i.e. without the "N" prefix).重现步骤
漏洞 ID: BUG-000113965
软件:
- ArcGIS Online
当漏洞状态发生变化时获得通知
发现关于本主题的更多内容
搜索相关信息
查找与此主题相关的培训
探索想法并提供反馈
获取来自 ArcGIS 专家的帮助
下载 Esri 支持应用程序