topic Re: Field Calculate 'Use the selected records' Does Not Honor Selection Layers When Disabled in ArcGIS Pro Questions

Field Calculate 'Use the selected records' Does Not Honor Selection Layers When Disabled

MitchHolley1 — Wed, 21 Feb 2024 21:38:59 GMT

I was calculating some rows on a hosted feature service in ArcGIS Pro 3.2 and noticed something weird. I made a Selection Layer by selecting 100 rows from the hosted feature service attribute table, right-clicked the layer in the Contents Pane and clicked 'Make Layer from Selected Features'. From there I opened the attribute table of the selection layer, selected some rows, right-clicked a field and opened 'Field Calculate', disabled the 'Use the selected records:' slider, and ran the tool. The tool then calculates the value for that field for the ENTIRE hosted feature service layer, and doesn't honor the Selection Layer found in the map.

Has anyone else had this issue? Is this the intended functionality?

Re: Field Calculate 'Use the selected records' Does Not Honor Selection Layers When Disabled

Bud — Thu, 22 Feb 2024 04:00:57 GMT

I was able to reproduce that behavior with a selection layer on a file geodatabase FC in ArcGIS Pro 3.2.2.

I wonder if the selection layer's selection definition set is considered to be an attribute filter. When the Use the selected records toggle is disabled, the GP tool will ignore all attribute filters (definition query, time filter, range filter).

There is a discussion about the toggle behavior here:
Idea: GP Tools — Ignore selection but honor definition query

Re: Field Calculate 'Use the selected records' Does Not Honor Selection Layers When Disabled

MitchHolley1 — Thu, 22 Feb 2024 04:45:10 GMT

Thanks for the reply, Bud. Since this layer is a different layer in the map (yes, they are "pointing" to the same data) my opinion is this behavior shouldn't happen. This makes working with subsets of data extremely difficult and confusing. If I wanted to work with the non-selection dataset, I would use the drop-down in the Calculate Field tool to do so, but that is not my intention.

The 'Source' tab of the layer properties also says this:

I do not want to access all the features in the source data, and that is why the 'Clear selected features to access all features in the source data' radio button in the Selection properties is unchecked. By default, this is unchecked. I shouldn't be able to access ALL features in the source data unless I explicitly tell the software to do so.

Re: Field Calculate 'Use the selected records' Does Not Honor Selection Layers When Disabled

Bud — Mon, 26 Feb 2024 03:25:02 GMT

On a side note, regarding:

If I wanted to work with the non-selection dataset, I would use the drop-down in the Calculate Field tool to do so, but that is not my intention.

What drop-down are you referring to? The Input Table drop-down?

Re: Field Calculate 'Use the selected records' Does Not Honor Selection Layers When Disabled

MitchHolley1 — Mon, 26 Feb 2024 15:19:35 GMT

Yes, the Input Table drop-down.

Re: Field Calculate 'Use the selected records' Does Not Honor Selection Layers When Disabled

MitchHolley1 — Wed, 28 Feb 2024 19:43:02 GMT

FYI @Bud - ESRI has logged this issue as a bug.

Re: Field Calculate 'Use the selected records' Does Not Honor Selection Layers When Disabled

Bud — Wed, 28 Feb 2024 19:44:06 GMT

Thanks! Do you happen to have the bug number?

Re: Field Calculate 'Use the selected records' Does Not Honor Selection Layers When Disabled

andreamangeruca — Fri, 03 May 2024 09:29:42 GMT

I have the same problem on geoprocessing tool. Even though I flagged "only selected" it apply the geoprocessing to the whole feature class.

I'm working on Arcgis Pro 3.2.2.

Any news?

Re: Field Calculate 'Use the selected records' Does Not Honor Selection Layers When Disabled

Bud — Sat, 04 May 2024 16:47:42 GMT

What geoprocessing tool are you using?

Possibly related:

BUG-000166125: ArcGIS Pro 3.2.2 - Make Query Table Tool joining all tables despite selected records