Attribute rule for Inserting record to table

Question

I am wondering if I could create an update attribute rule to a table A  that copies a value (V) from a field in a table B (by using the $feature.globalid to find the record in table B)  and inserting a new record into a table C to paste the V. So far, I managed to transfer the V from the $feature in table A to a new record in table C.

code:

return {
"edit": [{
    "className": "table C",
    "adds": [{ 
       'attributes': 
       {
         "gid_fk":$feature.globalid
        }
    }]
}]
}

Thanks in advance

JohannesLindner · Answer

I think table b has to be included for the $datastore to work. You don't need to consume the published table b in your map/application, but it should be in the service.

GIServicesUser · Answer

Hi Johannes,

I used the loop method to write the script and even though the rule works fine on desktop, when trying to publish the table with the attribute rule I get the same error as before

ERROR 001487: Failed to update the published service with the server-side data location

If I remove the attribute rule from the table A, the publishing of the table completes successfully.

I am not sure If the fact that the table B is a table view in the database and it is not included in the publishing service because the service has feature capability, has something to do with this error...

JohannesLindner · Answer

Hmm, according to the version matrix, ArcGIS Server 10.8.1 should include Arcade 1.10 at least. Filter() was released in 1.5. What error do you get?

Anyway, you could try FeaturesetByRelationshipName(), but that was released in Arcade 1.8, so it will probably be the same.

You could also do it with a for loop. It will be slower than Filter(), especially if table B has many entries, but it should get the job done:

var table_b = FeaturesetByName($datastore, "TableB")
var gid = $feature.GLobalID
var v = null
for(var b in table_b) {
    if(b.gid_fk == gid) {
        v = b.v
        break
    }
}

return {
"edit": [{
    "className": "table C",
    "adds": [{ 
       'attributes': 
       {
         "gid_fk":$feature.globalid,
         "v": v
        }
    }]
}]
}