Dynamic Date in hosted feature layer

GillPaterson — Wed, 15 May 2019 09:08:59 GMT

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??

Re: Dynamic Date in hosted feature layer

GillPaterson — Tue, 17 Sep 2019 05:16:22 GMT

The answer can be found here... Querying Feature Services: Date-Time Queries

topic Re: Dynamic Date in hosted feature layer in ArcGIS Enterprise Questions

Dynamic Date in hosted feature layer

Re: Dynamic Date in hosted feature layer