I would like to get some data from a ArcGIS rest service filtered by the whereclause of queryfilter. It is working that the field name is English but failed with Chinese field name. I also try to plus double quotes(") or square brackets([]) to the Chinese field but is still not working. (ex: "㯗位"='001' or [欄位]='001'). The first syntax got timeout and next got an error message: An invalid SQL statement was used.
I've been investigating this issue. Are you using the Pro SDK (i.e., Table.Search(QueryFilter)) to execute this query, or going directly against the REST endpoint? What is your underlying database type?
Thanks,
--Rich
Hi Rich Ruh,
I queried the service data by Table.Search method. Our team doubt the issue is caused by the performance weakness of this service with over two millions polygon data. Now we solved this problem by API solution. Thank you for your attention.