ArcGIS Pro Select by Attribute show ALL values

[HeatherScroggins]

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. 

[nadja_swiss_parks]

The use of domains changed from ArcMap to ArcGIS Pro. We certainly see the advantages of all values of a domain being available in certain cases. However, we also see the advantages of just being able to choose from the domain values which actually are used (e.g. a long list of possible values, but only 2-3 are actually used; this is often the case in a large-scaled studies (e.g. national or international) which is conducted in different places. All options need to be available/possible, but in that particular area only a subset occurs).

Thus we suggest to add an option, which allows you to choose between all domain values being displayed and only the used domain values being displayed (like "get unique values" in the definition query in ArcMap). We'd propose to add this option at least to "definition query", "select layer by attribute" and "symbology".

agp_all_domainvalues.jpg: all values of the domain

agp_dq_all_domainvalues.jpg: all values of the domain being displayed when adding a definition query

agp_symbology_all_domainvalues.jpg/agp_select_by_attribute_all_domainvalues.jpg: all values of the domain being displayed

arcmap_dq_get_unique_values.jpg: only the used values of the domain are displayed when the button "get unique values" is clicked. we propose to add this button/option also to ArcGIS Pro for those cases, where it is needed.

[KoryKramer]

Hi @nadja_swiss_parks 

For the symbology part of your idea, it is a duplicate of https://community.esri.com/t5/arcgis-pro-ideas/symbolize-add-all-values-option-to-base-on-domain/idi... Please add your kudos and any relevant comments there.

For the part about querying and comparing to ArcMap, that we are looking at through https://community.esri.com/t5/arcgis-pro-ideas/arcgis-pro-select-by-attribute-show-all-values/idi-p/... (note that it is In Product Plan). 

Question: in looking at your work when querying against a field with a domain applied, do you really need the option to use the full domain list, or you just want to choose from existing values in the table? We understand the desire for an option in the symbology case (see the other idea referenced above) but can you clarify whether for queries you are simply looking for the ArcMap behavior? Thanks 

[KarenShaw]

Hi @KoryKrmer,

Do you really need the option to use the full domain list or you just want to choose from existing values in the table?

Yes, it is needed. Having a "get unique values" in Select Attributes Toolset in Pro is important.  For dataset with over 10,000 rows and data entry errors, it critical to "see" what data exists in the table (Not just the one that fit into the "domains").

Adding "Get Unique values" to SQL toggle area would be a HUGE asset to Select by Attribute Pane.

[KoryKramer]

Thanks @KarenShaw I understand the need to see and choose from the values that exist in the table. What I was trying to get at when asking about the option is whether you have scenarios where you want to see a full list of domain values even if those values do not exist in the table. 

For example, you have a domain list of 50 values, but only 3 are used in the table. 'Get Unique Values' shows the 3. Perfect! Do you ever need to still see the full list when setting up your query?

[KarenShaw]

@KoryKramer  What I was trying to get at when asking about the option is whether you have scenarios where you want to see a full list of domain values even if those values do not exist in the table. 

Get Unique Values should show Only the the values that DO exists in the table. The in the SQL Query toggle area in the Select by Attributes Pane, "Get Unique Values" is useful if it shows ONLY have values that exists in the table (not the all possible domain values). If there a value that exists in the table, even if not possible value in the domains (due to error/bug in the table), It Also important to see that too.  Get Unique Values should show what is actually in the attribute table. 

[EricPescatore]

Nothing Matters anymore as its now in the Product Plan, hopefully that means it will be in ArcPro before they come out wit ArcGIS Extreme in 2038... Also fun fact 3.1 was suppose to be release complete with all functions from ArcMap, seem like the missed one.

[nadja_swiss_parks]

Hi @KoryKramer 

to answer your question: It needs both possibilities in our scenario. 1. all possible domain values, e.g. for standardises queries. 2. all values, which are in the attribute table as @KarenShaw indicated. (I assumed in my post, that all values in the attribute table were correct).

[Matt-Huser]

@KoryKramer I know this is probably not the most energizing response to your questions but I would say that ArcGIS Pro should  mimic the functionality/response of ArcMap for the "Get Unique Values" during the select by attributes process.  I would only want to see the results that are in the Attribute Table as records NOT all possible domain results based on the database.

[KoryKramer]

Thanks all for the responses. 

[JonathonMerrick]

@KoryKramer thanks for the response.  It's great to see this getting traction. Whatever ESRI implements should work for all conditions of attribution. I would like to see buttons for "get unique values", "get all domain values", and "get used domain values".  I could see using all of these methods regularly.