Attribute Rule Calculation

1
2
3
4
5
6
7
8
9
10
11
12
13
//Define the leading text, the trailing text and the delimiter for the ID
prefix = "ABC"
join_char = "-"
suffix = "XYZ"

//Ensure the ID is not already set, if it is, return the original id
if (IsEmpty($feature.assetid)) {
   // If you do not want to use a prefix, or suffix, remove it from the list
   return Concatenate([prefix, NextSequenceValue("GDB_SEQUENCE_NAME"), suffix], join_char)
}
else {
   return $feature.assetid
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
if ($feature.common_name == $originalFeature.common_name) {
   return;
}

if ($editcontext.editTag == "attribute rule") {
   return;
}

var groupName = $feature.group_name;
var globalId = $feature.GlobalID;
var commonName = $feature.common_name;
var relatedRows = Filter($featureSet, "group_name = @groupName and globalid <> @globalId and (common_name <> @commonName or common_name is null)");
var updates = [];

for (var row in relatedRows) {
   Push(updates, {
      "globalId": row.globalid,
      "attributes": {
         "common_name": commonName
      }
   });
}

return {
   "edit": [{
      "className": "main.mytable",
      "updates": updates,
      "editTag": "attribute rule"
   }]
};