AnsweredAssumed Answered

Query feature service via REST, where DateTime now is less than some factor

Question asked by nickoday2005 on May 2, 2017
Latest reply on May 2, 2017 by nickoday2005

I'm trying to figure out how to filter features that are showing up in a map based on when they were last edited.  All of the documentation I have been able to find says that this can't be done in ArcGIS Online or Portal (which is where I'm trying to build the map).  What I'd like to do is simply filter the features down to just those that were edited in the last 3 hours, based on the last_edited_date in the data.  In SQL, I would just do this:

 

last_edited_date > DATEADD(hh,-3,GETDATE())

 

...but this doesn't work.  Is there a way to do this via the REST endpoint?

 

I'm thinking that if I can figure out how to set the where clause correctly, I can take the service URL with the where clause, plug it into a map in AGOL, set a refresh on the layer, and boom... done.

 

Any thoughts on how to construct the ?

Outcomes