topic Re: Need Help Modifying this code for my Attribute Rule in Attribute Rules Questions

Need Help Modifying this code for my Attribute Rule

BrianHumphries1 — Fri, 14 Apr 2023 15:31:03 GMT

Goal is to copy a list of the most resent attributes from a related table back to the Related Feature Class.

The feature class is called SampleSites, the related table is for collecting water samples for the that site.

Inspection Table is related to the Sample Sites GolbalID field and stored in a field called "SampleSites_Rel" in the Inspection Table

The Expression I am using now only gets the first record of the "inspection" variable in the Filter, I have tried "Max" and was not successful, I have tried to Sort the Table and failed " I had a wrong number of arguments" trying to add the sort to the expression.

Any help would be much appreciated

Re: Need Help Modifying this code for my Attribute Rule

KenBuja — Fri, 14 Apr 2023 15:47:03 GMT

You can use the OrderBy function to sort it and then get the first record of that ordered FeatureSet.

Re: Need Help Modifying this code for my Attribute Rule

BrianHumphries1 — Fri, 14 Apr 2023 16:01:58 GMT

Thank you that did the trick

added the variable to perform the Order

var InspectionOrderBy = OrderBy(Inspection, 'SampleDate DESC')

The Working code with the OderBy