nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Datensatz in einem Feature Layer aktualisieren - Behandlung von Nullwerten

NigelCharmanPre-Prod

Beim Aktualisieren eines Datensatzes in einem Feature Layer scheint sich die Behandlung von Nullwerten geändert zu haben. Früher führte das Setzen eines Feldes auf null bei der Aktualisierung zu einem null-/leeren Wert im Feld. Jetzt wird der Wert für Ganzzahlen auf 0, für Double-Werte auf 0,00 und für Datumswerte auf den 1. Jan 1970 gesetzt.<\/P>

Ich habe dies dem ESRI-Support gemeldet.<\/P>

Finde mehr Beiträge mit dem Tag

Accepted answers

AlagiriVenkatachal

Hi @NigelCharmanPre-Prod,
We wanted to let you know that a fix was pushed out to address the issue that was reported about the treatment of null values. With this fix, null values will continue to be treated as null values.

Thanks,
Alagiri

All comments

Akshay Harshe

@NigelCharmanPre-Prod Thanks for reporting that. May I know what connector, action or trigger you are using and how are you setting the null?

I tried using `Update record in a feature layer` action and it doesn't use those defaults.

{
      "attributes" : {
        "FID" : 231, 
        "objectid" : null, 
        "name" : "Updated -test", 
        "address" : "test - Atlantic Ocean", 
        "city" : "", 
        "state" : "", 
        "zip" : null, 
        "ownership" : "Updated Test", 
        "ntl_rate" : null, 
        "mortreadmi" : 6, 
        "total" : 876, 
        "latitude" : 32, 
        "longitude" : -49, 
        "admissiond" : null, //Date
        "GlobalID" : "47a6a5e9-898a-4628-b8c6-e67d23c443a3"
      }

FYI, I am not passing anything in a those fields,

NigelCharmanPre-Prod

Hi Akshay

It's the ArcGIS connector with the "Update a record in a feature layer" step.

We're getting the null values back from a "Get data from feature layer" step (running against a child table) and passing them to the "Update a record in a feature layer" step:

Here's the Edit view of the Update step:

Here's a run with the null values:

and some feature layer fields after being updated, showing 1 Jan 1970 and 0.00:

Akshay Harshe

@NigelCharmanPre-Prod Thanks for sharing this. I was able to reproduce this when tried using the function null, If I don't pass anything then it creates a null. I am having our developer look at this. If you must make your flow run, try and see if you can pass nothing when the input is null.

NigelCharmanPre-Prod

@AkshayHarshe I don't think it's possible to conditionally select which fields are updated in this step. The only way I can see would be to call different steps dependent on whether the fields are null. But since we have 5 fields that could be null, this would require 5! steps, which is unmanageable. I think we'll need to create a Notebook to modify the fields that have been written incorrectly.

Would you let me know when you have a date for a fix to be released, please?

Pavel148

Hi,
This issue should be fixed in production as of 2025/03/10 for ArcGIS and ArcGIS Enterprise connectors.

Expected behaviour is when a null or empty value is passed to date fields, the value will be null.
The same is expected of numeric and string fields.

Thanks for reporting it!

NigelCharmanPre-Prod

Thanks, I can confirm that the fix solves my problem 😀

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.