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

Mettre à jour un enregistrement dans une couche d'entités - traitement des valeurs nulles

NigelCharmanPre-Prod

Lors de la mise à jour d'un enregistrement dans une couche d'entités, il semble que le traitement des valeurs nulles ait changé. Auparavant, définir un champ à null lors de la mise à jour provoquait une valeur nulle/vide dans le champ. Maintenant, la valeur est définie à 0 pour les entiers, 0.00 pour les doubles, 1er janv. 1970 pour les dates.<\/P>

J'ai signalé cela au support ESRI.<\/P>

Trouver plus de publications taguées avec

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 😀

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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