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


IQueryFilterDefinition.PostfixClause Property (ArcObjects .NET 10.5 SDK)
ArcObjects Library Reference (GeoDatabase)  

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
[C#]
public string PostfixClause {get; set;}
[C++]
HRESULT get_PostfixClause(
  BSTR* clause
);
[C++]
HRESULT put_PostfixClause(
  BSTR clause
);
[C++]

Parameters 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.

Remarks

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

.NET Related Topics

Querying geodatabase tables