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

Date Attribute Field Update

JingjingLi

I am facing an issue of updating Date field using null value. The Date field on the feature class is nullable. I created a feature service and loaded it in a silverlight app. I want to make a value in the field to be blank (null). But the attributes property of a graphic is IDictioanry<string, object> which is not nullable. How can I make it accept a null value?
Just like Graphic.Attributes["DateField"] = null

Najděte více příspěvků označených jako

Accepted answers

All comments

JenniferNery

Thank you for reporting this. We'll try to get FeatureDataGrid fixed in the future release.

JingjingLi

Finally I found the reason. The application has a FeatureDataGrid binding to the FeatureLayer. I have to set both FeatureDataGrid.Map and FeatureDataGrid.GraphicsLayer to null before I can assign a null value to g.Attribute["UPDATEDATE"]. See code below,

theFeatureDataGrid.Map = null;
            theFeatureDataGrid.GraphicsLayer = null;
            ESRI.ArcGIS.Client.FeatureLayer fl = theMap.Layers["flyr_RoadClosureLocations"] as ESRI.ArcGIS.Client.FeatureLayer;
            foreach (ESRI.ArcGIS.Client.Graphic g in fl.Graphics)
            {
                if (g.Attributes["UPID"].ToString() == "CAB_035")
                {
                    g.Attributes["UPDATEDATE"] = null;
                }
            }
            theFeatureDataGrid.Map = theMap;
            theFeatureDataGrid.GraphicsLayer = fl;

And it works.

JingjingLi

You are right, by default DateField has a default length of 36.

You can try the following feature service that has a nullable DateField. Setting the attribute value to null does not raise any exception. You can wire up to EndSaveEdits and SaveEditsFailed to see that this new value is actually saved.
FeatureLayer layer = new FeatureLayer() { Url = "http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/HomelandSecurity/operations/FeatureServer/0", OutFields = new ESRI.ArcGIS.Client.Tasks.OutFields() { "*" } };
layer.Initialized += (s,e) =>
{
 layer.Update();
};
layer.UpdateCompleted += (s,e) =>
{
 var graphic = layer.Graphics.FirstOrDefault(g => (int)g.Attributes["objectid"] == 105635);
 graphic.Attributes["collection_time"] = null;
};
layer.Initialize();
If you are still experiencing issues please explain your use case with details about the data and application workflow so we can reproduce it here. Thanks.

I tried the easiest way to populate the field but still get a NullReferenceException error.

ESRI.ArcGIS.Client.FeatureLayer fl = theMap.Layers["flyr_RoadClosureLocations"] as ESRI.ArcGIS.Client.FeatureLayer;
            foreach (ESRI.ArcGIS.Client.Graphic g in fl.Graphics)
            {
                if (g.Attributes["UPID"].ToString() == "CAB_035")
                {
                    MessageBox.Show(g.Attributes["UPDATEDATE"].ToString());
                    g.Attributes["UPDATEDATE"] = null;
                }
            }

I uploaded three screenshots to show the settings of the feature class, the layer and the feature service. In the Silverlight App, I tried both 2.1 and 2.2 API but get the same error.
Environment:
ArcSDE 10 Sp1
ArcGIS Server 10 Sp1

FeatureClassLevel.png

MxdLevel.png

RestFeatureService.png

JenniferNery

g. Attributes["UPDATEDATE"] = null

Is g null? or is Attributes null? Check also that g.Attributes.ContainsKey("UPDATEDATE") maybe this returns null because field name does not match or FeatureLayer.OutFields does not include this field.

JingjingLi

I guess DateTime is Non-Nullable DataType so setting it to null won't work.
Try setting it to null as follows:
g.Attributes["UPDATEDATE"] = new DateTime?();

It throws a NullReferenceException error. I think it is the same as

g.Attributes["UPDATEDATE"] = null

JenniferNery

You are right, by default DateField has a default length of 36.

You can try the following feature service that has a nullable DateField. Setting the attribute value to null does not raise any exception. You can wire up to EndSaveEdits and SaveEditsFailed to see that this new value is actually saved.

FeatureLayer layer = new FeatureLayer() { Url = "http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/HomelandSecurity/operations/FeatureServer/0", OutFields = new ESRI.ArcGIS.Client.Tasks.OutFields() { "*" } };
layer.Initialized += (s,e) =>
{
 layer.Update();
};
layer.UpdateCompleted += (s,e) =>
{
 var graphic = layer.Graphics.FirstOrDefault(g => (int)g.Attributes["objectid"] == 105635);
 graphic.Attributes["collection_time"] = null;
};
layer.Initialize();

If you are still experiencing issues please explain your use case with details about the data and application workflow so we can reproduce it here. Thanks.

PreetiMaske

I guess DateTime is Non-Nullable DataType so setting it to null won't work.
Try setting it to null as follows:
g.Attributes["UPDATEDATE"] = new DateTime?();

JingjingLi

I think that since you gave a length requirement, a validation exception will be thrown if this is not met. If you made g.Attributes["UPDATEDATE"] = null.

If you remove this length requirement, I think you should be able to set it to a null value without validation exception.

How can you remove the length of a Date field? I think by default you can only setup the field type and nullable for a Date field.

JingjingLi

Graphic.Attributes["DateField"] = null should work.
Are you saying it doesn't? It not, what happens when you try that?

No it does not work. It throws a NullReferenceException.

foreach (ESRI.ArcGIS.Client.Graphic g in fl.Graphics)
                {
                    if ((int)g.Attributes["OBJECTID"] == objid)
                    {
                        IDictionary<string, object> att = g.Attributes;
                        if (att["UPDATETIME"] != null)
                        {
                            att["UPDATETIME"] = "";
                        }

                        if (att["UPDATEDATE"] != null)
                        {
                            //UpdateDate is a Date field
                            att["UPDATEDATE"] = null;
                        }

                        if (att["DESCRIPTION"] != null)
                        {
                            att["DESCRIPTION"] = "";
                        }
                        
                    }
                }

It's strange. For these records that have null value in the date field. I am able to get the null value from the Attributes property. Just not able to write a null value to it.

JenniferNery

I think that since you gave a length requirement, a validation exception will be thrown if this is not met. If you made g.Attributes["UPDATEDATE"] = null.

If you remove this length requirement, I think you should be able to set it to a null value without validation exception.

SomeGISGuy

Graphic.Attributes["DateField"] = null should work.
Are you saying it doesn't? It not, what happens when you try that?

JingjingLi

UPDATEDATE (Type: esriFieldTypeDate, Alias: UPDATEDATE, Length: 36, Editable: True)

And 'Allow Null values' on the field is set to true.
This is actually the default Date field setting. I don't think I can create a Date field with a specific length. Does this mean you cannot update the date value to null in silverlight?

JenniferNery

Can you share the service end point field information?

For example, when I visit this service end point from my web browser: http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/HomelandSecurity/operations/FeatureServer/0

collection_time (Type: esriFieldTypeDate, Alias: Collection Date, Length: 36, Editable: True)

This means there is a required length to the field.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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