topic Re: LIKE operator with the Query Attributes task failed in ArcGIS Pro SDK Questions

LIKE operator with the Query Attributes task failed

Chapin — Thu, 09 Dec 2021 12:00:08 GMT

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?

Re: LIKE operator with the Query Attributes task failed

Chapin — Thu, 09 Dec 2021 12:25:12 GMT

Why is it that all other letters work but N% is invalid?

Re: LIKE operator with the Query Attributes task failed

GKmieliauskas — Thu, 09 Dec 2021 14:11:20 GMT

Hi,

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.

Re: LIKE operator with the Query Attributes task failed

Chapin — Thu, 09 Dec 2021 13:55:51 GMT

i use enterprise database.I don't know why only this N% is not working

Re: LIKE operator with the Query Attributes task failed

ABishop — Thu, 09 Dec 2021 13:56:39 GMT

Hello Chapin,

Have you tried other like wildcards? Here is a technical support article:

https://support.esri.com/en/technical-article/000010066

Re: LIKE operator with the Query Attributes task failed

GKmieliauskas — Thu, 09 Dec 2021 14:03:51 GMT

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

Re: LIKE operator with the Query Attributes task failed

jcarlson — Thu, 09 Dec 2021 14:31:08 GMT

What does Pro show you when you click "View Details" on the error response?

Also, what database is your SDE in? Postgres? Oracle? MSSQL?

Re: LIKE operator with the Query Attributes task failed

Chapin — Thu, 09 Dec 2021 14:46:18 GMT

is %.

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.

Re: LIKE operator with the Query Attributes task failed

Chapin — Thu, 09 Dec 2021 14:47:21 GMT

thanks.maybe featureservice layer does not support this like query.

Re: LIKE operator with the Query Attributes task failed

Chapin — Thu, 09 Dec 2021 14:50:56 GMT

sir.

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.