| Bug ID Number |
BUG-000167914 |
| Submitted | May 30, 2024 |
| Last Modified | August 2, 2024 |
| Applies to | ArcGIS Pro |
| Version found | 3.3 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | As Designed
After review by the development team, it has been determined that this behavior is as designed. See the Additional Information section for details.
|
Additional Information
When using the First function always add a null check, at runtime if the passed featureset to the First function has no rows, the First function returns null. The validations done both by the expression builder and the at save attribute rules are very basic and do not catch all runtime errors, just like any other programming language.
The expression builder uses the first row in the table if no rows are available in the table, an ephemeral in-memory row is created with default values to be used for validation, and the in-memory row is also used during save time. The expression builder may or may not catch the null error, the same thing with at save. So it is always recommended to handle null checks in the script.
Workaround
When using the First function always add a null check if the returned row is null. That is because the featureset might be empty.
Steps to Reproduce