Interface IQueryFilter

Namespace
ESRI.ArcGIS.Geodatabase
Assembly
ESRI.Server.Geodatabase.dll

Provides access to members that filter data based on attribute values and or relationships.

[InterfaceType(ComInterfaceType.InterfaceIsIUnknown)]
[Guid("FDFEBD93-ED75-11D0-9A95-080009EC734B")]
public interface IQueryFilter

Remarks

Unlike the QueryDef object, QueryFilter objects are supported across all workspace types, including shapefiles and coverages.

For datasets that support it, an ORDER BY clause can be set on the attribute query by using the IQueryFilterDefinition::PostfixClause property.

Properties

OutputSpatialReference[string]

The spatial reference in which to output geometry for a given field.

ISpatialReference OutputSpatialReference[string FieldName] { get; set; }

Parameters

FieldName string

Property Value

ISpatialReference

SubFields

The comma delimited list of field names for the filter.

string SubFields { get; set; }

Property Value

string

Remarks

When accessing rows from a subset of data defined by a query filter, all the fields will be present, but just those specified by SubFields will be populated with values. This ensures that the field index positions for an object remain constant no matter how it was hydrated.

When editing data, always use "*" for the SubFields property.

WhereClause

The where clause for the filter.

string WhereClause { get; set; }

Property Value

string

Methods

AddField(string)

Appends a single field name to the list of sub-fields.

void AddField(string subField)

Parameters

subField string

Remarks

The AddField method can be used to add a field to the SubFields list before the query is executed. Adding a field will clear the default "*" value from the SubFields. Setting it back to this original "*" can be done either by setting Subfields to "*" or to "".