Hi @MikeMillerGIS ,
Here are my current attribute rules for now 🙂
First one is an attribute rule applied on Projects_A, that updates the project_number for any intersecting polygons from Projects_B that intersect with a new or updated project from Projects_A. This is triggered on Insert and Update with the exclude from application evaluation checked on.
var projB = Intersects(FeatureSetByName($datastore, 'Projects_B', ['project_number']), $feature)
var proj_nums = []
for (var projB_row in projB) {
Push(proj_nums, projB_row.project_number)
}
return Concatenate(proj_nums, "; ")
The second one is an attribute rule applied on Projects_B, that updates the project number field in the Projects_A feature class from any new polygons from Projects_B that intersects with the underlying Projects_A polygons. This is triggered on Insert and Update with the exclude from application evaluation checked on.
var ProjA = FeatureSetByName($datastore, "Projects_A", ["GlobalID"], true)
var IntProj = Intersects(ProjA, $feature)
var updates = []
var i = 0
for (var proj in IntProj){
updates[i++] = {'GlobalID': proj.GlobalID,
'attributes': {'project_number': $feature.project_number}
}
}
return {
'result': $feature.project_number,
'edit': [{
'className': 'Projects_A',
'updates': updates
}]
}
This is the attribute rule in question applied to Projects_B, where whenever a project/polygon is deleted from Projects_B, that it triggers to delete the project_number value only, from the intersecting Projects_A polygon. The Projects_A polygon's project_number may have a single project_number or multiple separated with a ; depending on how many it intersects with. It is applied on Update and Delete with the exclude from application evaluation box checked on:
var ProjA = FeatureSetByName($datastore, "Projects_A", ["GlobalID"], true)
var IntProj = Intersects(ProjA, $feature)
var updates = []
var proj_num = iif($editcontext.editType == "DELETE",null,$feature.project_number)
for (var proj in IntProj) {
psuh(updates, {
'GlobalID': proj.GlobalID,
'attributes': {'project_number':proj_num}
})
}
return {
'result': $feature.project_number,
'edit': [{
'className': 'Projects_A',
'updates': updates
}]
}
