toList(list [,options])

Remove duplicate entries from input array to yield a list of unique elements with optional sorting and grouping.

Parameter

list the array to filter

options a comma-separated Options String specifying
property-value pairs below:

Options String

sort Return sorted values {asc,desc,false}

sorton Measure by which to sort, e.g., sum(Total),

prior to filtering by maxrows

sorton2 Measure by which to sort, e.g., sum(Total),

after filtering by maxrows

remainder Label for 'Others' group in Top/Bottom-N

filtering. Omit option to suppress 'Others'.

maxrows Limits the number of rows returned.

distinct Return only distinct values {true,false}

The default is true.

date Return values grouped by date
{year/quarter/month/week/day/hour/minute/
second/weekday/monthname/weekdayname}

rounddate Same as 'date', but returns an array of dates

Example

Array1 = [2,3,1,2,3,3,2,2,1,0];
Array2 = toList(Array1,'sort=desc');  // returns [3,2,1,0]

See the toList section in the Report Scripting for applications and usage.

<< hints © 1996-2013 InetSoft Technology Corporation (v11.4) SI.2.2 Tables and Sections >>