AnsweredAssumed Answered

How to get attribute with last date modified from related table using Arcade

Question asked by Kelly.Doss_DurhamNC on Nov 6, 2019
Latest reply on Feb 20, 2020 by xander_bakker

Hello all,


I'm pretty new to Arcade and I'm having problems.  I believe I need to be using FeatureSets in Arcade.


I have a hosted feature layer with several related tables, some of which are 1:M.  In the CIP_Test pop-up, for the 1:M related tables, I only need to show the data from the rows with the latest "Date Modified".


I've attached a screenshot of the related table.  Where there are duplicate AcctNo, I only want to show the ProjectPhase (and maybe other fields) for the record that was last modified.


Any suggestions on how to do this are much appreciated!  I have gotten nothing but errors in everything I've tried from any forum posts I've found....