topic Re: ArcGIS Pro Calculate Field (using SQL) Not Honoring Selection in ArcGIS Pro Questions

ArcGIS Pro Calculate Field (using SQL) Not Honoring Selection

KyleBalke__GISP — Wed, 27 Mar 2019 20:41:08 GMT

It appears that the Calculate Field tool when using the SQL expression type in ArcGIS Pro 2.3.1 does not honor a selection set. Is this functionality not supported or this a bug? I could not find any mention of this in the ArcGIS Pro help.

Re: ArcGIS Pro Calculate Field (using SQL) Not Honoring Selection

KyleBalke__GISP — Wed, 27 Mar 2019 21:01:43 GMT

After additional testing I have found that this issue also occurs when using the Python 3 expression type and leads me to believe this is a bug (and a significant one at that).

Re: ArcGIS Pro Calculate Field (using SQL) Not Honoring Selection

Robert_LeClair — Wed, 27 Mar 2019 21:08:30 GMT

I'm using AGP 2.3.2 and tested this with Arcade and Python and it worked as expected. What was unexpected is that using SQL expressions on a file geodatabase feature class threw "ERROR 002536: Table <FC> does not support or is in a state to support SQL expressions." Querying this error, the Help page said SQL expressions are only supported on feature service and enterprise geodatabase data. That's a significant change to me!

Re: ArcGIS Pro Calculate Field (using SQL) Not Honoring Selection

KoryKramer — Wed, 27 Mar 2019 21:15:15 GMT

Robert, it's documented that SQL expression type is only for

https://pro.arcgis.com/en/pro-app/tool-reference/data-management/calculate-field.htm

Kyle Balke, GISP‌ it would be important to provide steps, more details, and screenshots to understand what you're seeing especially since Robert says he tried with Arcade and Python and it works as expected.

You don't have layers with the same name in a map do you?

Re: ArcGIS Pro Calculate Field (using SQL) Not Honoring Selection

Robert_LeClair — Wed, 27 Mar 2019 21:18:14 GMT

Very true Kory - saw that after the ERROR message was thrown. Used to my ArcMap days of SQL expressions is all - AGP is a different application as we know. Thx!

Re: ArcGIS Pro Calculate Field (using SQL) Not Honoring Selection

KyleBalke__GISP — Wed, 27 Mar 2019 21:31:17 GMT

I am performing the Field Calculation against a hosted feature service (hence using the SQL expression type). When I select one or more records and perform the calculation it updates all records in the table not just the selected records. I just added the hosted feature layer to a new map in Pro and the selection set was honored. Odd issue indeed...seems as though the layer in the map had an issue/corruption?

Re: ArcGIS Pro Calculate Field (using SQL) Not Honoring Selection

KyleBalke__GISP — Wed, 27 Mar 2019 21:35:09 GMT

Kory I did have two layers with the same name in the map. Once I removed one of the layers the selection set was honored!

Thanks

Re: ArcGIS Pro Calculate Field (using SQL) Not Honoring Selection

KoryKramer — Wed, 27 Mar 2019 21:49:52 GMT

Best practice: try to not have duplicate layer names in a map (but I know there are reasons you might want that, so...)

This issue was discussed here: https://community.esri.com/message/833996-re-applying-field-calculator-only-on-selected-features?commentID=833996&et=watches.email.thread#comment-833996

With duplicate layer names, if you have a selection on the second layer, and if you've right-clicked the field header to open the Calculate Field tool, the tool gets populated with the first layer. As a user, you could switch it over to the second layer, but why would you - you instantiated the tool from the second layer, right?

Anyway, we have a fix for that in Pro 2.4. So until then, not having duplicate layer names will help avoid issues. I hope this helps!

Re: ArcGIS Pro Calculate Field (using SQL) Not Honoring Selection

KyleBalke__GISP — Thu, 28 Mar 2019 14:50:48 GMT

This complete makes sense and really was laziness on my part. I truly appreciate the feedback!

Best,

Kyle

Re: ArcGIS Pro Calculate Field (using SQL) Not Honoring Selection

KoryKramer — Thu, 28 Mar 2019 15:21:57 GMT

I'm glad that helped, Kyle. If you think it was the correct answer, could you please mark it to keep this thread clean?

Thank you.

Re: ArcGIS Pro Calculate Field (using SQL) Not Honoring Selection

PaulHoefflerGISS — Sun, 12 Apr 2020 00:50:57 GMT

I ran into this last night, one in a series of problems when trying to join a table to an ArcGIS Online hosted feature layer and then calculate a field.

This is good information.

It would be even better if an invalid option was not displayed when the inputs contain an unsupported format, instead of as a note in the online documentation.

Python 3 worked for this particular issue.

Thanks for the info, as always!