Attribute Rule Logic to Check for Unique Value in Table
Hi everyone,
I have an attribute rule applied to fire whenever there is a new project from Project A that intersects with a project from Project B. This is applied with the 'update' trigger only, and not upon 'insert' and 'update' as it would generate a duplicate record, one for when the polygon was created, and another when attributes were created in the latter circumstance.
Here is a screenshot of the relationship table that I am updating via attribute rules.
In the screenshot above, RID 129 was created first when I created the Projects A polygon and populated a few attributes which is what I want.
RID 130 was created in the table after, when I updated a project_name in the same Projects A polygon.
Is there any logic I could incorporate into my attribute rule arcade script that would check for values in the relationship table and just update the existing record upon update, and not generate a whole new record/row in the relationship table every time a polygon is updated? The relationship table only has those few attributes that I have shown in the screenshot.
var fs = FeatureSetByName($datastore, "Project_B");
var fsInt = intersects(fs, $feature);
var payload = [];
var c = 0;
for (var proj in fsInt)
{
payload[c++] = {"attributes": { "PROJECT_NAME": $feature.project_name, "PROJA_NUM": $feature.proja_num, "PROJB_NUM": $feature.projb_num} }
}
return {
"edit": [{"className": "Relationship_Class",
"adds": payload
}]
}
Edit, I've edited the above to only add in the PROJB_PROJECT_NUM into the Relationship Class table any time a new polygon is created in Projects_B which is great.
However, I would still like to know if there is any logic that can be worked into the script to 'call' the intersecting underlying PROJECT_NAME from Projects_A and most importantly, PROJA_PROJECT_NUM from Projects_A and insert it into the Relationship Class table. I would need to ensure that these values are added to the relationship class table to maintain its integrity.
This is due to the fact that the Relationship_Class table has the PROJECT_NAME from Projects_A, the PROJA_PROJECT_NUM from Projects_A and the PROJB_PROJECT_NUM from Projects_B. So any time a new polygon is created in either Projects_A or Projects_B, I would need the relationship class table to be udpated with all of those values only in circumstances where the polygons intersect.
ATTRIBUTE RULE APPLIED TO PROJECTS_B.
var fs = FeatureSetByName($datastore, "Projects_A");
var relatedRecFs = FeatureSetByName($datastore, "Relationship_Class");
var fsInt = intersects(fs, $feature);
var payloadInsert = [];
var payloadUpdate = [];
var c = 0;
var getPrpjNum = $feature.projb_project_num;
// Filter the Relationship_Class table to get the related records that match the Project Num of the new feature
var relatedRecords = Filter(relatedRecFs, "PROJB_PROJECT_NUM = @getPrpjNum"); //
if ($editcontext.editType == "INSERT"){
for (var proj in fsInt) {
payloadInsert[c++] = {
"attributes": {
"PROJB_PROJECT_NUM": $feature.PROJB_PROJECT_NUM
}
};
}
return {
"edit": [{
"className": "Relationship_Class",
"adds": payloadInsert
}]
};
}
if ($editcontext.editType == "UPDATE"){
for (var rec in relatedRecords) {
var recGlobalID = rec.GLOBALID;
payloadUpdate[c++] = {
"GlobalID": recGlobalID, // this is the GlobalID of the related record
"attributes": {
"PROJB_PROJECT_NUM": $feature.PROJB_PROJECT_NUM
}
};
}
return {
"edit": [{
"className": "Relationship_Class",
"updates": payloadUpdate
}]
};
}
This is the relationship class table, where I want to pull in or 'call' the PROJA_PROJECT_NUM and PROJECT_NAME from Projects_A in the above script, without getting the 'Dictionary Type expected' error when creating a polygon.
