topic Re: Add Attribute Rule, Help With Arcade Expression (Pass value from Parent to Child, Calculation) in ArcGIS Pro Questions

Add Attribute Rule, Help With Arcade Expression (Pass value from Parent to Child, Calculation)

TylerT — Fri, 15 Mar 2024 15:52:59 GMT

I am adapting an arcade expression attribute rule by @JohannesLindner (https://community.esri.com/t5/arcgis-pro-questions/attribute-rule-to-pass-a-value-from-parent-to/m-p/1124219#M48859) where I have a relationship class. Arcade isn't a particular strength and could use an assist debugging. Here is this script and the error.

I need to pass a field value (project_pw) from parent to child when children are created.

Any tips would be greatly appreciated.

Tyler

ArcGIS Pro3.2.0

// by JohannesLindner, <edited> var parent_fs = FeatureSetByRelationshipName($feature, "t12_projects_rc") // return nothing if no parent feature was found var parent = First(parent_fs) if(parent == null) { return } return parent.project_pw

<error>
Invalid expression.
Error on line 4.
Expected array or feature set

Re: Add Attribute Rule, Help With Arcade Expression (Pass value from Parent to Child, Calculation)

ZachBodenner — Fri, 15 Mar 2024 16:07:49 GMT

Have you tried removing the First function? I'm wondering if the FeatureSetByRelationshipName is already grabbing only the one parent feature, and thus first would be throwing an error because it's looking for an array (ie multiple things)?

Re: Add Attribute Rule, Help With Arcade Expression (Pass value from Parent to Child, Calculation)

TylerT — Fri, 15 Mar 2024 16:49:17 GMT

@ZachBodenner; That cleared the invalid expression. I now have a valid expression. Thank you. Maybe the First() is for a many to many?

New problem. The tool runs but fails with this error.

Any ideas about this error?

<snip>

ERROR 002764: ERROR: code:500, JSONObject["extent"] not found., Internal server error.

Failed to execute (AddAttributeRule).

Failed at Friday, 15 March, 2024 12:05:55 (Elapsed Time: 2.81 seconds)

https://pro.arcgis.com/en/pro-app/3.1/tool-reference/tool-errors-and-warnings/001001-010000/tool-errors-and-warnings-02751-02775-002764.htm

Re: Add Attribute Rule, Help With Arcade Expression (Pass value from Parent to Child, Calculation)

ZachBodenner — Fri, 15 Mar 2024 16:58:12 GMT

To me this looks like it's related to the actual data you're dealing with. Can you talk a little about the databases your data is coming from? What kind of files are they (feature class and geodatabse table?)

Re: Add Attribute Rule, Help With Arcade Expression (Pass value from Parent to Child, Calculation)

TylerT — Fri, 15 Mar 2024 17:07:43 GMT

The Parent is a hosted Feature Service Feature Class (polygon) on ArcGIS Enterprise Portal. The Child is a hosted Feature Service Table. They are related by a 1:M feature class.

The field I want to pass from Parent to Child is a text field (basically project number). Some Parent fields are null. The desire triggers are insert and update.

Re: Add Attribute Rule, Help With Arcade Expression (Pass value from Parent to Child, Calculation)

ZachBodenner — Fri, 15 Mar 2024 18:04:32 GMT

Ah, that might be the issue. Based on previous entries on the community, Hosted services cannot have attribute rules applied:

https://community.esri.com/t5/attribute-rules-questions/can-attribute-rules-be-used-on-feature-service/td-p/1265867#:~:text=Attribute%20rules%20are%20not%20supported,to%20use%20an%20enterprise%20GDB.

Though I would also suggest marking the removal of the First function as a solution since it solved the Arcade error you were getting.

Re: Add Attribute Rule, Help With Arcade Expression (Pass value from Parent to Child, Calculation)

TylerT — Tue, 19 Mar 2024 14:18:00 GMT

@ZachBodenner , It seems you are correct that attribute rules are not supported in hosted feature classes. Interesting. Thank you.

Re: Add Attribute Rule, Help With Arcade Expression (Pass value from Parent to Child, Calculation)

TylerT — Tue, 19 Mar 2024 21:18:18 GMT

@ZachBodenner,

I've moved out of the hosted feature class and into two other test environments and this is what I get.

gdb: Original code passes linter and rule is applied. ArcGIS Pro works as expected passing value to child.

var parent_fs = FeatureSetByRelationshipName($feature, "t12_projects_rc") var parent = First(parent_fs) if(parent == null) { return } return parent.project_pw

edgb: The linter rejects the code above (and OP code). The linter only accepts this code (no First()), as you suggested. However, once the rule is applied, the child table does not work. No value is passed to child in ArcGIS Pro, and errors occur published web apps.

var parent_fs = FeatureSetByRelationshipName($feature, "t12_projects_rc") if(parent_fs == null) { return } return parent_fs.project_pw

I tried both traditional and branch version db connections. Any other ideas?

Tyler
Enterprise 11.2
ArcGIS Pro 3.2.0

Re: Add Attribute Rule, Help With Arcade Expression (Pass value from Parent to Child, Calculation)

TylerT — Thu, 21 Mar 2024 12:57:35 GMT

Hi All,

Okay, A couple of days of pounding my head against the wall and I figured it out. The FeatureSetByRelationshipName function in the Arcade Expression required the full EGDB table name (i.e. 'DBO...') as shown below, contrary to the in_table argument of the arcpy.management.AddAttributeRule() method which does not.

HTH somebody else.

Tyler