Is This Content Helpful?
We're glad to know this article was helpful.
When performing a REST query on a date field, ArcGIS for Server 10.2 reports a SEVERE error message:
"An invalid where clause or definition expression has been requested."
Map, feature, image, and WFS services now use standardized queries
Using a query on a date field such as the following fails because it is a database-specific WHERE clause that is not standardized:
WHERE (TIME_DATE <= TO_DATE('10/01/2010','DD/MM/YYYY') )
WHERE (TIME_DATE <= date '2010-10-01')
Standardized queries are enforced by default, but can be disabled by the server administrator.
If it is necessary to use database-specific WHERE clause statements in an application, standardized queries can be disabled by accessing the ArcGIS Server Administrator Directory.
By disabling this security option, the site becomes more vulnerable to SQL injection attacks.