topic Re: Pull date from previous record in a child table in ArcGIS Pro Questions

Pull date from previous record in a child table

AustinPhelps1 — Mon, 07 Oct 2024 21:53:38 GMT

I am trying to calculate a field in field maps using the arcade expression.

I have a parent/child relationship and I need to pull the last recording date to populate a field on the new record created.

Here is what I have, and it is currently not working. What am I missing in my expression?

//Fetch the related inspections from the related table using the relationship name

var inspections = FeatureSetByRelationshipName($feature, "Corrosometer_Probe_Data_Records", ["Read_Date"], false);

//Sort inspections by the read date in descending order to get the most recent

var sortedInspections = OrderBy(inspections, "Read_Date DESC");

//Get the first (latest) inspection date

var latestInspection = First(sortedInspections);

//If there are previous inspections, get the date of the latest inspection

if (!IsEmpty(latestInspection)) {

return latestInspection["Read_Date"];

} else {

//If no previous inspections exist, return null or a default value

return null;

}

Thanks for any help!

Re: Pull date from previous record in a child table

Amanda__Huber — Mon, 07 Oct 2024 22:13:55 GMT

Hi @AustinPhelps1 ,

This sounds very similar to on of our current projects which uses relationship classes (1:Many) with related table information being pulled into our parent table's popup.

Here is example for what we did to pull the top 3 records and diplay in a popup. I believe you could just pull the top one record instead.

I believe you might need the "Top()" function for your script for it to work. https://developers.arcgis.com/arcade/function-reference/featureset_functions/#top

Hope this helps!

Best,

Amanda Huber

Re: Pull date from previous record in a child table

AustinPhelps1 — Tue, 08 Oct 2024 13:09:28 GMT

Doesn't seem to have worked, but thank you for the suggestion. I keep getting this when running it: Test execution error: Execution error - Invalid parameter. Verify test data.

I have 1500 records in my child table and 28 points in the parent so I know there is data in them

Re: Pull date from previous record in a child table

Amanda__Huber — Tue, 08 Oct 2024 13:18:15 GMT

Try adding this as well, this matches up the parent's GlobalID with the related table's GUID so it knows what parent record to pull from.

Best of luck,

Amanda Huber