I need to find all featuress in the zone_code field that begin with N
I entered the sql as zone_code LIKE 'N%' Pro remind me with a wrong expression, this sql i can succeed with database query statement, but failed in pro.
In addition, I entered zone_code LIKE 'N0%' also failed, only zone_code LIKE 'N01%' can be executed successfully. Why is that?
What kind of database do you use for querying?
On enterprise database and FGDB it works, on shape file doesn't.
P.s. After restart of ArcGIS Pro it works on shapefile too.
You can add one line of code to your add-in to check what is your database wildcard symbol is.
string wildChar = geodatabase.GetSQLSyntax().GetSpecialCharacter(SQLSpecialCharacter.WildcardManyMatch);
sir, I just did the test
The layer object I query is created by new featureservice url, if I add the current layer directly to the database table for like %N query it is valid.
Maybe the layer object created by featureservice url does not support this query.
my database is SQLServer.
But the Layer object I query is created by new featureservice url.
According to the test result, the featureservice layer seems to have some problems with this kind of query, some layers are valid, some will prompt the sql statement is invalid.