Working offline filter map using Arcade expression

Question

I have mapped features with a survey date and a resurvey frequency and i would like to filter the map to show those features which are overdue a resurvey. I believe this would require an Arcade expression like this:

IIf(DateDiff(now(), $feature.InspectionDate, 'days') < $feature["Inspection_Frequency"], "Recently Inspected", "Inspection Overdue")

Can this be implemented in Field Maps to work offline?

ShaunGibbins · Answer

You could add a field to the asset layer that holds the value from the date in the inspection related layer then use an attribute rule to populate the asset lvInspectedDate field every time an inspection is added.

The asset will then always hold the last inspected date value which you can then use for symbology purposes.

This does work offline, however the symbology doesn't update until a sync has succeeded as the rules are applied on the server side.

Well, this is the case for ArcGIS Enterprise using an enterprise geodatabase as a referenced datastore anyway, I have not tried offline with an AGOL hosted feature service.

SarahSaint-Ruth · Answer

Ah ok - sorry to be the bearer of bad news but this won't work as imagined.  You can’t symbolize data directly from your related tables. However, you can use Arcade to process your related data that you wish to use in your symbology. There is a great blog article by Kristian Ekenes with more information on why this is the case and how to implement alternative workflows.

OliverIshmael · Answer

Hi @SarahSaint-Ruth,

The problem i have with the Arcade code above is that:

$feature.InspectionDate is an attribute in a related table called Inspect the Asset, while $feature.Inspection_Frequency is an attribute in the Rec Map Assets layer

How should the Arcade code be rewritten to account for this?