Using Inspector to modify attribute field in multiple features

Zoltan_Szecsei

Hi,

I am struggling to get this snippet to work:

https://github.com/esri/arcgis-pro-sdk/wiki/ProSnippets-Editing#edit-operation-modify-multiple-features
// at Heading: Edit Operation Modify multiple features

 

Problem #1 is:

My code below works, loads 421 OIDs but does not execute because modifyFeatures.IsEmpty is TRUE.

The existing date attribute is shown as day-month-year when I look at the attribute table in ArcPro 3.0.2

Problem #2 is:

I am currently selecting on OID to debug this code, but I need to select features with a specific DATE_LASD.

The following WhereClause fails with 'An invalid SQL statement was used.'

(I have tried '-' instead of '/' and also MM-DD-YYYY)

//selq.WhereClause = "DATE_LASD = '20/04/2022'"; // This format is what is shown in Attribute Table

Can anyone spot my deliberate error? 

Thank in advance,

Zoltan

        public static void setDateLASD()
        {
            //from:  https://github.com/esri/arcgis-pro-sdk/wiki/ProSnippets-Editing#edit-operation-modify-multiple-features
            // at Heading:  Edit Operation Modify multiple features
            // First deactivate OnRowChanged
            var selq = new QueryFilter();
            //selq.WhereClause = "DATE_LASD = '20/04/2022'";  // This is s what is shown in Attribute Table
            selq.WhereClause = "OBJECTID > 7";
            IEnumerable<FeatureLayer> layers = MapView.Active.Map.GetLayersAsFlattenedList().Where(
                layer => layer is FeatureLayer).Select(x => (FeatureLayer)x);
            foreach (var dset in layers)
            {
                if ((dset.Name.EndsWith("_Point")) ||
                    (dset.Name.EndsWith("_Line")) ||
                    (dset.Name.EndsWith("_Polygon")))
                {
                    QueuedTask.Run(() =>
                    {
                        var oidSet = new List<long>();
                        using (var selset = dset.Search(selq))
                        {
                            while (selset.MoveNext())
                            {
                                using (var record = selset.Current)
                                {
                                    oidSet.Add(record.GetObjectID());
                                }
                            }
                        }
                        //create and execute the edit operation
                        var modifyFeatures = new EditOperation();
                        modifyFeatures.Name = "Modify LASD";
                        modifyFeatures.ShowProgressor = true;
                        var multipleFeaturesInsp = new Inspector();
                        multipleFeaturesInsp.AllowEditing = true;
                        multipleFeaturesInsp.Load(dset, oidSet);
                        multipleFeaturesInsp["DATE_LASD"] = "21/08/2022";
                        modifyFeatures.Modify(multipleFeaturesInsp);
                        if (!modifyFeatures.IsEmpty)
                        {
                            var result = modifyFeatures.ExecuteAsync(); //Execute and ExecuteAsync will return true if the operation was successful and false if not
                        }
                    });
                }
            }
                // Now reactivate OnRowChanged
        }

 

GKmieliauskas

Hi,

Problem 1:

I have reported case to esri support about that in November 2022. Case number #03196489 

Just ignore IsEmpty value for now, or use your workaround to count for changes.

Problem 2:

Date is not simple string value. Let's try like this:

 

selq.WhereClause = "DATE_LASD = date '2022-04-20 00:00:00'";

 

More info here:

SQL reference for query expressions used in ArcGIS—ArcGIS Pro | Documentation