AnsweredAssumed Answered

Dynamic Date in hosted feature layer

Question asked by gill.paterson@geoplex.com.au on May 15, 2019
Latest reply on Sep 16, 2019 by gill.paterson@geoplex.com.au

In ArcGIS Portal I have a number of Hosted Feature Layers published through GeoEvent with the data in ArcGIS DataStore. I would like to filter these layers using a dynamic date filter, eg only show features that have an update date within the last 1 or 24 hours.

 

I found this dynamic date filter doc which was very helpful, however in Portal (10.6.1) it only seems to take simple date expressions, not anything to do with hours. I can get "definitionExpression": "cdts > (CURRENT_DATE - 1)" to work with any number of days. The field type is listed as Date, and the field shows Date/Time information. Is there an example of an expression that calculates the difference in time for ArcGIS Data Store? I have tried the following with no luck...

updated > DATEADD(day, 1, GETDATE())  - I thought I would try sql just in case it worked.

updated > DATEADD(hour, 1, GETDATE())  - I thought I would try sql just in case it worked.
updated > (CURRENT_DATE - INTERVAL '2 days')
updated > (timestamp(now()) - interval '2 days')

updated > (timestamp(now()) - interval '2 hours')
timestamp(updated) > (CURRENT_TIMESTAMP - interval '2 days')
timestamp(updated) > (CURRENT_TIMESTAMP - interval '12 hours')

 

Any other hints or suggestions??

Outcomes