whereClause

The attribute expression that defines features to be included in the statistics query. The where clause should follow standard SQL syntax similar to that discussed in the document https://pro.arcgis.com/en/pro-app/latest/help/mapping/navigation/sql-reference-for-elements-used-in-query-expressions.htm#GUID-940733A1-D6D1-4200-B290-24CA2E1056D4.

If the where clause includes dates, they must be correctly formatted based on the geodatabase datasource used in the service. Refer to Dates and time[https://pro.arcgis.com/en/pro-app/latest/help/mapping/navigation/sql-reference-for-elements-used-in-query-expressions.htm#GUID-85C03D85-F4A5-48FC-8E8C-3F79919430DB] for date formats expected by different data sources.

ArcGISFeatureTable objects expect that any FieldType.GlobalId or FieldType.Guid parameters in the where clause are formatted as: '{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}'. All characters are uppercase, wrapped in curly braces and surrounded by single quotes.