Attribute Rule Write Related Child Attribute to Parent Table

marksm_macomb

Hi there,

I have a 1:M relationship between Manholes (parent) and Inspections (child). I'd like for when a new inspection is submitted, that the condition values of the most recent inspection write to the Manhole. For example, I have a field called "Cover_Condition" in the inspection table, and a field called "Cover_Condition" in the Manhole and here is the Arcade I have so far (This rule is assigned to the Cover_Condition field and triggered on insert, update, and delete, and it is excluded from application evaluation):

 

//Forgein Key in child table
var fk = $feature.ParentGUID_

//Load all inspections of the feature
var inspections = FeatureSetByName($datastore, "DBO.SanitaryManholeInspections",['ParentGUID_', 'Date_Time', 'Cover_Condition'], false)
var related_inspections = Filter(inspections, 'ParentGUID_ = ')

//Filter out record if delete trigger
if($editcontext.editType == "DELETE") {
    var pk = $feature.GlobalID_1
    related_inspections = Filter(related_inspections, "GlobalID_1 <> ")
}

//Filter most recent inspection date
var last_inspection = First(OrderBy(related_inspections, "Date_Time DESC"))

//Return nothing if no records found
if(IsEmpty(last_inspection)){
return ;
}

//Update Cover_Condition field in parent feature class
return {
    "result": fk,
         "edit": [{
            "className" : "DBO.ssManhole_z",
               "updates": [{
                 //selecting the parent feature to update
                 "GlobalID" : last_inspection.ParentGUID_,
                 //Update the Cover_Condition field in parent feature class 
                 "attributes" : {'Cover_Condition': last_inspection.Cover_Condition
    }
                           }]
                  }]    
    };

 

 

The expression evaluates as valid in the expression editor, but when I test in Field Maps, I get the error "Unable to complete operation. Unable to perform applyEdits operation. Error: Invalid column value [Invalid column value] [Cover_Condition]."

I did check the spelling and the field names in both the Manholes and Inspection Table are spelled that way.

I also get confused when writing expressions like this which field I should assign the rule to, or can it be left blank?

 

Thank you!!

JohannesLindner

You assigned this rule to Inspections.Cover_Condition, but you return a GlobalID. My guess is that Cover_Condition has a coded value domain, so it rejects anything not in that domain. Maybe it even is an integer field, so it also can't properly convert the GlobalID (a string) into an integer.

 

I also get confused when writing expressions like this which field I should assign the rule to, or can it be left blank?

You can leave the field blank, in that case don't use the "result" keyword. You could also assign your expression as it is to ParentGUID_, because that's the value you return right now.

 

 

I'm surprised you don't get errors on lines 6 and 11,  because you're missing the compare values in the SQL query.

 

Instead of loading the Featureset in line 5, you can just use the $featureset global. $featureset returns the current Featureset, the one this Attribute Rule is assigned to.

 

//Forgein Key in child table
var fk = $feature.ParentGUID_

//Load all inspections of the feature
var related_inspections = Filter($featureset, 'ParentGUID_ = <a href="https://community.esri.com/t5/user/viewprofilepage/user-id/225383">@fk</a>')

//Filter out record if delete trigger
if($editcontext.editType == "DELETE") {
    var pk = $feature.GlobalID_1
    related_inspections = Filter(related_inspections, "GlobalID_1 <> <a href="https://community.esri.com/t5/user/viewprofilepage/user-id/625823">@pk</a>")
}

//Filter most recent inspection date
var last_inspection = First(OrderBy(related_inspections, "Date_Time DESC"))

//Return nothing if no records found
if(IsEmpty(last_inspection)){
    return
}

//Update Cover_Condition field in parent feature class
return {
    "edit": [{
        "className" : "DBO.ssManhole_z",
        "updates": [{
            //selecting the parent feature to update
            "globalID" : last_inspection.ParentGUID_,
            //Update the Cover_Condition field in parent feature class 
            "attributes" : {
                'Cover_Condition': last_inspection.Cover_Condition,
//                "Other_Attribute": last_inspection.Other_Attribute,
            }
        }]
    }]
}