BUG-000113188 for ArcGIS Dashboards

Numéro d’ID de bogue	BUG-000113188
Envoi	April 13, 2018
Dernière modification	September 3, 2024
S’applique à	ArcGIS Dashboards
Version trouvée	6.1
Système d’exploitation	Windows OS
Version du système d’exploitation	10.0 64 Bit
Statut	Will Not Be Addressed

Informations supplémentaires

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).