QueryFilter
Base Type: Object
Derived Types: SpatialFilter
A class that filters data based on attribute values.
Property |
Type |
Description |
---|---|---|
FIDSet |
An array of ObjectIDs. | |
FilterDefs |
The FilterDefs property contains the set of FilterDefs objects that will be applied to the query. | |
OutputSpatialReference |
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