Valid SQL statements for query.text and query.where

KennethRichards

Can anyone give me a link to valid SQL statements that I can use when building my where and text queries?

KaitlynnDavis

If you are familiar with "Select by Attributes" in ArcGIS for desktop, you use the same SQL syntax that you do for the query.where property in arcgis javascript

http://resources.arcgis.com/en/help/main/10.1/index.html#//00s500000033000000

Here is an example in legacy dojo:

var queryTask = new esri.tasks.QueryTask("URL to the resource to be queried");      var query = new esri.tasks.Query();      query.returnGeometry=false;      query.outFields = "*";      query.where = "YOUR_FIELD = 'the value to query' ";