ArcGIS Pro 3.7 API Reference Guide
ArcGIS.Desktop.Mapping Namespace / DefinitionQuery Class / WhereClause Property
Example

In This Topic
    WhereClause Property (DefinitionQuery)
    In This Topic
    Gets or sets the definition expression to filter rows in the dataset.
    Syntax
    Public Property WhereClause As String
    public string WhereClause {get; set;}
    Example
    Retrieve the Definition Query Filters for a Feature Layer
    {
        var us_parks = map.GetLayersAsFlattenedList()
              .OfType<FeatureLayer>().First(l => l.Name == "USNationalParks");
    
        //enumerate the layer's definition queries - if any
        var def_queries = us_parks.DefinitionQueries;
        foreach (var def_qry in def_queries)
        {
            var geom_uri = def_qry.GeometryUri ?? "null";
            var sr_wkid = def_qry.SpatialReference?.Wkid.ToString() ?? "null";
            var geom = def_qry.GetFilterGeometry();
            var geom_type = geom?.GeometryType.ToString() ?? "null";
    
            System.Diagnostics.Debug.WriteLine($" def_qry.Name: {def_qry.Name}");
            System.Diagnostics.Debug.WriteLine($" def_qry.WhereClause: {def_qry.WhereClause}");
            System.Diagnostics.Debug.WriteLine($" def_qry.GeometryUri: {geom_uri}");
            System.Diagnostics.Debug.WriteLine($" def_qry.SpatialReference: {sr_wkid}");
            System.Diagnostics.Debug.WriteLine($" def_qry.FilterGeometry: {geom_type}");
            System.Diagnostics.Debug.WriteLine("");
        }
    }
    Requirements

    Target Platforms: Windows 11 Home, Pro, Enterprise (64 bit)

    ArcGIS Pro version: 3.0 or higher.
    See Also