XmlFilterObjectSortCommand Property Content Studio 5.7 SDK
Content Studio Web Content Management System

[This is preliminary documentation and is subject to change.]

Sets or gets the T-SQL clause that defines the sort instruction for the returned data.

Namespace: ContentStudio.Document.EPT
Assembly: CSServer5 (in CSServer5.dll) Version: 5.7.5016.0 (5.7.5016.0)
Syntax
Copy
public virtual string SortCommand { get; set; }

Property Value

Type: String
The T-SQL ORDER BY clause to use or an empty string. The default value is an empty string.
Exceptions
ExceptionCondition
ArgumentNullExceptionThe filter criteria cannot be null.
CSInvalidParameterExceptionThe SQL expression is invalid
Remarks

This value must be valid in a T-SQL ORDER BY clause, e.g. [myfield] DESC. All field names must appear between brackets and must exist in the field collection.

To add fields to the field collection use the AddField(String) method or one of the overloaded versions of this method.

All field names are case sensitive

Note Note
The syntax of this filter is checked for Sql-injection attacks and will throw an exception if any invalid statement is supplied.
Examples
Copy
[myField] DESC
See Also

Reference

XmlFilterObject Class
ContentStudio.Document.EPT Namespace