LookupOrderedRowsCS

LookupOrderedRowsCS

This function returns a set of ordered rows from a Data Extension. This variation of the LookupOrderedRows function treats selection values as case-sensitive.

Arguments

LookupOrderedRowsCS(1,2,3,4,5,[6a,6b]...)

NOTE: Additional pairs of columns and values can be appended as arguments.

Example 1

The following illustrates the use of this function with the minimum number of arguments.

Data Extension: LoyaltyMembers

The LoyaltyMembers Data Extension includes these rows:

Here is an example utilizing the preceding context:

%%[
var @rows, @row, @rowCount, @numRowsToReturn, @region, @i

set @region = AttributeValue("Region") /* value from attribute or DE column in send context */
set @region = "north" /* or a literal value */
set @numRowsToReturn = 0 /* 0 means all, max 2000 */
set @rows = LookupOrderedRowsCS("LoyaltyMembers", @numRowsToReturn,"rank desc, firstName asc","region", @region)
set @rowCount = rowcount(@rows)

output(concat("region: ", @region))

if @rowCount > 0 then

  for @i = 1 to @rowCount do

    var @emailAddress, @firstName, @rank
    set @row = row(@rows, @i) /* get row based on counter */
    set @rank = field(@row,"rank")
    set @firstName = field(@row,"firstName")
    set @emailAddress = field(@row,"emailAddress")

    ]%%

    <br>Row %%=v(@i)=%%, rank: %%=v(@rank)=%%, firstName: %%=v(@firstName)=%%, emailAddress: %%=v(@emailAddress)=%%

    %%[

  next @i ]%%

%%[ else ]%%

No rows found

%%[ endif ]%%

Output

region: north
Row 1, rank: 2, firstName: Curt, emailAddress: curt@limedash.com
Row 2, rank: 1, firstName: Doug, emailAddress: doug@limedash.com

Example 2