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);