ArcGIS Online Arcade Gone Wrong

JordanMiller4 — Sat, 11 Dec 2021 22:03:46 GMT

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‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: ArcGIS Online Arcade Gone Wrong

XanderBakker — Wed, 09 Sep 2020 21:52:00 GMT

Hi Jordan Miller ,

Let's assume that the filter is executed correctly (which could be wrong depending on the format of the data).

The main issue here is the fact that you return a featureset. Featuresets can be displayed when you test the expression in the expression editor, but will not be shown up in the pop-up. You will need to go through each feature in the featureset and extract the information you need and create a text that you want to show in the pop-up.

Some examples where this is explained in detail are:

topic Re: ArcGIS Online Arcade Gone Wrong in ArcGIS Online Questions

ArcGIS Online Arcade Gone Wrong

Re: ArcGIS Online Arcade Gone Wrong