topic Re: Arcade - FeatureSetByRelationshipName in Attribute Rules Questions

Arcade - FeatureSetByRelationshipName

Anonymous User — Tue, 16 Aug 2022 00:01:58 GMT

Hello, I am trying to populate a field (Site_ID) in a related table using the arcade function FeatureSetByRelationshipName. The related feature that I am trying to pull from is called MTH_Campgrounds.

In Field Maps I want to select a point (campground in this example case) and select the related table icon and enter data into the form I created for the table. Hopefully, this code will reduce the potential for error while inputting data into the table's form. The feature and table are related using Global IDs. The field in the table will be null at first.. so I am assuming there is an if then--first kind of arcade statement. This is where I currently am...

var related = FeatureSetByRelationshipName($feature,'MTH_Campgrounds', ["SITE_ID"], false)

return related

Thanks in advance!

Re: Arcade - FeatureSetByRelationshipName

MikeMillerGIS — Mon, 15 Aug 2022 22:58:08 GMT

The result is a featureset, so you can loop over it or call first on it, such as :

var related = FeatureSetByRelationshipName($feature,'MTH_Campgrounds', ["SITE_ID"], false)

return First(related)['SITE_ID']

Re: Arcade - FeatureSetByRelationshipName

Anonymous User — Mon, 15 Aug 2022 23:30:43 GMT

Thank you for the response! When I use that code I get this error response

Execution Error:Cannot read properties of null (reading 'toString')

Re: Arcade - FeatureSetByRelationshipName

MikeMillerGIS — Mon, 15 Aug 2022 23:37:25 GMT

Might need to add some error handling.

var related = FeatureSetByRelationshipName($feature,'MTH_Campgrounds', ["SITE_ID"], false)

var record = First(related)

if (IsEmpty(record)){

return "No Record Found"

}

return record['SITE_ID']

Re: Arcade - FeatureSetByRelationshipName

Anonymous User — Tue, 16 Aug 2022 21:49:06 GMT

So I learned that the FeatureSetByRelationshipName references the relationship class which I titled Evaluations. So I enter that and the test runs! But when I open the field maps mobile application it says calculation failed. Any ideas?

var related = FeatureSetByRelationshipName($feature, "Evaluations", ['SITE_ID'], false)

var record = First(related)

if (IsEmpty(record)){

return "No Record Found"

}
return record['SITE_ID']

Thanks in advance!!!!

Re: Arcade - FeatureSetByRelationshipName

MikeMillerGIS — Wed, 17 Aug 2022 10:13:12 GMT

What type of field is SITE_ID, if it is numeric, that makes sense:

var related = FeatureSetByRelationshipName($feature, "Evaluations", ['SITE_ID'], false)

var record = First(related)

if (IsEmpty(record)){

return <ADD THE ASSIGNED TO FIELD HERE, SUCH AS $feature.THEFIELDTHISISASSIGNEDTO>

}
return record['SITE_ID']

Re: Arcade - FeatureSetByRelationshipName

Anonymous User — Wed, 17 Aug 2022 15:27:01 GMT

Got the code to work, someone suggesting I don't use the FeatureSetByRelationshipName because it has some bugs, so I tried this and it works! Thanks for all your help @MikeMillerGIS. I was curious though what if the field site ID wasn't numeric, what if it was text would you change anything?

Here is the functioning code:

var related = FeatureSetByName($datastore,"MTH_Campgrounds", ['SITE_ID'], false)

var record = First(related)

if (IsEmpty(record)){

return $feature.TestID
}
return record['SITE_ID']

Re: Arcade - FeatureSetByRelationshipName

MikeMillerGIS — Wed, 17 Aug 2022 21:04:43 GMT

That code is incorrect. That will always return the first record in that table. You need to use filter and build a sql clause to get the record that matches $feature

Re: Arcade - FeatureSetByRelationshipName

MikeMillerGIS — Wed, 17 Aug 2022 21:06:46 GMT

Here is an example that might help. https://github.com/Esri/arcade-expressions/blob/master/attribute_rule_calculation/MoveFieldToParent.js

Re: Arcade - FeatureSetByRelationshipName

JohnWatson_EBA — Wed, 28 Dec 2022 16:30:55 GMT

@MikeMillerGIS I added an attribute rule (Pro 2.9.5) to populate a field in the FC based on the value entered in the same field in the related table, on insert. Odd thing is when I test it and add a new related record to the FC, the field in the related record gets auto populated with the globalID, so I am not sure what that's about. And if I just manually edit that field to test the actual rule, the field does not populate in the feature class after the related record is added and saved.

// This rule will update an attribute in the parent feature // Store the parent feature global from the key field in the relationship var parent_id = $feature.GlobalID; if (IsEmpty(parent_id)) return parent_id; // force to upper as the sql is case sensitive parent_id = Upper(parent_id); // Using the GDB name, get the parent classes records and Global ID field var parent_class = FeatureSetByName($datastore, "Utilities_Model.GISADMIN.ssManhole", ["globalid", 'Lid_Condition'], false); // Filter the parent class for only related features var parent_records = Filter(parent_class, "globalid = @parent_id"); var updates = []; var i = 0; var new_value = 'Lid_Condition'; if (IsEmpty($feature.Lid_Condition) == False) { new_value = $feature.Lid_Condition } // Loop through each feature, create a dict of the Global ID and the new value date for (var row in parent_records) { // If the parent row is null or has a different value, updated it if (IsEmpty(row['Lid_Condition']) || row['Lid_Condition'] != new_value) { updates[i++] = { 'globalid': parent_id, 'attributes': {"Lid_Condition": new_value} }; } } // Return the original value in the result parameter, as to not lost the entered value // Using the edit parameter, return the class and list of updates return { 'result': parent_id, 'edit': [ {'className': 'Utilities_Model.GISADMIN.ssManhole', 'updates': updates } ] };

Re: Arcade - FeatureSetByRelationshipName

MikeMillerGIS — Fri, 30 Dec 2022 11:06:59 GMT

There is an order of operations issue here. When the related record is created, I do not believe the Parent Global ID is applied to the child. This may occur on an update. So you could check on Update and monitor if that field has changed and then if the ParentGUID field has changed, then fire your rule.

Also, this code is the features GlobalID, not the Parent, you need to get $feature.ParentID field

var parent_id = $feature.GlobalID;