ArcGIS Server rest services - relationship class cannot query date from joined table

DavidMitchell2 — Wed, 02 May 2012 14:36:14 GMT

We have a feature class (FC1) joined to a sde registered table (tbl1) using a relationship class.

Tbl1 contains a date field plus other attributes.

We are trying to query the feature using a where clause that will filter results based on any attributes field-values and an intersect with geometry.

For example the ERSRI query task allows me to pass geometry to it:
i.e. + Geometry {3231065.43494868,1734576.29053077,3233028.0102428,1736280.2975896} ESRI.ArcGIS.Client.Geometry.Geometry {ESRI.ArcGIS.Client.Geometry.Envelope}

Then I add a where clause like this to further filter:
Where "FC1.Level = 1 AND tbl1.effective_date >= '02/27/1995' AND tbl1.effective_date <= '01/01/2000'
From the ArcGIS Rest Services Query â?? when I add any â??where clauseâ?? using the date field I get â??unable to perform queryâ?? as a result.

Queries against other attributes contained in the table work just fine.

I am looking for a solution to query the feature set with geometry and filter by a date range. (i.e. see where clause above).

Re: ArcGIS Server rest services - relationship class cannot query date from joined ta

RaviNarayanan — Thu, 10 May 2012 15:04:00 GMT

David,

The syntax for specifying DATE values will depend upon the data source. Please see this help topic (section: Dates and time) for more information about querying based on DATE values.

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00s500000033000000.htm

topic ArcGIS Server rest services - relationship class cannot query date from joined table in ArcGIS REST APIs and Services Questions

ArcGIS Server rest services - relationship class cannot query date from joined table

Re: ArcGIS Server rest services - relationship class cannot query date from joined ta