XmlFilterObjectFilterCriteria 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 argument to filter on.

Namespace: ContentStudio.Document.EPT
Assembly: CSServer5 (in CSServer5.dll) Version: 5.7.5016.0 (5.7.5016.0)

public virtual string FilterCriteria { get; set; }

Property Value

Type: String
The T-SQL argument should be written as the WHERE clause in an SQL statement. All field names must exist in the Fields collection, and must be escaped by brackets. The default value is an empty string.

ArgumentNullException The filter criteria cannot be null.
CSInvalidParameterException The T-SQL expression is invalid.

The SQL argument should be written as the WHERE clause in an SQL statement with field names surrounded with brackets and all fields must exist in the fields collection. e.g. [myField]=2 AND [yourField] BETWEEN 10 AND 20.

All field names are case sensitive

The filter can be used in combination with aggregate operations.

Note Note
The syntax of this filter is checked for Sql-injection attacks and will throw an exception if any invalid statement is supplied.

[myField]=2 AND [yourField] BETWEEN 10 AND 20
See Also