topic Re: The Calculate Field tool does not honor active selections and layer filters when using a SQL expression on file geodatabase data, resulting in cal in ArcGIS Pro Questions

The Calculate Field tool does not honor active selections and layer filters when using a SQL expression on file geodatabase data, resulting in calcula

LJackson29 — Tue, 12 Aug 2025 20:35:01 GMT

Does anyone know if BUG-000176644 (The Calculate Field tool does not honor active selections and layer filters when using a SQL expression on file geodatabase data, resulting in calculations on all rows) is also occurring in Pro 3.3.5? I have a model builder that has a select by attribute step where it selects features where field = Yes, and then on the selected features, there are 4 field calculate steps, changing the values to Null for all 4 fields. This model builder has been working fine with no issues for the past 2 years. Today, when I ran it, it ran the first field calculate correctly, but the the subsequent 3 field calculates changed all records in the layer to Null! Luckily, I had a backup of the data and can restore it, but I am very concerned it could happen with other model builders (I have about 20 I use to maintain this layer, with many select by attribute and field calculate steps. This is very concerning. Does any one have any insight?

Best,

Leila

Re: The Calculate Field tool does not honor active selections and layer filters when using a SQL expression on file geodatabase data, resulting in cal

DanPatterson — Tue, 12 Aug 2025 21:07:17 GMT

It was only reported in 3.5 and is fixed in the first update (3.5.1 and in the upcoming 3.6)

BUG-000176644 for ArcGIS Pro

If no one noticed in previous versions, or reported it, then it could have existed.

There won't be any backporting of the fix, so the update path would be your only recourse.

Re: The Calculate Field tool does not honor active selections and layer filters when using a SQL expression on file geodatabase data, resulting in cal

LJackson29 — Tue, 12 Aug 2025 21:16:31 GMT

Thanks, it seems somewhat sporadic. Unfortunately, we are stuck at 3.3.5 until we update our enterprise next year.

Re: The Calculate Field tool does not honor active selections and layer filters when using a SQL expression on file geodatabase data, resulting in cal

RhettZufelt — Tue, 12 Aug 2025 21:27:24 GMT

Not an answer to your question, but in Model Builder, I have had better luck with MakeFeatureLayer with SQL expression on it, then perform the calculations on the feature layer. Otherwise, it seems I have to re-select before each operation.

Re: The Calculate Field tool does not honor active selections and layer filters when using a SQL expression on file geodatabase data, resulting in cal

Robert_LeClair — Wed, 13 Aug 2025 17:16:04 GMT

Within the internals, BUG-000176644, is fixed at ArcGIS Pro 3.6, 3.5.1 and the ArcGIS Server 11.5 Calculate Field path is available here - ArcGIS Server 11.5 Calculate Field Patch

Re: The Calculate Field tool does not honor active selections and layer filters when using a SQL expression on file geodatabase data, resulting in cal

Ron_S1 — Wed, 19 Nov 2025 22:37:54 GMT

Has this been fixed for everyone? we have experiencing this but very sporadic, I've caught in recording a couple times. But when I try to create a project that I could send to Esri, it all goes smoothly. I'm if this has been fixed for everyone and maybe this is more of a local issue for us now.

Re: The Calculate Field tool does not honor active selections and layer filters when using a SQL expression on file geodatabase data, resulting in cal

Robert_LeClair — Mon, 24 Nov 2025 22:31:52 GMT

@Ron_S1 - what release of ArcGIS Pro are you using? As mentioned in my above post, BUG-000176644 was fixed at 3.5.1 and 3.6 of ArcGIS Pro.

Re: The Calculate Field tool does not honor active selections and layer filters when using a SQL expression on file geodatabase data, resulting in cal

DanPatterson — Tue, 25 Nov 2025 03:01:52 GMT

also mentioned in my post as being fixed