ExecuteFilterOrderedRows

Overview

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

OrdinalTypeDescription
1stringRequiredExternal key of data filter to execute
2numericRequiredMaximum number of rows to return. A value of 0 returns all rows.
3stringRequiredName 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.