topic Re: Working offline filter map using Arcade expression in ArcGIS Field Maps Questions

Working offline filter map using Arcade expression

OliverIshmael — Fri, 28 Jul 2023 11:11:47 GMT

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?

Re: Working offline filter map using Arcade expression

SarahSaint-Ruth — Fri, 28 Jul 2023 14:16:22 GMT

Hi @OliverIshmael are you wanting to apply a layer filter or change the symbology based on whether they are overdue?

Re: Working offline filter map using Arcade expression

OliverIshmael — Sat, 29 Jul 2023 11:43:37 GMT

Hi @SarahSaint-Ruth either option would work.

Re: Working offline filter map using Arcade expression

SarahSaint-Ruth — Mon, 31 Jul 2023 11:43:38 GMT

Hi @OliverIshmael,

Date filters are planned for a future release for Field Maps. However, you would be able to change the symbology today and the script you've authored should work offline - have you tried your script, are you getting errors when trying to use it offline?

You can Arcade to change the symbology in the Map Viewer by selecting Styles and then selecting Expression:

Re: Working offline filter map using Arcade expression

OliverIshmael — Tue, 01 Aug 2023 11:27:30 GMT

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?

Re: Working offline filter map using Arcade expression

SarahSaint-Ruth — Tue, 01 Aug 2023 13:00:15 GMT

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.

Re: Working offline filter map using Arcade expression

ShaunGibbins — Tue, 05 Mar 2024 15:29:20 GMT

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.