Content Studio Web Content Management System
Assembly: CSServer5 (in CSServer5.dll) Version: 5.7.5016.0 (5.7.5016.0)
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.
[myField]=2 AND [yourField] BETWEEN 10 AND 20
[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)
Syntax
Property Value
Type: StringThe 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.
Exceptions
Exception | Condition |
---|---|
ArgumentNullException | The filter criteria cannot be null. |
CSInvalidParameterException | The T-SQL expression is invalid. |
Remarks
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 |
---|
The syntax of this filter is checked for Sql-injection attacks and will throw an exception if any invalid statement is supplied. |
Examples
See Also