Adds an ORDER BY clause to the query using the FieldName of the SchemaItem. If you want to order the data by two columns you will need to call this method twice.

Parameters

item

A SchemaItem for the column you want to sort by

direction

Either Descending or Ascending

Example

VB.NET

emps.Query.AddOrderBy("ExampleColumn", WhereParameter.Dir.DESC)
emps.Query.AddOrderBy(EmployeesSchema.LastName, WhereParameter.Dir.ASC)
emps.Query.AddOrderBy(EmployeesSchema.FirstName, WhereParameter.Dir.ASC)

C#

emps.Query.AddOrderBy("ExampleColumn", WhereParameter.Dir.DESC);
emps.Query.AddOrderBy(EmployeesSchema.LastName, WhereParameter.Dir.ASC);
emps.Query.AddOrderBy(EmployeesSchema.FirstName, WhereParameter.Dir.ASC);

See Also

DynamicQuery Class | NCI.EasyObjects Namespace | DynamicQuery.AddOrderBy Overload List

---