AnsweredAssumed Answered

Sort FeatureSet in Arcade using OrderBy

Question asked by cmcartneyesriaustralia-com-au-esridist Employee on Jul 14, 2020
Latest reply on Jul 15, 2020 by cmcartneyesriaustralia-com-au-esridist

Hi All,

 

I am trying to sort the results of a table in arcade but having trouble hitting the table's fields. This table is related based on a pin, but not joined in any way to the feature set that the arcade expression is running on. It is arcade in ArcGIS Portal Popups.

 

Snippet below.

 

#assign table

var tbl = FeatureSetByName($map,"TABLE");

# assign pin

var pt = $feature['PIN'];

 

#create sql variable

var sql = "PIN = '" + pt + "'";

#run query on table

 

var query = Filter(tbl, sql);

 

var order = OrderBy(query, 'date DESC')

 

var result = ""
for (var field in order) {
   result += ....;

}

return result;

 

However when running this it tries to search the $feautre instead of the table resulting in field not found error.. Any asssitance would be appreacited. 

Outcomes