This document is archived and information here might be outdated.  Recommended version.

IQueryFilterDefinition.PostfixClause Property (ArcObjects .NET 10.8 SDK)
ArcObjects Help for .NET developers > ArcObjects Help for .NET developers > ArcObjects namespaces > Geodatabase > ESRI.ArcGIS.GeoDatabase > Interfaces > IQ > IQueryFilterDefinition Interface > IQueryFilterDefinition.PostfixClause Property
ArcGIS Developer Help

IQueryFilterDefinition.PostfixClause Property

A clause that will be appended to the SELECT statement, following the where clause. Most commonly used for clauses like ORDER BY.

[Visual Basic .NET]
Public Property PostfixClause As String
public string PostfixClause {get; set;}
HRESULT get_PostfixClause(
  System.String* clause
HRESULT put_PostfixClause(
  BSTR clause
clause [out, retval]

clause is a parameter of type BSTR* clause [in]
clause is a parameter of type BSTR

Product Availability

Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.


The PostfixClause property allows for a postfix clause to be added to a query filter.  The PostfixClause property is a string property. It can be used to specify an ORDER BY clause for the query. Historically, this clause has not been supported due to issues with placement in the SQL generated for spatial and/or versioned queries. This property ensures proper placement of the clause in the SQL generated by the system.

See Also

IQueryFilterDefinition Interface