Error in Filter when creating Arcade Data Expression

ZachLansford_HD

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.

kenbuja

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")){