ExecuteFilterOrderedRows
Executes a predefined data filter and returns a rowset containing the results. You must use a data extension as the data source for the data filter. This function does not work with profile attributes. This function also allows you to control the sort order and maximum number of rows in the resulting rowset. Use this function only with landing pages and SMS messages.
Syntax
ExecuteFilterOrderedRows(1, 2, 3)
Function Properties
| Ordinal | Type | Description | |
|---|---|---|---|
| 1 | string | Required | External key of data filter to execute |
| 2 | numeric | Required | Maximum number of rows to return. A value of 0 returns all rows. |
| 3 | string | Required | Name of column used to sort resulting rowset |
Usage
The system returns all applicable rowsets. The function returns only five rows, and those rows use the IsActive column to sort the resulting rowset.