Show / Hide Table of Contents

Property WhereClause

WhereClause

Gets or sets the attribute expression that defines features to be included in the statistics query.

Declaration
public string WhereClause { get; set; }
Property Value
Type Description
System.String

The attribute expression that defines features to be included in the statistics query.

Remarks

The where clause should follow standard SQL syntax similar to that discussed in the document SQL reference for query expressions used in ArcGIS.

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 for date formats expected by different data sources.

ArcGISFeatureTable objects expect that any GlobalID or 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.

A combination of attribute, spatial, and temporal criteria can be used to filter the features evaluated in a statistical query. If no filters are defined, all features in the table are included in the query.

Applies to

Platforms and versions
TargetVersions
.NET Standard 2.0100.3 - 200.7
.NET100.13 - 200.7
.NET Windows100.13 - 200.7
.NET Android200.0 - 200.7
.NET iOS200.0 - 200.7
.NET Framework100.2.1 - 200.7
Xamarin.Android100.2.1 - 100.15
Xamarin.iOS100.2.1 - 100.15
UWP100.2.1 - 200.7
Relevant samples
Statistical query: Query a table to get aggregated statistics back for a specific field.
In This Article
Back to top Copyright © 2022 Esri.