topic Re: does anybody know what is the syntax of arcgis sql expression as i am finding difficult to understand and implemention .it will be much helpful.Thank you in advance in ArcGIS JavaScript Maps SDK Questions https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/does-anybody-know-what-is-the-syntax-of-arcgis-sql/m-p/347064#M32088 <HTML><HEAD></HEAD><BODY><P>In ArcGIS you only have access to the WHERE clause of a SQL statement. Most SQL is supported as long as it is only the WHERE clause.</P><P></P><P><A href="http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/building-a-query-expression.htm">http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/building-a-query-expression.htm</A></P><P><A href="https://enterprise.arcgis.com/en/server/latest/administer/linux/about-standardized-queries.htm">https://enterprise.arcgis.com/en/server/latest/administer/linux/about-standardized-queries.htm</A></P></BODY></HTML> Sat, 13 Jul 2019 12:12:43 GMT RobertScheitlin__GISP 2019-07-13T12:12:43Z does anybody know what is the syntax of arcgis sql expression as i am finding difficult to understand and implemention .it will be much helpful.Thank you in advance https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/does-anybody-know-what-is-the-syntax-of-arcgis-sql/m-p/347063#M32087 <HTML><HEAD></HEAD><BODY><P>i know the sql language,but i am&nbsp;unfamiliar with arcgis sql expression/syntax&nbsp;&nbsp;</P></BODY></HTML> Sat, 13 Jul 2019 06:23:31 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/does-anybody-know-what-is-the-syntax-of-arcgis-sql/m-p/347063#M32087 AnupamSharma 2019-07-13T06:23:31Z Re: does anybody know what is the syntax of arcgis sql expression as i am finding difficult to understand and implemention .it will be much helpful.Thank you in advance https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/does-anybody-know-what-is-the-syntax-of-arcgis-sql/m-p/347064#M32088 <HTML><HEAD></HEAD><BODY><P>In ArcGIS you only have access to the WHERE clause of a SQL statement. Most SQL is supported as long as it is only the WHERE clause.</P><P></P><P><A href="http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/building-a-query-expression.htm">http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/building-a-query-expression.htm</A></P><P><A href="https://enterprise.arcgis.com/en/server/latest/administer/linux/about-standardized-queries.htm">https://enterprise.arcgis.com/en/server/latest/administer/linux/about-standardized-queries.htm</A></P></BODY></HTML> Sat, 13 Jul 2019 12:12:43 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/does-anybody-know-what-is-the-syntax-of-arcgis-sql/m-p/347064#M32088 RobertScheitlin__GISP 2019-07-13T12:12:43Z Re: does anybody know what is the syntax of arcgis sql expression as i am finding difficult to understand and implemention .it will be much helpful.Thank you in advance https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/does-anybody-know-what-is-the-syntax-of-arcgis-sql/m-p/347065#M32089 <HTML><HEAD></HEAD><BODY><P><IMG alt="" class="image-1 jive-image j-img-original" src="/legacyfs/online/453045_Screenshot (3).png" /></P><P><A href="https://developers.arcgis.com/javascript/latest/sample-code/layers-scenelayerview-query-stats/index.html">https://developers.arcgis.com/javascript/latest/sample-code/layers-scenelayerview-query-stats/index.html</A></P><P></P><P>in the above code why "when"&nbsp; used also what is&nbsp;<SPAN style="color: #595959; background-color: #f8f8f8;">onStatisticField,<SPAN> </SPAN><SPAN class="">outStatisticFieldName,<SPAN style="background-color: #f8f8f8;">statisticType it will be very much helpful if you explain.Thank you&nbsp;</SPAN></SPAN></SPAN></P></BODY></HTML> Mon, 15 Jul 2019 05:35:16 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/does-anybody-know-what-is-the-syntax-of-arcgis-sql/m-p/347065#M32089 AnupamSharma 2019-07-15T05:35:16Z Re: does anybody know what is the syntax of arcgis sql expression as i am finding difficult to understand and implemention .it will be much helpful.Thank you in advance https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/does-anybody-know-what-is-the-syntax-of-arcgis-sql/m-p/347066#M32090 <HTML><HEAD></HEAD><BODY><P>Anupan,</P><P></P><P>&nbsp; In that code snippit the when is part of an Arcade expression.</P><P><SPAN class="" style="color: #c41a16;">"CASE WHEN (yearCompleted &gt;= '1975' AND yearCompleted &lt;= '1999') THEN 1 ELSE 0 END"</SPAN><SPAN style="color: #595959; background-color: #f8f8f8;">,</SPAN></P><P><SPAN style="color: #595959; background-color: #f8f8f8;"><A href="https://developers.arcgis.com/javascript/3/jshelp/arcade.html">https://developers.arcgis.com/javascript/3/jshelp/arcade.html</A></SPAN></P></BODY></HTML> Mon, 15 Jul 2019 11:37:37 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/does-anybody-know-what-is-the-syntax-of-arcgis-sql/m-p/347066#M32090 RobertScheitlin__GISP 2019-07-15T11:37:37Z