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; } } }

Record bijwerken in een Feature Layer - behandeling van null-waarden

NigelCharmanPre-Prod

Bij het bijwerken van een record in een feature layer lijkt de behandeling van null-waarden te zijn veranderd. Voorheen zorgde het instellen van een veld op null in de update voor een null/leeg waarde in het veld. Nu wordt de waarde ingesteld op 0 voor gehele getallen, 0,00 voor doubles, 1 jan 1970 voor datums.<\/P>

Ik heb dit gemeld bij ESRI support.<\/P>

Vind meer berichten getagd met

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 😀

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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