ExecuteFilterOrderedRows()

Executes a data filter and returns an ordered rowset that contains the results.

This function only works with data filters that are based on data extensions. You can’t use this function with data filters that are based on profile attributes.

Use this function only on CloudPages, landing pages, microsites, and SMS messages created in MobileConnect.

1ExecuteFilterOrderedRows(dataFilterExternalId, numRows, sortColumn)

The ExecuteFilterOrderedRows() function has three parameters:

• dataFilterExternalId (string): Required. The external ID of the data filter to execute. This function only works with data filters that are based on data extensions.
• numRows (number): Required. The number of rows to return in the rowset. A value of 0 returns all results. There’s no maximum number of rows that can be returned.
• sortColumn (string): Required. The column to sort data by, followed by a space and either “ASC” (for ascending order) or “DESC” (descending).

This example uses a data extension called “MembershipRewardsProgramme,” which contains the data in this table.

The account also contains a data filter called “MembershipRewardsProgramme_50k points plus,” with an external key of c5a7e0d9-41e0-4068-bdcc-8766d7c1af94. This data filter searches for all values in which the number in the RewardsPoints column is greater than or equal to 50000.

This code example filters the data extension based on the data filter and sorts the results in descending order based on the values in the RewardsPoints column.

1<table>
2  <tr>
3    <th>Rank</th>
4    <th>MemberId</th>
5    <th>FirstName</th>
6    <th>Surname</th>
7    <th>RewardsPoints</th>
8    <th>Area</th>
9  </tr>
10%%[
11  Var @rows, @rowCount, @filterExtId
12  Set @filterExtId = "c5a7e0d9-41e0-4068-bdcc-8766d7c1af94"
13  Set @rows = ExecuteFilterOrderedRows(@filterExtId, 0, "RewardsPoints DESC")
14  Set @rowCount = RowCount(@rows)
15  If @rowCount > 0 then
16    For @counter = 1 to @rowCount do
17      Var @row, @rank, @memberId, @firstName, @surname, @rewardsPoints, @rewardsTier, @area
18      Set @row = Row(@rows, @counter)
19      Set @memberId = Field(@row, "MemberId")
20      Set @firstName = Field(@row, "FirstName")
21      Set @surname = Field(@row, "Surname")
22      Set @rewardsPoints = Field(@row, "RewardsPoints")
23      Set @area = Field(@row, "Area")
24]%%
25  <tr>
26    <td>%%=v(@counter)=%%</td>
27    <td>%%=v(@memberId)=%%</td>
28    <td>%%=v(@firstName)=%%</td>
29    <td>%%=v(@surname)=%%</td>
30    <td>%%=v(@rewardsPoints)=%%</td>
31    <td>%%=v(@area)=%%</td>
32  </tr>
33%%[
34      Next @counter
35  EndIf
36]%%
37</table>

The code example returns a table that contains values from the rowset.