topic Re: Attribute rules on update field: "The field type is not supported by arcade script." in Attribute Rules Questions

Attribute rules on update field: "The field type is not supported by arcade script."

DrNicsi — Thu, 14 Nov 2024 14:13:01 GMT

I am trying to apply an attribute rule that would update the parent table of two related tables when the child table is edited. In this case I only want to write the number of related records into the parent table but I am getting this error:

Initiall the field I am trying to write to was of the type short, now I created fields in long, float and double format but none of them are accepted. How can I find out which field type would be supported for my script?

Re: Attribute rules on update field: "The field type is not supported by arcade script."

KenBuja — Thu, 14 Nov 2024 16:49:14 GMT

Can you post your script? It would be helpful to see what it's returning

Re: Attribute rules on update field: "The field type is not supported by arcade script."

DrNicsi — Thu, 14 Nov 2024 17:58:03 GMT

Here it is, with bpmis_data being the child table and bpmis_distinct the parent table:

var select="upi='"+$feature["upi"] +"'"; var fs = FeatureSetbyName($datastore, "bpmis.sde.bpmis_data") var upi_filtered=Filter(fs,select); var cnt=Count(upi_filtered) if (cnt>0){ return { "result": cnt, "edit": [ { "className":"bpmis.sde.bpmis_distinct", "updates":[ { "upi": $feature["upi"], "attributes": { "permits_cnt": cnt } } ] } ] } }

When I try it in the popup I get the expected result ("permits_cnt":14 (number obviously depending on the feature)), but I have to admit that I did not understand yet what the "result" is supposed to do, maybe that's my problem.

Thanks for looking into it!

Re: Attribute rules on update field: "The field type is not supported by arcade script."

KenBuja — Thu, 14 Nov 2024 20:41:52 GMT

I'm not an expert on attribute rules, but from the documentation, it looks like you're missing the required object ID or global ID parameter in the updates object

Re: Attribute rules on update field: "The field type is not supported by arcade script."

DrNicsi — Thu, 14 Nov 2024 20:44:22 GMT

Update:

I am getting closer... At least I don't get an error message any longer but the number is always +1 to what it should be.

Re: Attribute rules on update field: "The field type is not supported by arcade script."

DrNicsi — Sat, 16 Nov 2024 17:20:02 GMT

Only returning cnt in the popup still gives the correct value. No idea why it would return value+1 when updating the parent table 😞