topic Re: Query FeatureLayer by date in ArcGIS JavaScript Maps SDK Questions

Query FeatureLayer by date

JimWharton — Mon, 05 May 2014 23:40:39 GMT

Can someone give me an example of how I would query a featurelayer by date?

I have a field in my featureservice named 'time'. The field type is: type: esriFieldTypeDate

Is this documented anywhere what that field type expects? I've sent all kinds of different date formats including:

mm/dd/yyyy
yyyy-mm-dd
yyyy-mm-dd HH:MM:SS
unix_time_stamp (1399336752182)

I'm sure someone out there has queried features before or after a particular date... I'd just like to see an example as I can't find any API docs that show how this should be done.

Re: Query FeatureLayer by date

BenFousek — Tue, 06 May 2014 15:03:29 GMT

where = "dateField > date'YYYY/MM/DD'"

AGS 10+

Re: Query FeatureLayer by date

JohnGrayson — Tue, 06 May 2014 15:15:47 GMT

From the ArcGIS Server REST API: feature

Note that date values are encoded as numbers. The number represents the number of milliseconds since epoch (January 1, 1970) in UTC.

Example:

query.where = "(time > " + fromDate.valueOf() + ") AND (time < " + toDate.valueOf() + ")";

JS Date Object: link

Re: Query FeatureLayer by date

ChipHankley1 — Wed, 07 May 2014 15:22:20 GMT

I had some challenges with this recently. For me, a good starting point was to use the layer properties dialog in ArcMap to build the definition query that I wanted. Once I had the format that ArcMap expected (for the particular layer I was working with), I could begin playing around with rendering the definition query from the JS side.

In my case, I was working against an Oracle, non-sde (native spatial type) feature class, and the definition query expected an Oracle specific date function: TO_DATE('yyyy-mm-dd hh:mm:ss','YYYY-MM-DD HH24:MI:SS'). I was unable to get the Oracle date function to work correctly, so I ended up casting the Oracle timestamp to a UNIX timestamp (milliseconds since 1/1/1970) and querying against that directly - this was easier b/c

I didn't have to deal with any weird date functions

it just becomes a number comparison condition

Word of warning about JavaScript and dates. Make sure you carefully look at the timestamp as I believe, at some level, JavaScript always stores timezone information into the date. I ended up having to perform a UTC offset on some of the data I was processing to make the timestamps that I was getting from Oracle match up with dates I was rendering in JS code. Probably a mistake somewhere on my part, but something to be aware of.

Re: Query FeatureLayer by date

JimWharton — Thu, 08 May 2014 20:24:17 GMT

I guess I must be using the wrong type of date field or something. That doesn't work for me.

Here's my service definition: https://services1.arcgis.com/BqQ60RORKMjmx3jf/ArcGIS/rest/services/Photos_Template/FeatureServer/0 (I don't think token is required)

-Jim

Re: Query FeatureLayer by date

JohnGrayson — Fri, 09 May 2014 15:53:59 GMT

Jim,

are you sure that's the correct url? The service seems to be empty. When using 'where: 1=1' and 'returnCountOnly: true' parameters:

Request:
https://services1.arcgis.com/BqQ60RORKMjmx3jf/ArcGIS/rest/services/Photos_Template/FeatureServer/0/query?where=1%3D1&returnCountOnly=true&f=json

Result: { "count": 0}

Re: Query FeatureLayer by date

JimWharton — Sun, 11 May 2014 21:07:17 GMT

The service has been regenerated, nothing exists there yet. The ESRI Date Type is the only date/time type that I can see.

Now, from all the responses here, a normal unix timestamp is what ArcGIS Online services expect as a param.

(The number of seconds from Jan 1, 1970) Is this correct?