ArcGIS Explorer Component Help |
Filter Constructor (String, array<String>[]()[]) |
Filter Class Example See Also |
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.DataAssembly: 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)