topic layerdefinition and timestamp in ArcGIS API for Flex Questions

layerdefinition and timestamp

ParksCamp — Tue, 15 Mar 2011 13:10:49 GMT

Attempting to apply a layer definition through the flex api to an ArcGISDynamicMapLayer. Target layer is on postgresql/SDE. For some reason, I can use the "date" function successfully, but not the "timestamp" function. Here's the code:

var wwaLyr:ArcGISDynamicMapServiceLayer = map.getLayer("WWA") as ArcGISDynamicMapServiceLayer;

var stringDef:String = "beginDate <= timestamp'2010-03-11 19:50:00'"; //This does not work
var stringDef:String = "beginDate <= date'2010-03-11'"; //This works

wwaLyr.layerDefinitions = [stringDef];
wwaLyr.refresh();

Any thoughts on why TIMESTAMP is not working.

Thanks,
Parks
Tallahassee

Re: layerdefinition and timestamp

DasaPaddock — Tue, 15 Mar 2011 16:35:00 GMT

What versions of ArcGIS Server and ArcGIS API for Flex are you using?

Re: layerdefinition and timestamp

ParksCamp — Tue, 15 Mar 2011 20:00:54 GMT

What versions of ArcGIS Server and ArcGIS API for Flex are you using?

I'm using version 2.2 of the Flex API. The service I'm consuming is running on ArcGIS Server 9.3.1.

Thanks,
Parks

Re: layerdefinition and timestamp

DasaPaddock — Tue, 15 Mar 2011 21:49:53 GMT

You'll need to be using a ArcGIS Server 10 hosted service since it has added a new syntax for the layerDefs parameter that allows :'s in the definition value. The old syntax uses :'s as a layer id separator.

Reference:
http://help.arcgis.com/en/arcgisserver/10.0/apis/rest/export.html

Re: layerdefinition and timestamp

ParksCamp — Tue, 15 Mar 2011 22:08:19 GMT

You'll need to be using a ArcGIS Server 10 hosted service since it has added a new syntax for the layerDefs parameter that allows :'s in the definition value. The old syntax uses :'s as a layer id separator.

Reference:
http://help.arcgis.com/en/arcgisserver/10.0/apis/rest/export.html

Dasa,

Thanks. That helps.

parks

Re: layerdefinition and timestamp

ParksCamp — Sat, 11 Dec 2021 09:31:38 GMT

You'll need to be using a ArcGIS Server 10 hosted service since it has added a new syntax for the layerDefs parameter that allows :'s in the definition value. The old syntax uses :'s as a layer id separator.

Reference:
http://help.arcgis.com/en/arcgisserver/10.0/apis/rest/export.html

FYI,

I was able to find a workaround for this issue by sending the epoch time and using the sql "to_timestamp" function:

var nDate:Date = new Date();
var qTime:Number = nDate.time;
var wwaLyr:ArcGISDynamicMapServiceLayer = map.getLayer("WWA") as ArcGISDynamicMapServiceLayer;

var stringDef:String = "beginDate <= to_timestamp(qTime)";
wwaLyr.layerDefinitions = [stringDef];
wwaLyr.refresh();