Attribute Rule Enterprise 11.2 failing

Question

Hello, I trying to add an attribute rule to a branch versioned layer in enterprise 11.2.

The rule I'm trying to add will automatically add a new asset ID (alphanumeric) in a sequential matter when a new asset is added.

I keep getting a variety of errors and have worked through them but I am currently stuck with the error "Error on line 11, Table not found $featureAsset_Id.

I can not figured out why it doesn't see the table (the variable layer name is coming from the table). I am new to coding and have it working in python, but ESRI only has arcade as the option to use in the attribute rule window. My code is below.

Also dose anybody know if the attribute rule window in 11.4 will allow python as an option, Currently in 11.2 Arcade is the only option I'm seeing and it appears it cannot do what I want.

Error in Code for Alphanumeric Sequencial lableing as an Attribute rule.txt

Attribute Rule Window.jpg

名称未設定-2.png

AnhDang_5-1740097927409.png

WardMitchell1 · Answer

Our IT developer helped out and we have it working in arcade now and field maps. Here's the code.

var layerName = $feature['Asset_ID'];
var maxID = Max(Number(Mid($feature.Asset_ID, 2)));

var query = OrderBy(FeatureSetByName($datastore, 'SDE.signs', ['Asset_ID'], false),"Asset_ID DESC");
for (var feature in query) {
var currentID = DefaultValue(feature['Asset_ID'], "S-00000");

// Ensure currentID is a valid string and has the correct format
if (!IsEmpty(currentID) && TypeOf(currentID) == "String" && Count(currentID) > 2 && Left(currentID, 2) == "S-") {
var numPartStr = Mid(currentID, 2); // Extract numeric part safely
var numPart = Number(numPartStr);

// Ensure numPart is a valid number
if (!IsNan(numPart)) {
maxID = numPart;
break; // Only need the first (largest) value
}
}
}

// Generate the new sequential ID
//var newID = "S-" + Text(maxID+1, maxID); // Ensures format like "S-00001", "S-00002", etc.
var newID = maxID + 1;
var paddedID = Text(newID, "00000");
//var newID = "S-" + zero + (Number(maxID)+Number(1));

return "S-" + paddedID;

RPGIS · Answer

I tried doing the same things you did and was told repeatedly that you cannot despite that it is common in other programming languages. I am also a heavy python user and so it sometimes gets me when somethings work in python that don't necessarily translate well in arcade.

WardMitchell1 · Answer

Thanks @RPGIS , for the info. We made a little more progress. I wasn't aware of the general rule of thumb regarding alphanumeric IDs, we are linked to our asset information management system which is full of alphanumeric IDs so hopefully it doesn't have issues down the road and we haven't any issues as of yet.