My organization has long had a need to be able to apply dynamic date filters on layers. An example is our road closures. What we want queried from the layer are closures that are within two weeks of their start time and up to their end time. Something like the formula below.
GETDATE() >= ('starttime' - INTERVAL '14 days') AND 'endtime' <= GETDATE()
Technically what I am asking for is already possible using the ArcGIS Assistant to edit the JSON of a web map. However, saving the web map through the Map Viewer UI will strip out the dynamic date filter.
I know the ArcGIS Road Closure solution at one point used an Arcade expression to set transparency on the layers. Yes, that hides the closures on the map, but it confused my users when they would click on what looks like one closure and the popup could return additional closures not visible on the map.
