topic Re: Error in Filter when creating Arcade Data Expression in ArcGIS Dashboards Questions

Error in Filter when creating Arcade Data Expression

ZachLansford_HD — Thu, 30 Mar 2023 14:09:33 GMT

Hi everyone,

I am trying to create a Data Expression within my dashboard to access some related records. I've set up a filter to access the data but am getting an error when trying to access the data from the Filter.

"Test execution error: Unknown Error. Verify test data."

I've added a few console outputs to test my results. I am able to get the output for the first console statement but then run into the error.

I've added the relevant portion of the script below.

var portalServ = Portal("https://www.arcgis.com/"); var pointFS = FeatureSetByPortalItem( portalServ, "featID", 0, ["*"], False ); var tablefs = FeatureSetByPortalItem( portalServ, "featID", 1, ["*"], False ); var features = []; var feat; var calls_sub_found_var; for (var t in tablefs){ var TableID = t["op_record_id"] console(TableID); for (var p in Filter(pointFS,"op_record_id = "+Text(TableID))){ console(p["op_record_id"]); } }

Additionally, if I use the console to output the Filter object itself, I am able to return that. It is only when I try and start accessing the objects from the filter when I run into the error.

Would the amount of data be a factor in the filter failing? I'm working with ~120k point features and ~20k related records in total.

Re: Error in Filter when creating Arcade Data Expression

KenBuja — Thu, 30 Mar 2023 14:20:02 GMT

Is op_record_id field a string field or numeric? If it's a string, you'll need quotes. Or you can avoid that by using @variable

var TableID = Text(t["op_record_id"]); for (var p in Filter(pointFS,"op_record_id = @TableID")){

Re: Error in Filter when creating Arcade Data Expression

ZachLansford_HD — Thu, 30 Mar 2023 14:23:11 GMT

It is a string field - this solved my issue. Thanks a bunch!

Re: Error in Filter when creating Arcade Data Expression

jcarlson — Thu, 30 Mar 2023 14:29:36 GMT

When you return the filtered object, what does it look like?

When I write a filter statement, I prefer to use template literals:

Filter(pointFS,`op_record_id = ${TableID}`)

In general, when you're working with a filtered FeatureSet, you ought to include an if statement that checks to see that there are any features. Expressions can sometimes break when they attempt to work with a FeatureSet that has nothing in it.

var filtered = Filter(...) if (Count(filtered) > 0) { for (var p in filtered) { ... } }

Is there a real relationship class between the layers? Why not use FeatureSetByRelationShipName?