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).