topic Re: Attribute rule for Inserting record to table in Attribute Rules Questions

Attribute rule for Inserting record to table

GIServicesUser — Sun, 05 Mar 2023 20:17:01 GMT

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

Re: Attribute rule for Inserting record to table

JohannesLindner — Mon, 06 Mar 2023 06:49:48 GMT

You could use the Filter() function.

var table_b = FeaturesetByName($datastore, "TableB") var gid = $feature.GLobalID var related_b_row = First(Filter("gid_fk = @gid")) // use the actual field name! var v = IIf(related_b_row == null, null, related_b_row.V) return { "edit": [{ "className": "table C", "adds": [{ 'attributes': { "gid_fk":$feature.globalid, "v": v } }] }] }

Re: Attribute rule for Inserting record to table

GIServicesUser — Mon, 06 Mar 2023 11:57:07 GMT

Thanks Johannes, I tried this and works perfectly, however, another issue came up...as always, the function Filter if I am not mistaken is incompatible with my ArcGIS Server Installation 10.8.1 according to this and I get an error while trying to publish the feature (table A) with the attribute rule...

Re: Attribute rule for Inserting record to table

JohannesLindner — Mon, 06 Mar 2023 12:39:49 GMT

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 } }] }] }

Re: Attribute rule for Inserting record to table

GIServicesUser — Mon, 06 Mar 2023 18:42:59 GMT

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...

Re: Attribute rule for Inserting record to table

JohannesLindner — Mon, 06 Mar 2023 19:20:19 GMT

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.