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

New Map Viewer and Classic cannot handle underscore in Filters

dougbrowning

The New Map Viewer does not handle underscore correctly in a filter. It seems to do nothing. Looks like maybe escape was not programmed in? I just checked and the classic viewer does not work either.

In Python it is

whereClause = "RecKey LIKE '%$_' ESCAPE '$' Or RecKey LIKE '$_%' ESCAPE '$'"

Is there a way to use escape or similar?

thanks

Find more posts tagged with

Mapping

Accepted answers

jcarlson

Try using brackets to escape wildcards. It appears your guess is right, ESCAPE doesn't really do anything.

Here's a feature w/ an underscore.

Filtering for "contains _":

(For the record, those other features do not have underscores.)

Filtering for "contains [_]":

All comments

jcarlson

Try using brackets to escape wildcards. It appears your guess is right, ESCAPE doesn't really do anything.

Here's a feature w/ an underscore.

Filtering for "contains _":

(For the record, those other features do not have underscores.)

Filtering for "contains [_]":

dougbrowning

Well that worked. Where did you find that? Is it documented?

Thanks

jcarlson

I've no idea if it's documented in the ESRI-verse anywhere, but I had to do a similar filter once and saw this in the MS SQL docs: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?view=sql-server-ver15#using-wildcard-characters-as-literals

dougbrowning

I did not even try it since [] does not work on a GDB. I have found the SQL to be slightly diff for each place in Arc, which is a major pain. I found things like CAST works on a GDB but not a in_memory set. https://community.esri.com/t5/data-management-questions/using-sql-cast-functionality-in-against-a-file/td-p/209575

Wish it was all consistent. Thanks

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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