topic Pull in Most Recent Date Inspected from one Layer into another in Pop-Up Using Arcade in ArcGIS Online Questions

Pull in Most Recent Date Inspected from one Layer into another in Pop-Up Using Arcade

MelanieBass — Thu, 10 Aug 2023 13:56:49 GMT

I am working on configuring the pop-ups on our hydrant layer to automatically pull in the most recent date inspected from a different layer: Hydrant Inspection layer. I want it to pull the most recent date if there is more than one date inspected for a given hydrant, which in many cases there are. I have been wracking my brain on an arcade statement but nothing I get works. I am not sure if I need to do an Intersects function with hydrant or OrderBy or First. I am lost. I would even love to have it pull in as an attribute rule inside of ArcGIS pro for the layer but for now I will settle on getting an arcade for the pop-up. If anyone has any suggestions, they would be much appreciated.

Re: Pull in Most Recent Date Inspected from one Layer into another in Pop-Up Using Arcade

JohannesLindner — Thu, 10 Aug 2023 19:57:47 GMT

var all_inspections = FeaturesetByName($map, "Inspections") var hydrant_id = $feature.HydrantID var hydrant_inspections = Filter(all_inspections, "HydrantID = @hydrant_id") var sorted_inspections = OrderBy(hydrant_inspections, "InspectionDate DESC") var latest_inspection = First(sorted_inspections) if(latest_inspection == null) { return "No inspection found" } return latest_inspection.InspectionDate

Re: Pull in Most Recent Date Inspected from one Layer into another in Pop-Up Using Arcade

MelanieBass — Mon, 14 Aug 2023 17:55:31 GMT

var all_inspections = FeaturesetByName($map, "Hydrant Inspections")

var hydrant_id = $feature.HydrantID

var hydrant_inspections = Filter(all_inspections, "HydrantID = @hydrant_id")

var sorted_inspections = OrderBy(hydrant_inspections, "DateInspected DESC")

var latest_inspection = First(sorted_inspections)

if(latest_inspection == 'December 29, 1899') { return "No inspection found" }

return latest_inspection.DateInspected

this is what I put in and I am getting the invalid parameter error. Is the "DateInspected DESC" supposed to be a field? The field for Date Inspected is DateInspected. Any other suggestions? Thank you for your help! I appreciate it. @JohannesLindner