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 >> |