Update a parent feature in a relationship when a new child record is inserted

Yi-ChinFang — Mon, 14 Feb 2022 19:39:21 GMT

Hi all,

I tried to following this post to update last survey date of a parent feature in a relationship when a new child record is inserted using "Add Attribute Rule geoprocessing tool" in ArcGIS Pro.

Below is the Arcade expression I put in attribute rule. It cannot recognize 'survey_date' field in child record. I cannot figure out how to fix it. Any suggestions on how to fix this are much appreciated!

________________________________________________________________________________________________

// This rule will update an attribute in the parent feature

// Store the parent feature global from the key field in the relationship
var parent_id = $feature.GlobalID;
if (IsEmpty(parent_id))
return parent_id;

// force to upper as the sql is case sensitive
parent_id = Upper(parent_id);

// Using the GDB name, get the parent classes records and Global ID field
var parent_class = FeatureSetByName($datastore, "gsob_trees", ["GlobalID", 'date'], false);
// Filter the parent class for only related features
var parent_records = Filter(parent_class, "GlobalID = @parent_id");

var updates = [];
var i = 0;

// Loop through each feature, create a dict of the Global ID and the new date
for (var row in parent_records)
// updated Date from child record
{
updates[i++] = {
'Global ID': parent_id,
'attributes': {"date": $feature.survey_date}
};
}

// Return the original value in the result parameter, as to not lost the entered value
// Using the edit parameter, return the class and list of updates
return {
'result': parent_id,
'edit': [
{'className': 'ParentLayer',
'updates': updates
}
]
};

topic Update a parent feature in a relationship when a new child record is inserted in ArcGIS Online Questions

Update a parent feature in a relationship when a new child record is inserted