Property WhereClause
WhereClause
Gets or sets the attribute expression that defines features to be included in the query.
Declaration
public string WhereClause { get; set; }Property Value
| Type | Description |
|---|---|
| System.String | The where clause of the 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 string that is used as the
where clause are formatted as: '{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}'. All characters are uppercase, wrapped
in curly braces and surrounded by single quotes.
If the where clause is used to populate a OgcFeatureCollectionTable, you can use a CQL2-TEXT or CQL2-JSON string as defined in the document OGC API - Features - Part 3.
Applies to
Platforms and versions
| Target | Versions |
|---|---|
| .NET Standard 2.0 | 100.3 - 200.7 |
| .NET | 100.13 - 200.7 |
| .NET Windows | 100.13 - 200.7 |
| .NET Android | 200.0 - 200.7 |
| .NET iOS | 200.0 - 200.7 |
| .NET Framework | 100.0 - 200.7 |
| Xamarin.Android | 100.0 - 100.15 |
| Xamarin.iOS | 100.0 - 100.15 |
| UWP | 100.0 - 200.7 |