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

Discussion created by dmitchellEDN on May 2, 2012
Latest reply on May 10, 2012 by rnarayanan-esristaff
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).