idea Case dependent Unique Value search on ArcGIS Pro Select Layer by Attribute tool in ArcGIS Pro Ideas

Case dependent Unique Value search on ArcGIS Pro Select Layer by Attribute tool

ToddLaQuay — Thu, 18 Oct 2018 14:02:31 GMT

I have found a frustrating quirk in the Unique Value search in the SQL Expression related to the Select Layer by Attribute tool, ArcGIS Pro v2.2.3. You have to know the letter case (upper or lower case) of what you are searching for otherwise no results. This was not an issue in ArcMap, letter case did not matter for results. I don’t always know the case the attributes were entered with, especially in unfamiliar data sets. This needs to be addressed.

Ex) Lower case v = no results Upper case V = results

Re: Case dependent Unique Value search on ArcGIS Pro Select Layer by Attribute tool

ThomasColson — Thu, 18 Oct 2018 17:34:58 GMT

I would think this is a bug?

Re: Case dependent Unique Value search on ArcGIS Pro Select Layer by Attribute tool

KoryKramer — Thu, 25 Oct 2018 21:53:53 GMT

Todd LaQuay‌ Thank you for pointing this out. I think it is an opportunity for improvement!

When you say that letter case didn't matter for results in ArcMap, can you give an example?

I tested in ArcMap and here is what I see:

When I use lowercase, no attributes are found. When I use all uppercase, which is how the attribute is stored, the expression works. So case does matter in the expression.

I'm just wondering how we can compare the two since ArcMap doesn't use intellisense and Pro does.

In Pro, it looks like we see the same behavior:

Because it's just a SQL expression and case does matter.

So if you can point out where in ArcMap letter case doesn't matter, that could be helpful here. But I think it is clear the intellisense in Pro might be improved if it weren't case sensitive.

Re: Case dependent Unique Value search on ArcGIS Pro Select Layer by Attribute tool

ToddLaQuay — Fri, 26 Oct 2018 13:08:45 GMT

So I am referring to the “Get Unique Values” search on a string field. Here is my process in ArcMap:

FENAME = Click the “Get Unique Values” and in “Go To” type a lower case r. That result takes me to the r section of my attributes. The case (upper or lower) does not matter here. See below that closing out the Selection window and starting fresh, but instead typing an upper case R yields the same results taking me to the same section of my attributes list.

ArcMap lower case:

ArcMap upper case:

So this is my issue with ArcGIS Pro, attempting a similar “Unique Value” search as I had shown at the beginning of the post gives no results if you do not know the letter case of the string you are searching for. I understand that it has to be the correct case in the SQL expression in order to yield any results and if I was able to find the attribute through the “Unique Value” search I would and add that correct case attribute value to my expression.

I hope this explanation helps. Additionally I have been screen sharing with tech support to show them what I was talking about.

Re: Case dependent Unique Value search on ArcGIS Pro Select Layer by Attribute tool

KoryKramer — Fri, 26 Oct 2018 13:12:12 GMT

Extremely helpful, Todd. This makes it very clear. Thank you for taking the time to respond.

Cheers

Re: Case dependent Unique Value search on ArcGIS Pro Select Layer by Attribute tool - Status changed to: Implemented

KoryKramer — Tue, 13 Jul 2021 13:01:06 GMT

I just checked on this again (ArcGIS Pro 2.7.3) and it appears that this issue was resolved since the idea was posted. Letter case does not matter - the cursor will go to the letter regardless of whether you enter upper case or lower case.

Re: Case dependent Unique Value search on ArcGIS Pro Select Layer by Attribute tool

DaisyCaranay1 — Wed, 09 Mar 2022 11:26:43 GMT

ArcGIS Pro 2.9.2 the case sensitivity issue is back

Re: Case dependent Unique Value search on ArcGIS Pro Select Layer by Attribute tool

KoryKramer — Wed, 09 Mar 2022 16:22:19 GMT

Hi @DaisyCaranay1 I just tested in 2.9.2 and typing in a lower case case letter takes me to the corresponding value in the pick list even though it is upper case. Do you have a specific example/steps that you can share?