This document is archived and information here might be outdated.  Recommended version.


IARSearchDef.WhereClause Property (ArcObjects .NET 10.4 SDK)
ArcObjects Library Reference (PublisherControls)  

IARSearchDef.WhereClause Property

A SQL where clause for the search.

[Visual Basic .NET]
Public Property WhereClause As String
[C#]
public string WhereClause {get; set;}

Product Availability

Available with ArcGIS Desktop. Requires Publisher Extension.

Description

To search for a subset of ARFeature objects based upon a particular attribute you need to set the WhereClause property.The WhereClause represents an SQL �Where� clause; the syntax used to specify the WhereClause needs to be the same as that of the underlying database holding the data.

All ARFeature objects within an ARLayer share the same set of attribute schema; that is they have the same set of fields. The SQL string defining the attribute query is based upon one or more fields belonging to an ARFeature and consists of an IARFeature::FieldName, an operator and an IARFeature::Value. Note that these are are case sensitive. 

A field that returns an IARFeature::FieldType equal to the esriARFieldTypeGeometry constant cannot be used within the WhereClause, as this field stores the geometry or shape of the ARFeature object.

See Also

IARSearchDef Interface