Deleting a feature using arcade - help with code

TorbjørnDalløkken2

Hi.

I'm struggeling with an attribute rule (Calculation) in ArcGIS Pro. I have a two featureclasses in a filegeodatabase (Vegteig - polygon, Tilknytningspunkt - point). The polygonclass has an ID (Teig_ID) which is used as a foreign key in the point class. When I delete a polygon, I want the corresponding point to be deleted as well. I've created an attribute rule on the polygonclass which triggers on delete and have turned on "exclude from application evaluation".

// henter teig_id fra tilknytningspunkt som slettes
var teig_id = $feature.Teig_ID

var fs_tilknytningspunkter = FeatureSetByName($datastore, "Tilknytningspunkter", ["GlobalID", "TEIG_ID"])

var tilknytningspunkt = First(Filter(fs_tilknytningspunkter, "TEIG_ID=@teig_id"))
Console(tilknytningspunkt)
var deleteList = []

if(tilknytningspunkt == null){
    return
}
else{
    var delete = {'globalId': tilknytningspunkt.GlobalID}
    Push(deleteList, delete)
}
Console(deleteList)

return
{
    'edit': [{
        'className': 'Tilknytningspunkter',
        'deletes': deleteList
    }]
}

This code seems to be working fine, as it's verified ok and I can see that point is being selected in the output to console. The problem is that the delete it self is not executed. The polygon is deleted, but the poit still remains. 

Can anyone see what's wrong?

VinceE

The below works for me when I recreate your situation above, assuming you only want to delete the first point found with a matching ID to the polygon, and not any subsequent ones.

Other than some line formatting, I think the only difference between mine and yours is that I am explicitly creating the var "delete" dictionary using the "Dictionary()" constructor on line 14. I have had a similar problem when loading things into these return keyword dictionaries as you are doing, no idea why, but this has fixed my issue. At this point I pretty much always try to use the explicit constructor when I am able to.

// henter teig_id fra tilknytningspunkt som slettes
var teig_id = $feature.Teig_ID

var fs_tilknytningspunkter = FeatureSetByName($datastore, "Tilknytningspunkter", ["GlobalID", "TEIG_ID"])

var tilknytningspunkt = First(Filter(fs_tilknytningspunkter, "TEIG_ID=@teig_id"))
Console(tilknytningspunkt)
var deleteList = []

if (tilknytningspunkt == null) {
    return
} else {
    // ***ONLY DIFFERENCE?***
    var delete = Dictionary('globalID', tilknytningspunkt.GlobalID)
    Push(deleteList, delete)
}
Console(deleteList)

return {
    'edit': [{
        'className': 'Tilknytningspunkter',
        'deletes': deleteList
    }]
}