QueryFilter

Base Type: Object

Derived Types: SpatialFilter

A class that filters data based on attribute values.

Property

Type

Description

FIDSet

FIDSet

An array of ObjectIDs.

FilterDefs

FilterDef[]

The FilterDefs property contains the set of FilterDefs objects that will be applied to the query.

OutputSpatialReference

SpatialReference

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

PostfixClause

string

A clause that will be appended to the end of the where clause. Most commonly used for clauses like ORDER BY.

PrefixClause

string

A clause that will be inserted between the SELECT keyword and the SELECT COLUMN LIST. Most commonly used for clauses like DISTINCT or ALL.

Resolution

double

Provides generalization of shapes returned by a filter. The generalization is performed on the server to minimize network travel. A zero value is default and will result in no generalization. The higher the value, the greater the generalization performed. The value is specified in feature units and generally should be roughly the size of one display pixel (measured in feature units).

SpatialReferenceFieldName

string

The field name of the output spatial reference.

SubFields

string

The comma delimited list of field names for the filter.

WhereClause

string

The where clause for the filter.

Remarks

WhereClause:

The QueryFilter filters data based on an attribute query. A string defining a where clause is required. An optional list of columns may be included to specify the column values to be retrieved. If no columns are specified, values from all fields will be returned.

When UseStandardizedQueries is True, you can only use StandardizedQueries. This means you will always format a query on a date field the same way or if you want to find all features where the value in a string field contains a specified keyword, you can use the same function name regardless of the underlying database type. Queries containing anything specific to the underlying database, for example, a function that is only supported by the database but is not part of the StandardizedQueries specification will fail.

When UseStandardizedQueries is False, the query must conform to the underlying database's syntax and use functions supported by that database

2/28/2020