idea When editing subtype field, account for the fact that the field domain value is now invalid in ArcGIS Pro Ideas

When editing subtype field, account for the fact that the field domain value is now invalid

Bud — Sun, 17 Jul 2022 21:30:33 GMT

Scenario:

I have a subtype on the ASSET_CLASS field in a table.

When ASSET_CLASS = 3, then the ACTIVITY field uses an ACTIVITY_ROAD domain.

If I were to change the ASSET_CLASS value from ROADS to WATERCOURSE:

Then the ACTIVITY's value would stay the same (although it now shows the domain's code (RWID) instead of the domain description (ROAD WIDENING)...but I suppose that's to be expected).

It seems like ArcGIS should do something to account for the fact that the ACTIVITY is no longer valid for the ASSET_CLASS subtype. In other words, RWID (ROAD WIDENING) isn't a valid ACTIVITY for WATERCOURSE. WATERCOURSE has it's own domain: ACTIVITY_WATERCOURSE.

Note: I did get the message/option below. But choosing "Yes" had no effect on the ACTIVITY field, since the ACTIVITY field doesn't have a default value (and we don't want it to have a default value):

Could Pro be enhanced to account for the invalid domain value in that scenario?

To be honest, I'm not sure what the mechanism should be/how it should be handled. Maybe the ACTIVITY field should get automatically nulled-out? Or a warning message? Thoughts anyone?

Re: When editing subtype field, account for the fact that the field domain value is now invalid - Status changed to: Needs Clarification

Scott_Harris — Thu, 21 Jul 2022 18:30:18 GMT

Hi @Bud

The Attributes Pane will show a warning like this in that scenario:

And prevent the edit if Enforce Validation is checked on in Editing settings: https://pro.arcgis.com/en/pro-app/latest/help/editing/change-general-editing-tool-settings.htm

If you are editing in the Attributes Table it also pops up a similar warning once you attempt to move to the next record (to commit the edit):

-Scott

Re: When editing subtype field, account for the fact that the field domain value is now invalid

Bud — Fri, 22 Jul 2022 17:45:39 GMT

@Scott_Harris Thanks.

The Attributes Pane will show a warning

We don't really use the Attributes Pane very often, only the Attribute Window. So I didn't notice that warning message.

And prevent the edit if Enforce Validation is checked on in Editing settings.

I checked and that setting is enabled.

If you are editing in the Attributes Table it also pops up a similar warning once you attempt to move to the next record (to commit the edit).

I'm not seeing that behavior in a non-spatial table in Pro 2.6.8 (Oracle 18c EGDB). Do you know if it was added in a subsequent release of Pro?

Re: When editing subtype field, account for the fact that the field domain value is now invalid

Scott_Harris — Fri, 22 Jul 2022 17:58:08 GMT

@Bud 2.6 was the release that validation was added for feature classes. 2.8 for standalone tables.

If you are working with a feature class, perhaps you didn't attempt to commit the edit yet by hitting enter or navigating away from the active record?

Re: When editing subtype field, account for the fact that the field domain value is now invalid

Bud — Fri, 22 Jul 2022 18:18:30 GMT

@Bud 2.6 was the release that validation was added for feature classes. 2.8 for standalone tables.
If you are working with a feature class, perhaps you didn't attempt to commit the edit yet by hitting enter or navigating away from the active record?

It's weird, I don't get the warning message in the Attribute Table in 2.6.8, not even when working in a feature class (and saving/committing the record).

I tried with the FC versioned (with base) and non-versioned. No difference.

I could show you in a WebEx session in a meeting, if that would save you some time. Feel free to DM me. Eastern time.

Re: When editing subtype field, account for the fact that the field domain value is now invalid

Scott_Harris — Fri, 22 Jul 2022 19:39:25 GMT

@Bud 2.8 is the first version where I see the error dialog we are talking about being generated from the Attribute Table. So the Map Exploration team must have added it then.

Re: When editing subtype field, account for the fact that the field domain value is now invalid - Status changed to: Already Offered

Scott_Harris — Fri, 22 Jul 2022 19:41:24 GMT

The Attributes Pane will show a warning like this in that scenario:

And prevent the edit if Enforce Validation is checked on in Editing settings: https://pro.arcgis.com/en/pro-app/latest/help/editing/change-general-editing-tool-settings.htm

If you are editing in the Attribute Table (starting in 2.8) it also pops up a similar warning once you attempt to move to the next record (to commit the edit):