AnsweredAssumed Answered

ArcGIS Online Arcade Gone Wrong

Question asked by NEOMAPPER on Sep 9, 2020
Latest reply on Sep 9, 2020 by xander_bakker

Why can't i return information accessing a related table using the arcade code on a feature class? I'm requesting an assignmentID from the feature, placing the ID in a sql expression; accessing the related table and filtering the results to match the ID with the description and returning the results when a user clicks on a point. Right now it returns blank. Any ideas?


//  read out the ID of the assignment type
var assignmentID = $feature["assignmenttype"];

// create a sql expression to query on ID
var sql = "Assignment = '" + assignmentID + "'";

// access table data
var tbl = FeatureSetByName($datastore,"Assignment Types");

var related_data = Filter(tbl, sql);

return related_data