Attribute rule isn't triggered when field is updated in a feature

PeterDouglas

Hello,

I have a 1:M relationship class that relates a residences wastewater load (gallons) to the basin they reside in.  I created a field (TGallons) in the basin feature (Basins_Pop_Employ_2021_22_TESTENV) with a calculation attribute rule to be populated with the total gallons of all residences in that basin.  As an attribute rule, the field (TGallons) will not populate when features are added to the relationship class, are modified/updated, or deleted from it.  If I use the same Arcade expression in field calculator, the field will populate with the total number of gallons for the related customers.  Why would the attribute rule not trigger?  The arcade expression I used is shown below.

 

var related = FeatureSetByRelationshipName($feature, "Basins_Pop_Employ_2021_22_TESTENV_CAF_Addresses_TESTENV")

return sum(related, "gallons")

 

 

Any help would be appreciated.

Thanks!

JohannesLindner

You created the rule on the basin fc. This rule will only be executed if you change a basin feature. It will do nothing when you change the related table.

To do what you want, you have to create an Attribute Rule on the related table that changes the basin fc. You can do that by returning a dictionary instead of a single value. Documentation of that dictionary can be found here: Attribute rule dictionary keywords—ArcGIS Pro | Documentation

 

Something like this should work (untested!). Edit lines 7&8 to use the actual field you use for the relationship instead of BasinID!

// Calculation Attribute Rule on the customer table
// field: leave empty
// triggers: insert, update, delete
// exclude from application evaluation

// get all features belonging to the same basin
var basin_id = $feature.BasinID
var query = "BasinID = @basin_id"
if($editcontext.editType == "DELETE") {
    // exclude this feature if we're deleting it
    var oid = $feature.OBJECTID
    query += " AND OBJECTID <> @oid"
}
var wastewater_loads = Filter($featureset, query)

// get the total
var total_gallons = Sum(wastewater_loads, "gallons")

// get the related basin
var basin = First(FeaturesetByRelationshipName("Basins_Pop_Employ_2021_22_TESTENV")
if(basin == null) { return }

// return the dictionary to edit the basin fc
return {
    edit: [{
        className: "Basins_Pop_Employ_2021_22_TESTENV",
        updates: [{
            objectID: basin.OBJECTID,
            attributes: {TGallons: total_gallons}
        }]
    }]
}