Show / Hide Table of Contents

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
TargetVersions
.NET Standard 2.0100.3 - 200.0
.NET 6.0100.13 - 200.0
.NET 6.0 Windows100.13 - 200.0
.NET 6.0 Android200
.NET 6.0 iOS200
.NET Framework100.0 - 200.0
.NET 5100.10 - 100.12
.NET Core 3.1100.7 - 100.12
Android100.0 - 100.15
iOS100.0 - 100.15
UWP100.0 - 200.0
Relevant samples
Feature layer query: Find features in a feature table which match an SQL query.
Find service areas for multiple facilities: Find the service areas of several facilities from a feature service.
Map image layer tables: Find features in a spatial table related to features in a non-spatial table.
In This Article
Back to top Copyright © 2022 Esri.