Bug
Filtering using a field with Thai characters in the Add Category Selector does not work in the Operations Dashboard for ArcGIS web app.
| Bug-ID-Nummer | BUG-000113965 |
|---|---|
| Eingereicht | May 15, 2018 |
| Zuletzt geändert | June 5, 2024 |
| Gilt für | ArcGIS Online |
| Gefunden in Version | N/A |
| Betriebssystem | Windows OS |
| Betriebssystemversion | 10.0 64 Bit |
| Status | Will Not Be Addressed |
Zusätzliche Informationen
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).Schritte zur Reproduzierung
Bug-ID: BUG-000113965
Software:
- ArcGIS Online
Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert
Weitere Informationen zu diesem Thema erkunden
Nach zugehörigen Informationen suchen
Nach Schulungen zu diesem Thema suchen
Ideen erkunden und Feedback geben
Unterstützung durch ArcGIS-Experten anfordern
Esri Support App herunterladen