ArcGIS Blog

Announcements

ArcGIS Pro

In ArcGIS Pro 3.5, Calculate Field does not honor selection or layer filters when using SQL as the expression type on file geodatabase data

By Kory Kramer

Update June 12, 2025

The ArcGIS Server 11.5 Calculate Field patch is available: https://support.esri.com/en-us/patches-updates/2025/arcgis-server-11-5-calculate-field-patch

Update June 5, 2025

This issue is fixed in ArcGIS Pro 3.5 Patch 1 (3.5.1). Each patch is cumulative of all previous patch fixes. It is highly recommended to apply the most current patch immediately after installing ArcGIS Pro 3.5.

Description

The ability to set the expression type to SQL in the Calculate Field geoprocessing tool when working with file geodatabase (.gdb) data was introduced in ArcGIS Pro 3.5. A potential data corruption bug has been discovered wherein Calculate Field does not honor the active selection or layer filters (for example, definition query, time filter, range filter, or spatial filter) when using a SQL expression on file geodatabase data, resulting in all rows being calculated.

Cause

BUG-000176644: Calculate Field does not honor active selection or layer filters when using a SQL expression on file geodatabase data, resulting in all rows being calculated.

Workaround

When using Calculate Field, to preserve the original values of your data, make a copy of the input table as a backup, or use the Enable Undo option in the Geoprocessing pane.
  • Do not use SQL as the expression type until this bug is addressed with a patch. Use Python or Arcade as the expression type.
  • Do not publish web tools from ArcGIS Pro 3.5 to ArcGIS Enterprise 11.5 that include Calculate Field using SQL as the expression type.

Conclusion

This issue will be addressed in 3.5 Patch 1 (3.5.1), planned to be available the first week of June 2025. Until a patch is available, the software update service will be disabled in ArcGIS Pro. A corresponding ArcGIS Enterprise patch will also be made available.
Customers who understand this issue and the workaround can download ArcGIS Pro 3.5 from My Esri.

Share this article

Subscribe
Notify of
2 Comments
Oldest
Newest
Inline Feedbacks
View all comments
Anthony Jones(@anthony-jones_rsk_epd-2-2-2-2)
June 6, 2024 1:36 am

Hi Aziza, thanks for the article, this is great functionality and I’ve learned today that you can create a print service from ArcGIS Pro. However, as you will not be surprised to see someone ask, are there any plans to allow us to host custom print services in ArcGIS Online? We can potentially get access to Enterprise but in conversations with our Esri account managers they’ve generally tried to steer us away from this and suggest the use of AGOL instead. So when we see functionality like this that isn’t available in AGOL it’s a bit frustrating. Any updates would… Read more »

Patrice Labbé(@patlab7)
October 7, 2024 6:03 am
Reply to  Aziza Parveen

Hi Aziza,

Any news about reports in Near Me in ArcGIS Enterprise? Or a Feature Report widget for regular Feature Services? Or any upcoming support for Map Services in both? We really need reporting capabilities built-in in ExB for ArcGIS Enterprise.

Jay Guarneri(@guarnerij)
June 11, 2024 11:17 am

Aziza,

Thanks for the great article! What would be the workflow if we only wanted a report with no maps? That’s actually a more common request at our organization, and I’d love to set a lot of those up for self-service.

Oskar Penje(@oskar-penje)
October 4, 2024 7:47 am

Hi Aziza, thanks for providing a detailed workflow for publishing report templates to portal for use in webapps. I am wondering when we will have the capability of printing reports from selected features (and related records) in experience builder.

Santiago Hoyos(@shoyoseche)
November 20, 2024 3:53 pm

Thank you, Aziza, for this tutorial. I have been following the instructions here presented and have encountered the following issues: 1. Each Subreport starts with a new page which created excessive paperwork for a tool that has 7 layers with 7 subreports and each has one or two records per table. Is there a way to prevent the page jump between subreports? 2. The printing times of the tool when working with multiple layers are too slow, it takes the printing tool around 2 minutes to print which can be very frustrating for users. I have been trying to optimize… Read more »

John Bocan(@jbocan)
December 17, 2024 1:30 pm

Thank you, Aziza, for the excellent tutorials on creating a custom print service with reporting and for implementing it in Experience Builder. I’ve been mostly successful in implementing my own. I have an issue when I try to remove the data references as described in Step 4 of “Create a master report”. You mention that the easiest way to remove the data references from the project is to remove the map. It seems this is successful when I have about 5 layers. More than that, when I remove the map it seems that the data sources remain (I do not get the little red “exclamation… Read more »

Last edited 7 months ago by John Bocan
Emilia Walton(@emilia-waltonscrd-ca_myscrd)
April 14, 2025 4:10 pm

Can this be published to a stand-alone ArcGIS Server 11.3 site?
How is this different from the workflow outlined here, that worked in older versions of ArcGIS Enterprise?
https://www.esri.com/arcgis-blog/products/arcgis-enterprise/mapping/print-reports-from-arcgis-enterprise-web-apps

We are holding at 11.1 due to other integrations.