Attribute Rule Logic to Check for Unique Value in Table

Boomer1187

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
              }]
}

 

Boomer1187

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.