idea ArcGIS Pro Select by Attribute show ALL values in ArcGIS Pro Ideas

ArcGIS Pro Select by Attribute show ALL values

HeatherScroggins — Thu, 22 Jul 2021 12:30:13 GMT

I've recently been using Pro more and more just to get comfortable with. And there is a major quirk that I just discovered.

In ArcMap, when you Select by Attribute and get unique values it will show you ALL values in that field. Even ones that aren't in the domain. This is highly handy as it's a quick way to see if there is incorrect data. In the image below, you can see that ArcMap shows two values ('ABS' and 'ASM') that are in the data but not in the domain.

By comparison, Pro only shows you values that are in the domain.When looking at the list I would have no idea that those two values are in my data. And yes, I can build the SQL expression manually if I know the values are there, but what if I don't?

Having the Select by Attribute list ALL values not matter if they were in the domain or not was VERY helpful and I wish that Pro would follow ArcMap's example.

Re: ArcGIS Pro Select by Attribute show ALL values

ThomasColson — Mon, 02 Dec 2019 13:36:00 GMT

This is a BUG. It is very common to have illegal values in a domain-controlled attribute, especially if field calculator is used on the field, or, the field was populated with values then a domain was applied to it, and you want to use select by attributes to find all of the illegal values, OR, the domain gets updated (say you had mis-spelled a domain value and corrected it). This has popped up before, and using expressions (by first having to know the value you're looking for) and manually typing things was the proposed work around. There may even be an idea on this, but I can't find, but I do recall a vigorous debate on this.

Re: ArcGIS Pro Select by Attribute show ALL values

CathieCampbell — Tue, 13 Apr 2021 04:23:50 GMT

Is anyone able to comment if this quirk/bug been fixed in the new versions of Pro?

Re: ArcGIS Pro Select by Attribute show ALL values

KoryKramer — Tue, 13 Apr 2021 23:47:56 GMT

The behavior has not been changed in Pro. I just wanted to comment that if the actual use case is to find values that are not part of a domain...

...for example, in ArcMap 4 is not part of the domain assigned to my Size field:

One option is to select invalid features.

I understand that there may be other workflows where users are looking for the functionality requested by this idea, but wanted to provide this info in hopes that it helps those using it for QA.

Re: ArcGIS Pro Select by Attribute show ALL values

CathieCampbell — Thu, 22 Apr 2021 06:05:15 GMT

Thanks KoryKramer, not quite what I'm after but I have done some more research on my layer and found what is happening but not sure if it is something I'm doing wrong. What I have is Building Areas and they are broken down into different subtypes such as education, emergency, health etc and under each of these subtypes is a domain of building functions. when I try to do a select by attributes it only shows the domain values for the first subtype but I can't seem to get it to show the values for the other domain values. Even when I select the option of a feature subtype, it still shows the first subtype (education) building function domain.

I feel I have just missed a tick box or an option somewhere.

Re: ArcGIS Pro Select by Attribute show ALL values

KoryKramer — Thu, 22 Apr 2021 17:12:24 GMT

@CathieCampbell So are all of your domain codes in a single BuildingFunction domain, or are there different domains, one for each building subtype? I'm trying to understand how you have the data set up.

Re: ArcGIS Pro Select by Attribute show ALL values

CathieCampbell — Thu, 22 Apr 2021 20:49:11 GMT

Hi @KoryKramer . Sorry should have been a bit clearer, there are different BuildingFunction domains for each building subtype.

So the Educational building subtype only has an educational domain ( buildings as options academy, school...) and same for Health subtype with a Health domain (hospital, nursing care..) etc.

As they are in the one layer, when I try to do a select by attributes I could be looking to highlight the emergency and health buildings in the area and I have tried to do a select by feature type as emergency and then function by but it still only shows the educational options (again which is the first subtype).

I don't have many layers with this setup of multiple domains for subtypes and have managed to work around the select by attributes by using the SQL function and typing it in, but it would be easier if I could select the option from the drop down menu in the expression builder. I know in ArcMap I used to click on list all values and it would show all of the values in that field (same as the initial post).

Not sure if this is a bug, quirk or just how it is, it's more of I want to know if it is possible, what do I need to do to do it.

Re: ArcGIS Pro Select by Attribute show ALL values

KoryKramer — Fri, 23 Apr 2021 14:54:34 GMT

Thanks @CathieCampbell

I set up something similar to what you have:

Below you can see that in my attribute table I have 1 feature from each subtype, so the BldgFunction field has 1 value from each different domain:

In the query builder dropdown, I see the available values to choose from, not just from a single domain.

In your attribute table, do you have values from multiple domains? Is there a definition query set on the layer? As far as I can tell, I am still not seeing what you are seeing, so this will take further troubleshooting.

Re: ArcGIS Pro Select by Attribute show ALL values

CathieCampbell — Mon, 26 Apr 2021 22:40:43 GMT

Hi @KoryKramer , Thanks again for testing this. To answer your questions -

Yes in my attribute table I have values from the multiple domains under the sub types. this is just a snippet of what I get for values in ArcMap showing the unique values I have for Building functions.

No, there is no definition query set on the layer (that I'm aware of).

This data is data that we have had for a while and was set up way before my time on an Enterprise Database in ArcDesktop, so there could be conflicts with this. It still is on an Enterprise database but has been upgraded to current, so not sure if that causes issues as well. I'm not sure and don't know enough about sub types and domains but will keep doing research when I can. It might be something in the setting up of the domains/sub types, and I don't have time to update all the layers we have. It's as it's not stopping production, so will just have to put up with it for now till can find the cause.

Cheers

Re: ArcGIS Pro Select by Attribute show ALL values

Matt-Huser — Fri, 19 Nov 2021 21:38:40 GMT

I just wanted to upvote this topic as the Get Unique Values function was a really simple way to identify when someone Field Calculated a value that does not match a valid domain entry. I'm still not seeing an alternative workflow in ArcPro for this common data quality issue. In 2.8.3, using the select by attributes query, I can only select valid domain values and it ignores values that exist in the data that do not meet the domain requirement. In my example below the "Village of Itasca and Village of Schaumburg" were added incorrectly. Visually it is super straightforward to spot them in ArcMap since they don't have the format of [Code - Description]

ArcPro 2.8.3

Re: ArcGIS Pro Select by Attribute show ALL values - Status changed to: Under Consideration

TanuHoque — Fri, 19 Nov 2021 22:24:19 GMT

Re: ArcGIS Pro Select by Attribute show ALL values

KoryKramer — Sat, 20 Nov 2021 00:29:02 GMT

@Matt-Huser

This idea is Under Consideration but I wanted to share a workflow that can help you today.

See Find and correct nonvalid values

I made a quick demo here: https://www.screencast.com/t/iHf0j2BVee

Hopefully this helps!

Re: ArcGIS Pro Select by Attribute show ALL values

Matt-Huser — Tue, 23 Nov 2021 15:15:09 GMT

@KoryKramer I really appreciate the video tutorial, this is extremely helpful as an alternative workflow while the idea is under consideration. Thank you!

Re: ArcGIS Pro Select by Attribute show ALL values

KoryKramer — Tue, 23 Nov 2021 17:12:43 GMT

Glad it helps!

Re: ArcGIS Pro Select by Attribute show ALL values

KarenShaw — Tue, 07 Dec 2021 00:16:17 GMT

The Get Unique Values is very useful ability in Select by Attributes tool. When adding this feature back in, also Please add it as a LIST and Not as a drop down menu. In Pro, having to click on Arrow THEN looking at the list adds complexity.

In Pro

In Pro, clicking the Arrow then scrolling through a List format feels juggling several balls while standing on narrow ledge. The ArcMap way of showing a LIST right away just feels like throwing one ball up in the air and catching it. Must simpler!

And of course, thank-you Developers for all work you do. We know you hear when things go wrong (not as much when things go well). I like a lot things about Pro and appreciate all your hard work you put into it.

Re: ArcGIS Pro Select by Attribute show ALL values

JamesHood — Fri, 22 Apr 2022 21:37:43 GMT

I'll add +1 for upvote please!

I have Pro 2.9.2 . A feature class with many subtypes, and each has their own domain.

When I try to select by attributes OR set a SQL query for labeling I try to click the dropdown to see what attributes are available but I am only able to see values from a single domain for a single subtype.

I even try to be smart and use a more complex query: select where: subtypeField = "my subtype" AND featuteCode = "myValue" but the dropdown list for my feature codes does not populate beyond what's in the first subtype's domain.

So essentially I need to keep a list on the side of dissolved attributes for my feature classes with subtypes in order to be able to write sql queries quickly.

ArcMap had no issue with just showing us all the values and when we want to symboloize the symbology pane does it fine... why not this?

Re: ArcGIS Pro Select by Attribute show ALL values

DanielGluck — Wed, 03 Aug 2022 08:17:04 GMT

I have the same problem as JamesHood 😒. Does anyone find a solution for that?

Re: ArcGIS Pro Select by Attribute show ALL values

EricPescatore — Fri, 19 Aug 2022 21:47:19 GMT

I have been sitting on this for years now and finally got tired of this issue. Thank you for the Select Invalid Objects which is an interesting way to find the data. Unfortunately still takes more steps than I feel should be necessary to quickly query the data.

In my scenario, i had over 1000 invalid records spread across 24 invalid objects (imagine 283 records of ReD) when the domain is RED etc.. I could have done a sum export to get all the values to paste into the SQL query, but again that was a ton of extra steps.

Given that both ArcGIS Desktop and the WEB Client versions of Map Viewer (Both Classic/New) allow for the function to select query UNIQUE values.

Is there a way to TRACK this or add this as an ENH request so that I would be notified when its implemented?

Re: ArcGIS Pro Select by Attribute show ALL values

KoryKramer — Fri, 19 Aug 2022 22:18:09 GMT

@EricPescatore "Is there a way to TRACK this or add this as an ENH request so that I would be notified when its implemented?"

Please make sure to add your Kudos to this idea to up the priority. That should automatically subscribe you to notifications which you will get when we update the status.

Re: ArcGIS Pro Select by Attribute show ALL values

EricPescatore — Fri, 19 Aug 2022 22:27:50 GMT

Thanks, i will do that . I also had our account rep attach our ESRI Case to the already existing ENH request.. It appears that now:

Synopsis: Request to add the functionality to show all values, even the ones not part of the domain code in Select by Attribute on a domain field in ArcGIS Pro

Status: In Product Plan

God willing it will also extend the functionality to the Definition Query menus.