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 Search method will only contain data for the specified columns.

Namespace:  ESRI.ArcGISExplorer.Data

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

Syntax

C#
public Filter(
	string whereClause,
	string[] columnNames
)
Visual Basic (Declaration)
Public Sub New ( _
	whereClause As String, _
	columnNames As String() _
)

Parameters

whereClause
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.
columnNames
Type: array< System..::.String >[]()[]

An Array of column names for which data should be returned when a search is executed.

Examples

The code below demonstrates how to create a new Filter object that specifies the SQL clause and defines the columns to populate.
CopyC#
//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
//and define which columns will contain data when the search is executed
Filter searchCriteria = new Filter("CITY='RUNNING SPRINGS'", new string[]{"APN", "TRA", "SHAPE"});

//Execute the query
RowCollection rows = properties.Search(searchCriteria);
CopyVB.NET
'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
'and define which columns will contain data when the search is executed
Dim searchCriteria As Filter = New Filter("CITY='RUNNING SPRINGS'", New String() {"APN", "TRA", "SHAPE"})

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

See Also