topic Re: New Map Viewer and Classic cannot handle underscore in Filters in ArcGIS Online Questions

New Map Viewer and Classic cannot handle underscore in Filters

DougBrowning — Wed, 13 Oct 2021 14:48:22 GMT

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

Re: New Map Viewer and Classic cannot handle underscore in Filters

jcarlson — Wed, 13 Oct 2021 15:46:37 GMT

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 [_]":

Re: New Map Viewer and Classic cannot handle underscore in Filters

DougBrowning — Wed, 13 Oct 2021 15:51:19 GMT

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

Thanks

Re: New Map Viewer and Classic cannot handle underscore in Filters

jcarlson — Wed, 13 Oct 2021 15:54:43 GMT

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

Re: New Map Viewer and Classic cannot handle underscore in Filters

DougBrowning — Wed, 13 Oct 2021 16:08:35 GMT

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