ArcGIS Pro 3.0 API Reference Guide
ArcGIS.Core.Data Namespace / QueryFilter Class / PostfixClause Property
Example

PostfixClause Property (QueryFilter)
Gets or sets the postfix clause used by the filter.
Syntax
public string PostfixClause {get; set;}
Remarks
A clause that will be appended to the SELECT statement, following the where clause. Most commonly used for clauses like ORDER BY. e.g., SELECT ArcGIS.Core.Data.QueryFilter.PrefixClauseP:ArcGIS.Core.Data.QueryFilter.PostfixClause.
Example
Searching a Table using QueryFilter
public async Task SearchingATable()
{
  try
  {
    await ArcGIS.Desktop.Framework.Threading.Tasks.QueuedTask.Run(() =>
    {
      using (Geodatabase geodatabase = new Geodatabase(new DatabaseConnectionFile(new Uri("path\\to\\sde\\file\\sdefile.sde"))))
      using (Table table = geodatabase.OpenDataset<Table>("EmployeeInfo"))
      {

        QueryFilter queryFilter = new QueryFilter
        {
          WhereClause = "COSTCTRN = 'Information Technology'",
          SubFields = "KNOWNAS, OFFICE, LOCATION",
          PostfixClause = "ORDER BY OFFICE"
        };

        using (RowCursor rowCursor = table.Search(queryFilter, false))
        {
          while (rowCursor.MoveNext())
          {
            using (Row row = rowCursor.Current)
            {
              string location = Convert.ToString(row["LOCATION"]);
              string knownAs = Convert.ToString(row["KNOWNAS"]);
            }
          }
        }
      }
    });
  }
  catch (GeodatabaseFieldException fieldException)
  {
    // One of the fields in the where clause might not exist. There are multiple ways this can be handled:
    // Handle error appropriately
  }
  catch (Exception exception)
  {
    // logger.Error(exception.Message);
  }
}
Requirements

Target Platforms: Windows 11, Windows 10, Windows 8.1

ArcGIS Pro version: 2.0 or higher.
See Also