nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

LIKE operator with the Query Attributes task failed

Chapin

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?

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

Chapin

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.

Chapin

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

jcarlson

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

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

GKmieliauskas

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

ABishop

Hello Chapin,

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

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

Chapin

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

GKmieliauskas

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.

Chapin

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

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.