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.