In Operations Dashboard in ArcGIS Online, Actions do not work properly if the Category Field contains Japanese strings.
上次发布: April 17, 2018ArcGIS Dashboards
漏洞 ID 编号
BUG-000113188
已提交
April 13, 2018
上次修改时间
September 3, 2024
适用范围
ArcGIS Dashboards
找到的版本
6.1
操作系统
Windows OS
操作系统版本
10.0 64 Bit
状态
Will Not Be Addressed
开发团队已考虑过该问题或请求,并决定不会解决该问题。 问题的“其他信息”部分可能包含进一步说明。
附加信息
There is possibly a mismatch between the encoding of the field type (NVARCHAR, in Unicode) and the input character (non-Unicode). Therefore using the "N" prefix can let the database know how to handle the conversion.
However, the "N" prefix is a Microsoft convention. Inserting the "N" prefix 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.
I noticed that 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 should work as is (i.e. without the "N" prefix).
解决办法
Enable the use standardized queries flag to make the queries work.