This function executes the specified Data Extension Data Filter and returns a row set with the specified number of rows. Rows are returned sorted by the columns specified in the third parameter.<\/p>\n
NOTE: This function only works in a landing page, microsite page or CloudPage, or in an SMS message in MobileConnect.<\/p>\n NOTE: This function will not work on Profile Attribute Data Filters.<\/p>\n<\/blockquote>\n ExecuteFilterOrderedRows This function executes the specified Data Extension Data Filter and returns a row set with the specified number of rows. Rows are returned sorted by the columns specified in the third parameter. Arguments ExecuteFilterOrderedRows(1,2,3) Ordinal Type Required Description 1 String True Customer\/External Key of the Data Filter to execute 2 Number True Number of […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"yoast_head":"\nExecuteFilterOrderedRows(1,2,3)<\/code><\/p>\n\n\n
\n \nOrdinal<\/th>\n Type<\/th>\n Required<\/th>\n Description<\/th>\n<\/tr>\n<\/thead>\n \n 1<\/td>\n String<\/td>\n True<\/td>\n Customer\/External Key of the Data Filter to execute<\/td>\n<\/tr>\n \n 2<\/td>\n Number<\/td>\n True<\/td>\n Number of rows to return. A value of 0 returns all rows. No maximum limit on rows returned.<\/td>\n<\/tr>\n \n 3<\/td>\n String<\/td>\n True<\/td>\n Name of column used to sort resulting row set. Add a ASC<\/code> or DESC<\/code> suffix to specify the sort order. ASC<\/code> is the default. Specify multiple sort columns by separating them with a comma.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n
Example<\/h3>\n
%%[\n\nvar @rows, @row, @rowCount, @numRowsToReturn, @i\n\nset @numRowsToReturn = 2 \/* 0 means return all rows, no limit *\/\nset @rows = ExecuteFilterOrderedRows(\"DataExtension_Test_Example_Emails\",@numRowsToReturn,\"emailAddress desc\")\nset @rowCount = rowcount(@rows)\n\nif @rowCount > 0 then\n\n output(concat(\"rowCount: \", @rowCount))\n\n for @i = 1 to @rowCount do\n\n var @emailAddress\n set @row = row(@rows, @i) \/* get row based on counter *\/\n set @emailAddress = field(@row,\"emailAddress\")\n\n ]%%\n\n <br>Row %%=v(@i)=%%, emailAddress is %%=v(@emailAddress)=%%\n\n %%[\n\n next @i ]%%\n\n%%[ else ]%%\n\nNo rows found\n\n%%[ endif ]%%<\/code><\/pre>\nOutput<\/h4>\n
rowCount: 2\nRow 1, emailAddress is dale@limedash.com\nRow 2, emailAddress is suzy@limedash.com<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"