https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/are-the-allowable-sql-functions-in-outfields/m-p/1331204#M4558 <P>I can't seem to find anything about what functions are available to me in the <STRONG>outFields</STRONG> parameter of a query.</P><P>I can do things like <STRONG>UPPER(field)</STRONG> and get my string field in upper-case. Or I can do <STRONG>field * 10 </STRONG>to get that field multiplied by 10. But I can't use <STRONG>LEFT(field, n)</STRONG>.</P><P>From what I can find, the documentation just says this parameter takes lists of field names or a '*' wildcard, not even a mention of functions.</P><P>Knowing what is and isn't allowed here without doing lots of trial and error would be great. I have a number of use-cases where I only need to store the data one way, but might need to query it out differently. Functions in the query save me a step of manipulating the data after getting it.</P> Thu, 21 Sep 2023 18:06:00 GMT jcarlson 2023-09-21T18:06:00Z https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/are-the-allowable-sql-functions-in-outfields/m-p/1331204#M4558 <P>I can't seem to find anything about what functions are available to me in the <STRONG>outFields</STRONG> parameter of a query.</P><P>I can do things like <STRONG>UPPER(field)</STRONG> and get my string field in upper-case. Or I can do <STRONG>field * 10 </STRONG>to get that field multiplied by 10. But I can't use <STRONG>LEFT(field, n)</STRONG>.</P><P>From what I can find, the documentation just says this parameter takes lists of field names or a '*' wildcard, not even a mention of functions.</P><P>Knowing what is and isn't allowed here without doing lots of trial and error would be great. I have a number of use-cases where I only need to store the data one way, but might need to query it out differently. Functions in the query save me a step of manipulating the data after getting it.</P> Thu, 21 Sep 2023 18:06:00 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/are-the-allowable-sql-functions-in-outfields/m-p/1331204#M4558 jcarlson 2023-09-21T18:06:00Z https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/are-the-allowable-sql-functions-in-outfields/m-p/1331484#M4561 <P>I think instead of LEFT you can use SUBSTRING.</P><P>This is the best information I'm aware of regarding SQL support:</P><P><A href="https://enterprise.arcgis.com/en/server/latest/administer/linux/about-standardized-queries.htm" target="_blank">Enforce standardized SQL queries—ArcGIS Server | Documentation for ArcGIS Enterprise</A></P><P><A href="https://doc.arcgis.com/en/arcgis-online/reference/sql-agol.htm" target="_blank">Standardized SQL functions in ArcGIS Online—ArcGIS Online Help | Documentation</A></P><P>&nbsp;</P><P>I believe this is only supported 10.9+ when '<SPAN>supportsOutFieldSqlExpression' was added.</SPAN></P> Fri, 22 Sep 2023 14:55:55 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/are-the-allowable-sql-functions-in-outfields/m-p/1331484#M4561 EarlMedina 2023-09-22T14:55:55Z