Problem: Using parentheses in queries to ArcSDE for Coverages layers returns incorrect results
When the WHERE clause of a query to an ArcSDE for Coverages layer includes parentheses, all records are returned. An example is:
<SPATIALQUERY where="(STATE_NAME = 'California')" >
This is a known issue.
Solution or Workaround
Select an option below.
- Add a space between the parentheses and the text inside:
<SPATIALQUERY where="( STATE_NAME = 'California' )" >
- Remove the parentheses.
Shapefile and ArcSDE layers do not have this problem.