Initializes a new instance of the Filter class which can be passed into the Table.Search method to perform an attribute query on any type of Table. The RowCollection returned from the Table.Search method will contain data for all the columns in the Table.

Namespace:  ESRI.ArcGISExplorer.Data

Assembly:  ESRI.ArcGISExplorer (in ESRI.ArcGISExplorer.dll) Version: (


public Filter(
	string whereClause
Visual Basic (Declaration)
Public Sub New ( _
	whereClause As String _


Type: System..::.String

An SQL statement. The SQL syntax used in the WhereClause must be supported by the underlying database and additionally must be supported by the ArcGIS Explorer API. For more information and links to other documents which discuss SQL syntax, see How to Search a Table.


The code below demonstrates how to create a new Filter object that specifies an SQL clause in the constructor.
//Open ArcSDE geodatabase
Geodatabase gdb = new Geodatabase(@"C:\Data\SQLServer.sde");

//Open FirePerimeters feature class 
Table fires = gdb.OpenTable("sde.DBO.FirePerimeters");

//Open Properties feature class
Table properties = gdb.OpenTable("sde.DBO.Properties");

//Create the search criteria to find all Running Springs properties
Filter searchCriteria = new Filter("CITY='RUNNING SPRINGS'");

//Execute the query
RowCollection rows = properties.Search(searchCriteria);
'Open ArcSDE geodatabase
Dim gdb As Geodatabase = New Geodatabase("C:\Data\SQLServer.sde")

'Open FirePerimeters feature class 
Dim fires As Table = gdb.OpenTable("sde.DBO.FirePerimeters")

'Open Properties feature class
Dim properties As Table = gdb.OpenTable("sde.DBO.Properties")

'Get a fire polygon by its unique ID
Dim firePoly As Geometry = fires.GetRow(14).Geometry

'Create the search criteria to find all Running Springs properties
Dim searchCriteria As Filter = New Filter("CITY='RUNNING SPRINGS'")

'Execute the query
Dim rows As RowCollection = properties.Search(searchCriteria)

See Also