Property WhereClause
WhereClause
Gets or sets the where clause of the query.
Declaration
public string WhereClause { get; set; }Property Value
| Type | Description |
|---|---|
| String | The where clause of the query. |
Remarks
The string that is used as the WhereClause should follow standard SQL syntax similar to what is discussed in the ArcGIS Pro document SQL reference for query expressions used in ArcGIS.
ArcGISFeatureTable objects expect that any GlobalID
or Guid parameters in the string that is used as the
WhereClause are formatted as so:
'{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}'
Note that all uppercase characters are wrapped in curly braces and surrounded by single quotes.
If the string that is used as the WhereClause is used by the PopulateFromServiceAsync(QueryParameters, Boolean, IEnumerable<String>) method, you can put any CQL-TEXT or CQL-JSON string as defined in the document OGC API - Features - Part 3. Note: CQL-TEXT and CQL-JSON string are not supported with ArcGISFeatureTable objects.
Applies to
Platforms and versions
| Target | Versions |
|---|---|
| .NET Standard 2.0 | 100.3 - 200.0 |
| .NET 6.0 | 100.13 - 200.0 |
| .NET 6.0 Windows | 100.13 - 200.0 |
| .NET 6.0 Android | 200 |
| .NET 6.0 iOS | 200 |
| .NET Framework | 100.0 - 200.0 |
| .NET 5 | 100.10 - 100.12 |
| .NET Core 3.1 | 100.7 - 100.12 |
| Android | 100.0 - 100.15 |
| iOS | 100.0 - 100.15 |
| UWP | 100.0 - 200.0 |