https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/using-sql-in-feature-service-groupby/m-p/1208717#M4267 <P>Hello,</P><P>I'm using the query operation on a hosted feature service and would like to use an SQL clause in the groupByFieldsForStatistics parameter, e.g. 'SUBSTRING(ObservationDate, 1, 4)'</P><P>If not, does anyone have ideas for a different approach?</P><P>&nbsp;</P><P>Thanks!</P> Thu, 01 Sep 2022 14:55:14 GMT john_cartwright_noaa 2022-09-01T14:55:14Z https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/using-sql-in-feature-service-groupby/m-p/1208717#M4267 <P>Hello,</P><P>I'm using the query operation on a hosted feature service and would like to use an SQL clause in the groupByFieldsForStatistics parameter, e.g. 'SUBSTRING(ObservationDate, 1, 4)'</P><P>If not, does anyone have ideas for a different approach?</P><P>&nbsp;</P><P>Thanks!</P> Thu, 01 Sep 2022 14:55:14 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/using-sql-in-feature-service-groupby/m-p/1208717#M4267 john_cartwright_noaa 2022-09-01T14:55:14Z